Scripting Question

How to get Memory Used

01/24/2017 1105 views
Currently, I notice in K1000 that there is a field for Memory Usage called RAM_USED, however when querying devices and using that label I set it > 1 because obviously there should be some sort of memory use on a windows system if someone is logged into it, however when I export the file to an xls or csv file the Memory Usage does not show up on the columns.

Is there a way with K1000 to monitor ram usage over a period of time and to send an alert to say if it is > 60

1 Comment   [ + ] Show comment


  • So you want RAM use % instead of total RAM used?

All Answers


What you need to do is go into (Reporting ---> Notification).

In notifications, you choose "ram used" from the dropdown list.

Set it to above the limit you need.......

choose the frequency of scans for devices ...... (to check for your conditions of ram use)...

Choose recipient email to send alerts to ......

Answered 01/25/2017 by: akmagnum
Red Belt

  • Now this number is it a number for the amount of ram used, like if different setups have different amounts of ram, will it just check that. Like say a user has 4GB and I want to see if they have used over 60% of ram am I setting the ram used to 2.5GB?

  1. Go to Reporting > Notifications
  2. Click Choose Action > New > Device Notification
  3. We're going to overwrite the filter with custom SQL, so no need to change it
  4. Set the desired frequency, title, and email
  5. Save it
  6. Click on the name of the notification
  7. Select "To edit the Notification using this editor, Click Here"
  8. Paste this in:

  CONCAT(ROUND((RAM_USED / RAM_TOTAL)*100,1),'%') AS 'Percent Used'

Save it and you should be good to go

Answered 02/08/2017 by: JasonEgg
Red Belt

  • Now can you add more to this like % of CPU in use or a set a threshold like if ram use % is > 60 % send an email?
    • that is the threshold for the email, because our SQL query includes it. Modify the number in the last line (.6 = 60%) to change the threshold.
    • CPU usage is not part of inventory. You would need to create a custom inventory rule to get it. See the first answer on this page: http://www.itninja.com/question/showing-cpu-usage-up
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