Video Screencast Help

Basic Inventory Report Altiris 7.x

Created: 21 Sep 2011 • Updated: 22 Sep 2011 | 1 comment
ADG's picture
This issue has been solved. See solution.

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.

Comments 1 CommentJump to latest comment

cnpalmer75's picture

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'