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

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    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"

     


    Article Number:

    000168526


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles