Automic Workload Automation

We recently received this question in a request; How do I find a list of all Users in each Client?  and I wanted to get the basics of the information out here.  Currently there is no Out of the Box way to do this and Support usually only provides SQL scripts for troubleshooting due to the unforeseen consequences this can have on a Production system.

I'm opening this post so that anyone with the custom SQL or any other methods can possibly assist with this.

Also, all tables can be found in the Documentation at the following:

http://docs.automic.com/documentation/AE/11.2/english/AE_DB_TABLES/tables/index.htm

The tables that are generally queried for this information are the UACL and the USR.

As always we suggest this is done in a Test Environment first to ensure there is no interruption to your Production Environment.

Do you mean something like this?

select oh_Client, OH_Name, usr_email1 from oh, usr where oh_otype = 'USER' and oh_deleteflag = 0 and usr_active = 1 and oh_idnr = usr_oh_idnr order by 1, 2

It looks like this was exactly what the user needed.

Thanks!