Client Management Suite

Hello

Is there a query we can create using the Report Wizard that lists machines without a particular software installed? If not a wizard, does someone know how to create a SQl query for the same? I have NS 7.1 SP2

Thanks.

SELECT vc.*

FROM vRM_Software_Component_Item sci

JOIN Inv_InstalledSoftware inst

   ON inst._SoftwareComponentGuid = sci.Guid

   AND inst.InstallFlag = 1

LEFT JOIN vComputer vc

   ON vc.Guid = inst._ResourceGuid

WHERE LOWER(sci.Name) LIKE '%software name here in all lower case%'

AND vc.Guid IS NULL

Hi Andrew

I created a computer report and copied this to the raw sql query window. I get a results windows with solid grey lines only and no computers listed?

Did you replace the 'software name here in all lower case' with something valid?  Like '%adobe%'?

Yes for example I was looking for computers missing the Enterprise Vault plugin, so I typed '%ymantec enterprise vault%' and I get the grey screen with no results.

Argh, my bad.  I finally have access to SQL to test this out.  Use this one, instead:

SELECT *
FROM vComputer
WHERE Guid NOT IN (SELECT inst._ResourceGuid
                   FROM vRM_Software_Component_Item sci
                   JOIN Inv_InstalledSoftware inst
                      ON inst._SoftwareComponentGuid = sci.Guid
                      AND inst.InstallFlag = 1
                   WHERE LOWER(sci.Name) LIKE '%enterprise%vault%')

Thanks Andrew, this one works! Does this check all machines or only managed machine?

With the use of vComputer, it's only managed machines.  If you want all machines use vRM_Computer_Item.

Thanks Andrew, appreciate it.