how to list the user groups have access to authenticate on the authentication agents

[xjwang1]

Looking for a PSQL select statement to list all the user groups <-----> agents. 

Thanks for your help!

[EdwardDavis]

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 AgentName
from
ims_group_data g, am_agent_group ag,
am_agent aa, am_host ah
where
g.id = ag.group_id
and
ag.agent_id = aa.id
and
ah.id = aa.host_id;

-----------------

add 

and

aa.is_restricted is true;

if you only want to see restricted agents and don't care about logon aliases.

[xjwang1]

Thank you! You saved me tons of time.

[xjwang1]

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.

[xjwang1]

found the last_login_date from the am_token_oob.