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.

https://i.tpsdb.com/2017-03-29_17-10-17.png — Sample Orgs Limit to Role Report¶

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 OrgsLimitToRole and 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.

Note

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.

Code¶

--Roles=Admin

SELECT OrganizationId ,
       OrganizationName ,
       LimitToRole
FROM dbo.Organizations
WHERE LimitToRole IS NOT NULL

Latest Update

11/13/2020

Modify image link with secure protocol.