Symantec Management Platform (Notification Server)

 View Only
  • 1.  How do I write a filter using an SQL query to find installed applications?

    Posted Nov 22, 2010 10:33 PM

    I am wanting to uninstall an application that is installed on many machines. To do this I was going to create a filter that dynamically added machines that had the application and removed those that do not have the application. How can I do this?



  • 2.  RE: How do I write a filter using an SQL query to find installed applications?

    Posted Nov 23, 2010 02:30 AM

    Altiris6:

    You have to use the file inventory probably.

    Altiris7:

    Is the software an MSI and/or seen in the "Add/Remove Programs"? Then it should have been discovered and you should see the software component in "Manage->Software".

    You can just right click the software and select "Actions->Create Installed Software Filter".

    The data is updated every time the "Software Discovery" policy runs, or (depending on your version) an inventory task performing "Software" inventory, or you run a targeted inventory for this software component, or you (un-)install the software component using managed delivery.



  • 3.  RE: How do I write a filter using an SQL query to find installed applications?
    Best Answer

    Posted Nov 23, 2010 04:44 AM

    You could create SQL based filters/collections like in the examples below.

     

    NS6:

    SELECT ARP.[Name] AS 'App name', ARP.[Version] AS 'App version', W.[Name] AS 'Computer Name', W.[Guid] AS 'Guid' FROM [AeXInv_AeX_OS_Add_Remove_Programs] AS ARP           
    JOIN Wrksta AS W
    ON ARP.[WrkstaId] = W.[WrkstaId]           
    WHERE ARP.[Name] LIKE '%flash player%' 
    AND ARP.[Version] LIKE '%10%'     
     

    NS7:

    select ARP.[_ResourceGuid] '_ItemGuid', ARP.[DisplayName] 'App name', ARP.[DisplayVersion] ' App version', VC.[Name] 'Computername' from Inv_AddRemoveProgram AS ARP
    join vComputer AS VC
    on ARP.[_ResourceGuid] = VC.[Guid]
    where ARP.[DisplayName] LIKE '%Flash Player%'
    and ARP.[DisplayVersion] LIKE '%10%'