Symantec Management Platform (Notification Server)

 View Only

  • 1.  Altiris Report to find out Computers with software not installed.

    Posted Aug 12, 2009 11:12 AM
    Hi is there any way to create a report which will tell me the computers wich doesn't have a certain software installed?
    Thanks


  • 2.  RE: Altiris Report to find out Computers with software not installed.

    Posted Aug 12, 2009 06:26 PM
    A quick report:

    SELECT vc.Name, vc.Domain, vc.[User]
    FROM vComputer vc
    LEFT JOIN Inv_AeX_OS_Add_remove_Programs arp
    ON vc.Guid = arp._ResourceGuid
    AND arp.Name = 'Your Software Here'
    WHERE arp._ResourceGuid IS NULL
    AND vc.IsManaged = 1  -- Only machines with Altiris installed
    AND vc.[OS Name] LIKE '%Windows%'  -- In case you have Unix/Mac/etc


  • 3.  RE: Altiris Report to find out Computers with software not installed.

    Posted Aug 13, 2009 04:22 AM
    Hi, when i run this query i get this error
    Invalidid column name 'Guid'.

    Thanks


  • 4.  RE: Altiris Report to find out Computers with software not installed.

    Posted Aug 13, 2009 07:19 AM
    add vc.guid to end. This will display in the report, but you can hide it later.


  • 5.  RE: Altiris Report to find out Computers with software not installed.

    Posted Aug 13, 2009 08:13 AM
    Hello,

    Try changing arp.guid to arp._Resourceguid

    Regards
    Santi



  • 6.  RE: Altiris Report to find out Computers with software not installed.

    Posted Aug 13, 2009 02:17 PM
    Yeah, stupid me I do that all the time!  Thanks for finding that Santi.


  • 7.  RE: Altiris Report to find out Computers with software not installed.

    Posted Aug 14, 2009 05:15 AM
    Hi Santi, thanks it works now...
    One more question.. we have some software that doesn't show up on Add Remove programs...
    Is it possible to create a report that will look onto C:\Program Files\My Software and report which computers doesn't have this directory?
    Thanks