Client Management Suite

Hi

How create a dynamic filter to extract list of machines with a software (Microsoft Antixss for exemple ) version less than V4.2.1.

I choose Manage menu / all resources / software component, then right click on the software (Microsoft Antiwss V4.2.1), select Actions menu and Create installed software filter. The filter just extracts the machines where the selected version installed.

I am looking a way to change the filter or create a new filter for extract all machines with old version's product

Version Symantec Management platform V7.1

Thank you in advance

Find the filter you created and choose Edit.  In the WHERE clause, change IN to NOT IN.  Update filter name/description and save changes.  This gives you a filter for all computers without that software resource installed.

Does this answer your question?

thank you

 How can I extract the computers that have an older version of software ?

Easy.  That would be a SQL query like

SELECT vc.Guid

FROM vComputer vc

JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid

WHERE arp.DisplayName LIKE '%Adobe Reader%' AND (arp.DisplayVersion NOT LIKE '10%' OR arp.DisplayVersion NOT LIKE '11%')

Versions are normally stored as String data, so you need to use a statement similar to the above instead of a simple AND arp.DisplayVersion < 11.  Alternatively to NOT LIKE, of course you could use LIKE '5%' OR LIKE '6%' OR LIKE '7%' OR LIKE '8%' OR LIKE '9%', etc.

The best thing, though, is to define who needs ProgramX, and then let detection rules handle it for you.  Your detection rule can say that ProgramX is installed if HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ProgramX\VersionMajor is >= 10

AND

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ProgramX\VersionMinor is >= 2

Now it will install ProgramX on any computer whose ProgramX version is less than 10.2.  If it's 10.1, it gets 10.2.  If it's already been upgraded to 10.3, 10.4, or 11.0.0, no problem it will not overwrite the newer install.

Does this answer your question?