/build/static/layout/Breadcrumb_cap_w.png
11/23/2018 412 views

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

Comments


All 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.


Answered 11/23/2018 by: JordanNolan
Seventh Degree Black Belt

  • Will this report automatically generated to our mail or it should be pulled manually?
    • You can create the report and schedule it daily or what ever interval you like by going to Reports -> Schedule Reports on the K1000
      • I have scheduled it as said , but iam not receiving any mail reports as per schedule , where can i check about this ?
    • 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.

Don't be a Stranger!

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

Sign up! or login

Share