1. Open and log in to Microsoft SQL Server Management Studio Express. (At the server, click on Start, select Programs, select Microsoft SQL Server and select SQL Server management Studio.) 
  2. Expand Databases.
  3. Expand AFWCORE.
  4. Expand Tables.
  5. Highlight dbo.CN_USERS.
  6. Click New Query and enter:
    select * from CN_USER
  7. Click Execute.
    NOTE: This will list all created users.
To only see Active users:
select * from CN_USER where status=1

To only see Inactive users:
select * from CN_USER where status=2

To only see Deleted users:

select * from CN_USER where status=3