Are there any queries for TSPS to show the list of Agent tags and their devices?

Are there any queries for TSPS to show the list of Agent tags and their devices?

Welcome BMC Customer Support Site Guest User

Manage Support IDs

Manage Support IDs

Use checkboxes to 'Remove support IDs/Users' or 'Allow to create Cases'

Support IDs for BMC Customer Support Site Guest User

Knowledge Article

Article Number

000208179

Old Article Number

000168526

Article Type

FAQ/Procedural

Title

Are there any queries for TSPS to show the list of Agent tags and their devices?

Summary

Are there any queries for TSPS to show the list of Agent tags and their devices?

Product

TrueSight Presentation Server

Component

TSPS Server

Applies to

TSPS 11.x +

Question

Are there any queries for TSPS to show the list of Agent tags and their devices?

Answer

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"

Attachment(s):