Something that most people are interested in doing, but the best way to do this is often not clear is monitor altiris for inactive computers.
I have used a variety of techniques to do this from Monitoring Agent Request Activity, Inventory activity and Basic Inventory activity.
Something that has always puzzled me is in relationship to Active Directory Import. When you do an AD Import, none of the dataclasses showing the "last inventory recieved" or Discovery Date ever changed, yet the Resource Manager Summary Showing "last inventory recieved" does. I wanted to know where this was coming from and monitor the activity from potentially stale records in Active Directory.
After running a trace on SQL using profiler, I found that the query is not retrieving non-specific data from vResourceUpdateSummary.
I decided to approach this in two steps: Create a view that gathers the same info the resource manager is displaying as "last Inventory recieved" and then be able to create reports based on my custom view.
Code for custom view:
Code:
--View Details
/*SELECT i.Name AS 'Computer Name', MAX(u.ModifiedDate) AS 'Last Inventory Received'
FROM dbo.ResourceUpdateSummary AS u INNER JOIN
dbo.Inv_AeX_AC_Identification AS i ON u.ResourceGuid = i._ResourceGuid
GROUP BY i.Name*/
Sample code for a report (assuming you name your view _mikes_inventory_monitor
:
Code:
Select i.[Computer Name], i.[Last Inventory Received]
from _mikes_inventory_monitor i
where datediff(dd,i.[Last Inventory Received], getdate()) < 30
