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.

.. figure:: https://i.tpsdb.com/2017-03-29_17-10-17.png
    :target: #

    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
----

.. code-block:: sql

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