Is there a query to list the TrueSight Infrastructure Management (TSIM) devices and their associated tags?

Manage Support IDs

Use checkboxes to 'Remove support IDs/Users' or 'Allow to create Cases'
Support IDs for BMC Customer Support Site Guest User
Profiles Which Include    Back to All Support IDs
 

Knowledge Article

Is there a query to list the TrueSight Infrastructure Management (TSIM) devices and their associated tags?
Is there a query to list the TSIM devices and their associated tags? We are trying to get a list of the TSIM device details and their tags
TrueSight Infrastructure Management
TSIM Administration Console/CLI
TSIM 11.x +
TrueSight Infrastructure Management
TSIM Administration Console/CLI
TSIM 11.x +
Is there a query to list the TSIM devices and their associated tags? We are trying to get a list of the TSIM device details and their tags
Please find the query to get the TAG with the corresponding TSIM device

select   DC.DEVICEDNSNAME ,SFI.FIELDVALUE  from   DEVICE_CNTL  DC  , SUPPLEMENTARY_FIELD_INFO SFI where DC.HOSTID = SFI.OBJECTID

For a list of devices without tags, please use the following:
select DC.DEVICEDNSNAME from DEVICE_CNTL DC where hostid not in (select objectid from SUPPLEMENTARY_FIELD_INFO)
 
TrueSight Infrastructure Management
TSIM Administration Console/CLI
TSIM 11.x +
Attachment(s):