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
- Access Crystal Server 2020 or Crystal Reports 2020.
- Attempt to export a list of all users.
Cause
Resolution
- 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.
- To access the Query Builder, navigate to the URL:
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