Symantec Management Platform (Notification Server)

Hi All,

I need a filter which brings back PC's that do have a certain piece of software installed.

I've tried going through the 'query builder' but to no avail..The SM guide is pretty vague as well, and with no examples to lead off (I Couldn't find any specific software filters in the standard install)

Can someone please give me a hand to get off the ground with a custom report to look for either a certain file, MSI code, something..

 

What do you all need? Computer name, OS, user, software not installed? Is this software generally in add\remove programs?

I would also like to create a filter with machines that do not have a ceratin update.  For instance, if I wanted to update all systems that contained Adobe Reader version 9.3.0 to version 9.3.1 I haven't been able to understand the software filter method in CMS 7.  Any help would be appreciated.

Thanks,

Just replace %GUID% with the GUID of the software your looking for. I have it looking for 3 different pieces of software in the script below. if you only want to look for one piece of software then change:
"            (
            _ResourceGuid IN (SELECT _ResourceGuid FROM Inv_InstalledSoftware WHERE InstallFlag = 1 AND (_SoftwareComponentGuid =  '%GUID%'
   OR _SoftwareComponentGuid = '%GUID%'
OR _SoftwareComponentGuid = '%GUID%'))
           )
"
to 
            (
            _ResourceGuid IN (SELECT _ResourceGuid FROM Inv_InstalledSoftware WHERE InstallFlag = 1 AND _SoftwareComponentGuid =  '%GUID%'
           )

Please note, the software has to have reported in during software inventory/software discovery so you can check it's properties and get it's GUID.

----Full Script----

SELECT DISTINCT
    [vri1_Computer].[Guid] AS [_ResourceGuid], vmc.[User], vmc.[Name], vmc.[IP Address]
FROM
    [vRM_Computer_Item] AS [vri1_Computer]
INNER JOIN [Inv_InstalledSoftware] AS [dca2_InstalledSoftware]
    ON [vri1_Computer].[Guid] = [dca2_InstalledSoftware].[_ResourceGuid]
INNER JOIN [vComputerResource] AS [ajs3_vComputerResource]
    ON [vri1_Computer].[Guid] = [ajs3_vComputerResource].[Guid]
INNER JOIN vcomputer vmc
 ON [vri1_Computer].[Guid] = vmc.[Guid]
WHERE
(
     (
            (
            _ResourceGuid IN (SELECT _ResourceGuid FROM Inv_InstalledSoftware WHERE InstallFlag = 1 AND (_SoftwareComponentGuid =  '%GUID%'
   OR _SoftwareComponentGuid = '%GUID%'
OR _SoftwareComponentGuid = '%GUID%'))
           )
     )
)

Thanks for the reply,

I tried running this query agains tthe DB via SQL SMS and it didn't bring back anything.

When I tried to add it as a new filter (in Raw SQL query mode) the filter won't save and says theres an invalid resource or something?

I need to create a software filter for Symantec Endpoint Protection and Endpoint Encryption.

The idea here is to have the filters update as systems are inventoried, and if I use these filters for deployment, I can have the managed policy deliver to only PCs which are NOT in the software filter (which will detect installations)

Is this the best way to go about this?

The GUID for SEE is 7EDD1CCA-F75D-4DB2-A958-B2E83C840EAF

and for SEP its 2EFCC193-D915-4CCB-9201-31773A27BC06

copying and pasting data in the window in Altiris, presumably from a browswer window. Try copying it to something "neutral", like notepad first and then copying that into Altiris.

Haha thats interesting..got it pasted and its working.

However, still getting blank results..my GUID is wrong, where do I confirm it?

I just pulled what was in the windows registry for the uninstall items

as it exists in the software library (in the Altiris Database) not from the registry. I guess they could be the same, but I doubt it.

Nope, they're not the same..finally the missing link to my problem.

The way I found out the altiris GUID was to go to Manage - Software.
Then drill down - Software - Software Catalog - Installed Software.

In here you should see everything that the scans have picked up..do a search and double click the software you want the GUID for.

Then its just a matter of looking at the URL which will be something like

http://altiris-server/Altiris/SoftwareManagement/Resources/SoftwareComponentResourceView.aspx?ItemGuid=e8b42967-4588-409e-80c4-dad121085c68

and theres your GUID..

FINALLY!

Thanks everyone.

as the solution please.