Client Management Suite

Dear All,

I have a report which returns Linux Computers and Linux Software Components, but I want to exclude the Software Components that are part of the Operating System.

Usually, I would make the items that I do not want to be in reports as being Unmanaged in the Software Catalog, but I have not tried reporting against only managed Software Components. I am guessing that Software Components that are unmanged are associated with the Unmanaged Resource Type? If so, what join would I need to do to exclude the unmanaged software?

Kindest regards,

QuietLeni

Dear All,

Just checking through the Installed Software report and I see this:

  JOIN dbo.Inv_Software_Product_State sps
    ON sps._ResourceGuid = sp.Guid
    AND sps.IsManaged = 1

Is this relating to the managed state of the Computers or the Software Components?

Neither -- and I haven't quite figured out what it does represent.  The values I see in my (relatively empty) Inv_Software_Product_State table are all 1's and 2's for IsManaged.

You want to look at the Inv_Software_Component_State table.  Here's an example query that uses the GUID of a random component I selected.  This one just isolated it so I could see IsManaged was 0, then managed it and re-ran the query and IsManaged was 1.

Your query for your report would join to Inv_Software_Component_State and the WHERE clause would be something like WHERE Inv_Software_Component_State.IsManaged=1

Does this help?

SELECT vi.Name, s.*

FROM vItem vi

JOIN Inv_Software_Component_State s on vi.Guid=s._ResourceGuid

WHERE vi.Guid='f87ed608-7758-4e0d-87f8-643e9fc47bb0'

The IsManaged state for Software Products and Software Components are held in Inv_Software_Product_State and Inv_Software_Component_State, respectively. 

0 = Unknown or Newly Discovered
1 = Managed
2 = Unmanaged

As Mike pointed out, you will want to JOIN on Inv_Software_Component_State WHERE IsManaged <> 2.  This will give you all components that are not equal to 2 (or Unmanaged).  If you need to make the link from Software Product to Software Component, use ResourceAssociation with ResourceAssociationTypeGuid = '9D67B0C6-BEFF-4FCD-86C1-4A40028FE483'