Symantec Management Platform (Notification Server)

 View Only
  • 1.  Basic Inventory Report Altiris 7.x

    Posted Sep 21, 2011 11:47 AM

    Hi, I wonder if there is a report of all hosts that reported no or basic inventory to the Notification Server setup.
    My idea is to check through altiris 7.1, if a team is removed from the domain.
    Any idea to solve this incident?

    In Altiris 6.x in the reports you have a report who is  "Agent basic inventory (no update N days)"... i don´t find this report in altiris 7.1.

     



  • 2.  RE: Basic Inventory Report Altiris 7.x
    Best Answer

    Posted Sep 21, 2011 02:08 PM

    Click Manage | Filters | Software Filters | Agent & Plug-in Filters

    There are now 3 Filters which begin with "Computers with Inventory data older than" choose which one works best for you.

    Also, here's the SQL to create your own report. Just edit the DATEADD field for ww or dd and the integer as approrpiate.

    This is for inventory older than 1 week.

    SELECT i.Guid FROM dbo.vComputer i
    JOIN dbo.Inv_Inventory_Results ir ON ir._ResourceGuid = i.Guid
    WHERE ir.[Collection Time] <= DATEADD (ww, -1, GETDATE ()) AND ir.Agent = 'Inventory Agent'