Are there any queries for TSPS to show the list of Agent tags and their devices? |
Please find the query to use to pull the tag associated with a specific agent select pad.tagid, pad.patrolagentip,dv.displayname, dv.dnsname from patrolagent_details pad, DEVICE dv where pad.patrolagentip = dv.ipaddress psql -U admin -d truesight -c "select pad.tagid, pad.patrolagentip,d v.displayname, dv.dnsname from patrolagent_details pad, DEVICE dv where pad.patrolagentip = dv.ipaddress" Additional Query with Policy name psql -U admin -d truesight -c "select distinct pad.tagid, pad.patrolagentip , pad.POLICIESAPPLIED , pad.hostname from patrolagent_details pad, DEVICE dv where pad.patrolagentip = dv.ipaddress group by patrolagentid, POLICIESAPPLIED ,hostname" |