Import Ready made Server Performance Report (Windows and UNIX) into SCOM


Hi,

just want to share with you a report that I created during my visit to customer, the report will summarize all windows and UNIX Performance into table (CPU, Memory and Disks). this kind of report is requested by many SCOM Customers, hope you can get benefit out of it.

attached the reports files (.RDL) that you need to import into your SCOM Report Server. below we will show how can you import and configure those reports to match the environment you are working with.

 

Below snapshot of the report data after running in my Lab:


Please feel free to add your comments and suggestions.

 


 

First thing: Download the report files attached in this article to your report server. Then follow the procedure below to import Server Performance Report (Windows or Unix) into SCOM Report Server and start using it inside SCOM Console reporting Tab:

Login to SCOM report Server

Browse IE to Reports URL http://<ReportServer>/Reports

Create new folder:

Verify Folder created. Click on the folder link

  

Folder should be empty, click upload file to upload RDL Files

 

Browse RDL Files (Downloaded) location and select the report file for upload then click OK

 

After the file is uploaded, we need to change the Database configuration to locate the one matching your scenario. Click on down arrow for the report and select Edit in report Builder. If this is the first time you are using Report Builder, it will be downloaded and will run shortly.

 

  

On Report Builder page, under Data Sources folder, right click on the Data Source OpsMgrDW and select Data Source Properties.

 

On Data Source Properties, click on Build

 

In Connection Properties, Type SQL Server Name and select SCOM DW Database then click Test Connection to verify connection status then Click OK

 

Run the report to ensure configurations are correct.

 

Save the configuration and close Report Builder.

 

Same steps (from 7 to 12) done on UNIX Report.

 

Now under SCOM Reporting Tab, you can see the two reports available to run on demand.

 

 

 Good Luck

 

 

Performance Reports.zip


Comments (10)

  1. DJ Grijalva says:

    Thanks!

  2. Marc says:

    great, thanks for sharing.

  3. Sooraj V says:

    I am not getting any reports. Can you help me please.
    ManagedEntityDefaultName Like 'Linux%' OR ManagedEntityDefaultName Like 'Red Hat %' OR

    What should i mention here.

  4. Damati says:

    Hi Sooraj V,

    Does Windows Performance Report works fine?
    what exactly do you have? UNIX, Linux, HPUX, … ?
    can you share more details?

  5. Sooraj V says:

    Hi Damati,
    I am having Redhat Linux and Ubuntu Systems in my environment. Windows team have customized their RDL file and it is working properly. The Group Name is "Unix/Linux Computers" under this only servers are showing.

  6. Sooraj says:

    I am using SCOM 2012

  7. joseph says:

    hello Damati thanks for this but when i run the windows version i get this error an error occurred during report processing rsprocessingAborted when i click on details i get i see this details invalid object name 'vManagedEntity' kindly advise

  8. Imtihas says:

    we want max value instead of average value

  9. Sameer says:

    Hi ,
    request you to help me , how can I target a particular group using this report.

    thanks,
    Sameer Harpanhalli

  10. Lacerda says:

    No errors but no information returned 🙁
    My SQL connection is fine.
    SQL 2016 – SCOM 2016

Skip to main content