/build/static/layout/Breadcrumb_cap_w.png

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.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: JordanNolan 6 years ago
10th Degree Black Belt
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ