Client Management Suite

 View Only

  • 1.  query for non software data

    Posted Apr 24, 2013 05:10 AM

    hi

    is there any query/report which can show me the systems where the particular software not installed?



  • 2.  RE: query for non software data
    Best Answer

    Posted Apr 24, 2013 05:14 AM

    Read it

    https://www-secure.symantec.com/connect/forums/altiris-report-find-out-computers-software-not-installed

     

    Query

    SELECT vc.Name, vc.Domain, vc.[User]
    FROM vComputer vc
    LEFT JOIN Inv_AeX_OS_Add_remove_Programs arp
    ON vc.Guid = arp.guid
    AND arp.Name = 'Your Software Here'
    WHERE arp.guid 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: query for non software data

    Posted Apr 24, 2013 05:22 AM

    Check the Andrew Bosch comment in the attach forum

    https://www-secure.symantec.com/connect/forums/altiris-ns-find-list-machines-without-installed-software

    Try the attach



  • 4.  RE: query for non software data

    Posted Apr 24, 2013 05:24 AM

    hello,

    Look this discussion

    https://www-secure.symantec.com/connect/forums/report-software-not-installed#comment-6155611