Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrade.
Please accept our apologies in advance for any inconvenience this might cause.

Help creating a software filter

Created: 08 Dec 2009 • Updated: 19 Aug 2010 | 9 comments
This issue has been solved. See solution.

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..

 

Comments 9 CommentsJump to latest comment

jharings's picture

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

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

maduran@srpnet.com's picture

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,

**SUCCESS STOPS WHEN YOU DO**

pbean's picture

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%'))
           )
     )
)

SOLUTION
Aaron T's picture

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

jharings's picture

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.

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

Aaron T's picture

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

jharings's picture

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.

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

Aaron T's picture

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.

jharings's picture

as the solution please.

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.