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.
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.