Would it be possible to have a K1000 email alert whenever there is a degraded memory size on one of the client desktops?
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
Community Chosen Answer
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.