Would it be possible to have an email alert whenever there is a degraded memory size on one of the client desktops? We are seeking an option wherein the K1000 will report to the admin incase of hardware changes. TIA

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

The following SQL query shows computers where the TOTAL_RAM has reduced by more than 100 in the past day:

 SELECT * FROM ORG1.ASSET_HISTORY WHERE 
CHANGE_TYPE = "Modification" 
and FIELD_NAME like '%RAM%'
and TIME > DATE_SUB(NOW(), INTERVAL 1 DAY)
and (VALUE1 - VALUE2) > 100;

The reason I added the statement to check for computers where the change is greater than 100 is that my ASSET_HISTORY table shows a fair number of computers with a reported change of only one or two MB, that may be an issue with how the client is recording the RAM and it calculates it differently on different scans. 

You could create a report with this SQL code and have the report emailed daily to your admins.

Answered 01/23/2013 by: chucksteel
Red Belt

Please log in to comment

Answers

0

not directly, as the Kace is not a monitoring appliance. You need a monitoring tool (if you use a full Dell infrastructure use Open Manage Essentials on one system and Open Manage Client Instrumentation).

http://en.community.dell.com/techcenter/systems-management/w/wiki/1773.openmanage-client-instrumentation-omci.aspx

http://en.community.dell.com/techcenter/systems-management/w/wiki/1989.openmanage-essentials.aspx

With these tools you can create alerts and also send the informations directly to the KACE help desk.

See this video how to do this:
https://www.youtube.com/watch?v=awO_rofp6Uc

You also can use any other SNMP software to do similar.

Answered 01/23/2013 by: Nico_K
Red Belt

  • ok... thank you for the response, it means that we cannot directly integrate it, it will just communicate it through email... am i correct sir?
  • correct except for reports, but with the reports you cannot catch anything which the system itself can report (smart errors on hard disks or similar) except you have many reports which usually don't report anything. If you use the service desk it is a smart idea that the OME (which is built for this function) is reporting any errors to the helpdesk itself.
Please log in to comment
Answer this question or Comment on this question for clarity