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) |