Can you run a report to list agent hosts without a radius client?

[JohnWilliamson]

You can run a report to list all agent hosts with an associated radius client, can you run the opposite and list agents without a client?  We need to identify all the windows devices using our RSA server and the first step would be to get rid of those running radius.

[EdwardDavis · Accepted solution]

Not in a report, but on command line psql query you can do this [or variations of this theme]:

find agents that have corresponding radius clients

select * from am_host where primary_ip in (select ip_address from am_radius_clients); 

find agents that do not have corresponding radius clients

select * from am_host where primary_ip not in (select ip_address from am_radius_clients);