Generating Users Report


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.




  1. SQL Server Management Studio (SSMS)


  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.


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





Please sign in to leave a comment.