Portrait Dialogue - How to extract a list of users

Product Feature: General Admin settings

Operating System: Windows 2008

Configuration: IIS
Details of the Portrait Dialogue (PD) users are available at two locations:

1. Dialogue Admin:
  • Log in to Dialogue Admin.
  • Navigate to the User and Security section, then select Users.
  • The users' information is available but it cannot be exported.

2. Portrait Dialogue database:
  • In the PD database, the table is that contains information about the users is called SYSTEM_USER_INFO.
  • Running the SQL query "SELECT * FROM SYSTEM_USER_INFO" will return all the user information stored in this table.
UPDATED:  April 10, 2017