Please do we have a query to run on sql that can generate all the list of servers currently being monitored on ump. I mean cpu, disk, memory details n all?
Please share the query.
I do not know of a single query you can run.
You can run a select * from s_qos_data to get a start with the information.
Thanks Gene .I will use this for the time being.
If anyone of your team can put input would be appreciable
casph02 Phani.Devulapalli Marco_Ippati davidm5.5 david.brenner.1960
La-Qa, Maybe you should be more specific on what are you trying to achieve. If you mean that you need a list of all the servers that appear in UMP they are in:
select name from cm_computer_system
Thanks for your input
I need query which can pull all the machines currently being monitoring in my ump with CPU disk and memory information in it.
Like how much CPU consumption available , how much memory n disk available of each system.
I want this in a list from a query
Hope u got my point
Pls go through.
Probe of Things - A Custom Probe That Does Things
I would prefer from the backend. Pls I know this can be acheivable as the information belongs from deffernet tables which need to pull. Pls if you share the query for this would be good ...
Also, please take a look at this thread this may help you.
Hello, take a look on BryanKMorrow answer to this thread :
Server Availability report , it has a nice query example,
About the tables i think you can find your som of your server informations on cm_computer_systems like what tipe of model is, the ip address but no data about QOS, on table s_qos_data you will find where you qos data are stored, the info are the r_table that identiy wich rn_qos_data00xx table is the raw data, the table_id that identify gives you the condition to find the data example ( where table_id = ? ) the qos and the target identifies the data you are colecting
If you are using the QOS_VIEWS script previously mentioned, you can use the following query to get a report for the windows servers, you will need to adjust the query for other operating systems.
uim/server_performance.txt at master · BryanKMorrow/uim · GitHub
You can try this one if you want the see which servers that is monitored by the cdm probe:
SELECT DISTINCT s.name, s.ip, sqd.probe
FROM cm_computer_system s,
WHERE s.cs_id = d.cs_id
AND d.dev_id = ci.dev_id
AND ci.ci_id = cim.ci_id
AND cim.ci_metric_id = sqd.ci_metric_id
AND sqd.probe = 'cdm'
Retrieving data ...