Generating Users Report

Overview

You might need to get a report of the users registered in Telescope. There is no available option in TSAdmin to achieve this, however, you can generate this report by following the process in this article. OnDemand customers should raise a support ticket for assistance with similar requests.

Information

Pre-Requisites

1. SQL Server Management Studio (SSMS)

<supportagent>

1. Information about the hosted environments of our customers is available on this page.
2. Access credentials for the instances can be obtained by raising a Task(Type: Task) on the ACLTOPS page requesting access to NorthPlains Production AD.

</supportagent>

Steps To Export

<supportagent>Agents should perform the following steps on the database of the customer by connecting with the SSMS tool mentioned above.</supportagent>

1. Determine the fields that you want to add to your report. Please check the available fields below.
   

   Field name	Description
   user_name	The login name for a given user
   member_of	The group name that the user belongs to
   email	The email address that is registered for the user
   fname	The first name of the user
   lname	The last name of the user
   date_created	The date that the user was registered in Telescope

   More information about other fields in the USERS table(page 72) can be found in the Database Internals document.
2. Connect to the database with SQL Server Management Studio.
3. Run the following query by replacing the <fields_list> section with your desired fields.
   

   SELECT <fields_list> 
   FROM   users 
   WHERE  member_of IS NOT NULL;
   

   Separate the fields with a comma and space. Please see the following example where the user_name, email, fname, lname, and member_of fields are selected.

   SELECT user_name, 
          email, 
          fname, 
          lname, 
          member_of 
   WHERE  member_of IS NOT NULL;
   

The query generates an output as follows (based on another example):

If you prefer, you can export a result as a CSV file by following the procedure below.

1. Right-click on the result.
2. Select Save Results As.
   
   
3. Select the save location.
4. Enter the File Name.
5. Click Save.