How to export users list from Administration and Monitoring Console?

Question

How to export users list from Administration and Monitoring Console?

Answer

This method can be used only in the on-premise installations of FlexiCapture 12 with access to the Database Server, where the FlexiCapture Database is located, and can not be used in FlexiCapture Cloud.

As of now, there is no such functionality built into the Administration and Monitoring Console. If you are using a SQL Database, you may extract this data from your FlexiCapture Database using Microsoft SQL Server Management Studio (or similar tools) manually from the dbo.Principal table.

Alternatively, you can utilize a command like this one-liner with replacing the necessary values in <*>:
sqlcmd -S "<YOUR_SERVER_NAME\INSTANCE_NAME>" -E -Q "SELECT [TenantId],[Name],[FullName],[Email],[UpperName] FROM <FLEXICAPTURE_DATABASENAME>.[dbo].[Principal] where IsSystemAdministrator = 1" -s"," -W -o <OUTPUT_FILEPATH>

Example:
sqlcmd -S "ABBYYUA-LT-073\ABBYYFRANK2" -E -Q "SELECT [TenantId],[Name],[FullName],[Email],[UpperName] FROM [DBFCR3].[dbo].[Principal] where IsSystemAdministrator = 1" -s"," -W -o C:\Users\fdelgado\Documents\AdminUsers.csv

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.

Recently viewed