query resource explorer for specific products RRS feed

  • Question

  • cognos plug-in for Excel does not show up in ARP but does under Hardware History/Installed Applications in the Resource Explorer. Looking to build a query to find the items, any ideas? 

    this is an example of the query I am working on but it is not pulling any values. 

    select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName = "%cognos%"


    • Edited by milagro78 Thursday, January 12, 2017 8:36 PM
    Thursday, January 12, 2017 7:12 PM