Create list of active accounts 1

[solmskid]

BOXi.R2 Enterprise

Need to create list of active accounts on Enterprise. Somewhat familiar with query builder, but do not know element names in the SI database. Where do I look?

Thanks for any suggestions.

 

[hilfy]

By "active accounts" I assume you mean active users, correct?

Here's a start:

Select SI_ID, SI_NAME, SI_DESCRIPTION, SI_DISABLED
From CI_SYSTEMOBJECTS
where SI_KIND = 'User'

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[solmskid]

Hilfy,

thanks for the response