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


Please log in to comment

Community Chosen Answer


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

CHANGE_TYPE = "Modification" 
and FIELD_NAME like '%RAM%'
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



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



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:

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