Orgs Limit to Role¶
This is a report for Admins to see which organizations have a ‘Limit to’ role in the settings. If you add it to the menu, it will display under the Reports main menu.
Create Orgs Limit to Script¶
- Step 1
Go to Administration > Setup > Special Content > SQL Scripts and select the + New Sql Script File button.
Enter the name
OrgsLimitToRoleand press Submit.
- Step 2
Select and copy the code below and paste it into the new file.
Press the Save Sql Script button at the bottom of the file.
- Step 3
Now run the script by pressing the Run Script button at the top of the file.
After the report runs, scroll to the bottom of the report and click Add Report to Menu in order to make this available on the main Reports menu.
As you see in the script below, this is limited to those with Admin user role. Obviously, you can change this by replacing Admin with a different user role. However, this report is really designed to help the Admin stay on top of the organizations in the database.
--Roles=Admin SELECT OrganizationId , OrganizationName , LimitToRole FROM dbo.Organizations WHERE LimitToRole IS NOT NULL
Modify image link with secure protocol.