Hi Team,
We have a request to generate the below mentioned reports(past 6 months) for the server which was removed yesterday in SCOM console.
is there a way to get the reports using the SQL query from DW or any other alternative options?
Regards,
Kumar B
The reports require is as below.
Percent Memory Used
Processor % Processor Time
Regards,
Kumar B
Hi @kumaravelu-1265,
You can follow the guides below:
Generate a Report for Servers % Percent Memory Used
Use the similar steps for the processor performance counter Processor % Processor Time.
(If the reply was helpful please don't forget to upvote or accept as answer, thank you)
Best regards,
Leon
Hi Leon,
Need report for the server/Agent which we had removed few days back from SCOM monitoring.
report require for the past 6months.
reports needed
Percent Memory used
CPU utilization
we no that we cannot pull the report from SCOM is there any way for us to generate from DWH
Regards,
Kumar B
For retrieving information of when a SCOM agent was deleted you could refer to the similar question in the thread below:
how to find out when an agent was deleted from scom
You can create reports of the Percent Memory used & CPU utilization if you check my links that I provided earlier, another way is to query the SCOM Data Warehouse, the following should get you started:
https://kevinholman.com/2016/11/11/scom-sql-queries/
4 people are following this question.
