How to get Memory Used
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? - JasonEgg 7 years ago
-
Yes - dcook56 7 years ago
Answers (2)
Please log in to answer
Posted by:
akmagnum
7 years ago
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 ......
Comments:
-
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? - dcook56 7 years ago
Posted by:
JasonEgg
7 years ago
- Go to Reporting > Notifications
- Click Choose Action > New > Device Notification
- We're going to overwrite the filter with custom SQL, so no need to change it
- Set the desired frequency, title, and email
- Save it
- Click on the name of the notification
- Select "To edit the Notification using this editor, Click Here"
- Paste this in:
SELECT MACHINE.ID, MACHINE.NAME, RAM_TOTAL, RAM_USED,
CONCAT(ROUND((RAM_USED / RAM_TOTAL)*100,1),'%') AS 'Percent Used'
FROM MACHINE
WHERE (RAM_USED / RAM_TOTAL) > 0.6
Save it and you should be good to go
Comments:
-
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? - dcook56 7 years ago
-
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. - JasonEgg 7 years ago
-
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 - JasonEgg 7 years ago
