Hardware change Alert
Hi Guys,
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.
Answers (1)
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:
Select
ASSET_HISTORY.CHANGE_TYPE As Count_CHANGE_TYPE,
ASSET_HISTORY.FIELD_NAME As Count_FIELD_NAME,
Count(ASSET_HISTORY.VALUE1) As Count_VALUE1
From
ASSET_HISTORY
Group By
ASSET_HISTORY.CHANGE_TYPE, ASSET_HISTORY.FIELD_NAME
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:
Select
ASSET_HISTORY.*
From
ASSET_HISTORY
Where
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.
Comments:
-
Will this report automatically generated to our mail or it should be pulled manually? - vinoth 6 years ago
-
You can create the report and schedule it daily or what ever interval you like by going to Reports -> Schedule Reports on the K1000 - JordanNolan 6 years ago
-
I have scheduled it as said , but iam not receiving any mail reports as per schedule , where can i check about this ? - vinoth 6 years ago
-
Can't seem to reply to the comment below. But have you checked your SMTP settings under Settings / Control Panel / Network Settings. If you are getting your daily Charlie Root reports then you probably have this setup OK.
I also believe in the first release of 9.0 and one of the last 8 versions there was a bug where schedule reports were not being emailed. Check your version and your SMTP settings. - JordanNolan 6 years ago