Hardware change Alert
Can anyone walk me through how to get mail alert on hardware changes in our inventory, let's say if RAM size changed we should be notified that this system memory has been increased/ decreased.
Thanks in advance.
You would have to build a custom SQL report based on the ASSET_HISTORY table. This table stores all the changes to the assets.
I took a quick look at my table and I saw that things like the hard disk size seems to get reported over and over because there is often a couple of MB difference between detections. Not sure why.
Here is a quick query you can run on your table to show you the types of changes and categories for those types:
ASSET_HISTORY.CHANGE_TYPE As Count_CHANGE_TYPE,
ASSET_HISTORY.FIELD_NAME As Count_FIELD_NAME,
Count(ASSET_HISTORY.VALUE1) As Count_VALUE1
And here is something I wrote to show you if there was a change to some key components like the C: Drive, Memory, or Video cards in the last 7 days:
ASSET_HISTORY.FRIENDLY_FIELD_NAME In ('Drive C: (Physical Disk) Total Size', 'Video Controllers', 'Ram Total') AND
TIME BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()
Use the first query to find things that you would like to get reports on and they schedule a daily report.