SAP Knowledge Base Article - Public

3574610 - Exporting User List in Crystal Server 2020

Symptom

  • The need to export a list of all users in Crystal Server 2020 and Crystal Reports 2020.

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x

Reproducing the Issue

  1. Access Crystal Server 2020 or Crystal Reports 2020.
  2. Attempt to export a list of all users.

Cause

Resolution

  1. Use the Query Builder to run the following query: SELECT SI_ID, SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_KIND='User'. This will display the user information, which can then be copied and pasted into a spreadsheet or text file.
  2. To access the Query Builder, navigate to the URL: 

    http://<servername>:<port>/AdminTools

See Also

Knowledge Article KB0036936 - How to access the Query Builder in SAP BI Platform

Keywords

Crystal Server 2020, Crystal Reports 2020, user list, export, Central Management Console, CMC, Query Builder, user information. , KBA , BI-BIP-CRS-FUN , Admin, Viewing & Scheduling Reports , Problem

Product

SAP Crystal Server all versions