...
| Programs/Tabs | Standard Crystal Reports |
|---|---|
| Z_Groups_Default_Tabs.pdf | Z_Groups_Default_Reports.pdf |
ADDITIONAL USEFUL SCRIPTS
Additional scripts have been attached to this article to assist with managing Staff Job Positions to Security Groups matching.
Staff Security Groups with Job Position Link.sql
List all staff along with their user groups.
If staff member does not have any groups they are still listed.
If they have multiple groups all groups are listed.
GroupSource indicates if the group may have been added by Job Position (JobPositionsConfigGroup link ecists) or if it has been manually added.
This list only includes users that are also created as Staff.
Staff Job Position Group Security - view missing groups.sql
This script outputs the security groups that are missing from users based on Job Positions.
Uses the JobPositionsConfigGroup link.
It can easily be changed to an insert query by un-commenting the INSERT line.
This query is INSERT only and will not remove any groups - USE WITH CAUTION!
| Attachments |
|---|