Looking for a PSQL select statement to list all the user groups <-----> agents.
Thanks for your help!
This rough query will list all groups tied to an agent
either for logon aliases, or for group restriction.
select g.name as GroupName, ah.name as AgentNamefrom ims_group_data g, am_agent_group ag,am_agent aa, am_host ahwhereg.id = ag.group_idandag.agent_id = aa.idandah.id = aa.host_id;
aa.is_restricted is true;
if you only want to see restricted agents and don't care about logon aliases.
Thank you! You saved me tons of time.
one more question: trying to pull out the last date the token was used for authentication but could not find that in all the token related tables.
found the last_login_date from the am_token_oob.
Retrieving data ...