sql query to get list of users without a group

[Sunil Malli]

Hello Community,

Can anyone help me with a sql query to get the list of users without a group assigned in Automic Automation engine 12.3.4.

Regards,
Sunil

[Peter Grundler]

Hi Sunil,

this query should do the job:

select OH_Client, OH_Name
from USR
inner join OH on (OH_Idnr = USR_OH_Idnr)
where USR_OH_Idnr not in (select USRG_USR_Idnr from USRG)
and OH_DeleteFlag = 0
order by OH_Client, OH_Name;

regards,
Peter

------------------------------
For AUTOMIC trainings please check https://www.qskills.de/qs/workshops/automic/
------------------------------

[Sunil Malli]

Hi Peter,
Thanks a lot for the quick response.
That is very helpful for me.
Regards,
Sunil