Reports - Searching multiple values for the Authenticating Agent Name field

[ReggieFisher]

Hello, 

When generating a report, how do you search for multiple Authentication Agent Names? I tried separating with semi-colon, and comma... but got no results. See attachment.

[EdwardDavis · Accepted solution]

Can't be done in a report.

One name only in that field:

Hostname of an authentication agent. Enter the hostname exactly as it was entered in the Authentication Agent page of the Security Console.
This value is case-sensitive. Authenticating Agent Name.

The database has a table am_host which has names and IP's of all agents and also Primary and Replicas (since they each have the radius agent for each system radius engine)

To go further, each agent could have secondary (alternate) IP's, this will list agents and any secondary IP's

select h.name, h.primary_ip, aa.ip_addr as alt_ip from am_agent a

join am_host h on a.host_id = h.id left join am_agent_alternate aa on a.id = aa.agent_id;