Saturday, 30 July 2016

System Center Operations Manager 2012 R2 - About Reporting & some useful Reports - Part 7

Hello Everyone,

In this blog, I will share information about Reports in SCOM. 

Reports are basically used for getting detailed information of either utilisation, performance or health status of monitored objects or other applications reports like any web applications or database reports etc.

SCOM generates many reports based on analysing and fetching data for monitored objects from both operation manager database & data warehouse database. You can also exports those reports in multiple formats like excel, pdf etc.


You can also DOWNLOAD the soft copy of this post by Clicking Here!


Part 1: To see SCOM Prerequisites & Installation Process, Click Here!

Part 2: To see SCOM Post configurations, Click Here!

Part 3: To see SCOM Console Overview, Click Here!

Part 4: To see SCOM Agent Installation Process, Click Here! 

Part 5: To see PRO-Tips configuration between SCVMM & SCOM, Click Here! 

Part 6: To see configuring monitors & rules, Click Here!

Let's start understanding SCOM Reports in more details...


ABOUT REPORTS:


Technical Term: Reports are easy to read data which is generated by running queries against operation manager & data warehouse databases.

Microsoft has shared definition on each default reports in SCOM, To see, Click Here!


Types of Reports:


  • Published Reports: These are predefined generic reports which are available after installing SCOM & Reporting Service which generates reports based on monitored objects.

  • Linked Reports: These reports are linked to existing reports which fetches data & generate more detailed information using custom management packs.

  • Custom Reports: You can also generate custom reports by writing custom queries in visual studio and using custom management packs.

  • Report Solution: These are also customised reports which uses visual studio scripting & different expertise queries to generate high level or critical data reports.


Components of Reports:


  • Databases - Operation Manager & Data warehouse Databases
  • Data warehouse Server 
  • Management Pack
  • Management Server
  • Operation Manager Reporting Server
  • Reporting Data warehouse



How to Run a Report in SCOM:



Open SCOM Console, Click on Reporting Tab, Expand Reports, Click on any reporting folder (I will show You Host Utilisation Report in SCVMM Report Folder), Select the Report which You want to Run & Click on Open in Task Menu on right side of console:



A new windows will open. You can change Time period for report & Time Zone as per Your requirement. Click on Add Object:



Click on Option to see which class is selected: (NOTE: Appropriate Class must be selected for the report else no data will be displayed. You have to be careful for selecting class):



By Default VMHost Class is selected for Host Utilisation Report. To see all list of classes click on Add:



Click on Search, It will display all classes list from which You can select appropriate class for report:


You can select any class, click add and then Click OK, OK:



Once done, Click on Search:



Select Host, Click on Add & OK:




Object (Host) is added so Click on Run:



Below is the result of Host Utilisation Report for the time period selected:



This is how all reports are opened. You need to select appropriate class for the report.

Also, You can export reports in multiple formats as shown below:

  • XML file with report data
  • CSV (comma delimited)
  • PDF
  • MHTML (web archieve)
  • Excel
  • TIFF File
  • Word


How to schedule a Report:



You can also schedule any report to be exported on daily/weekly/monthly basis and save then at any local or remote location.

To schedule any report, Select report & Click on Schedule in Task menu on right side of console:



Give description & delivery method. There are 3 delivery methods:

  • Windows File Share: For this, You must create any shared folder where exported file will be saved.
  • Email Delivery: In this, You have to first enable email settings in SSRS. Once done, You will be able to share exported report to added emails.
  • Null Delivery Provider: This is highly specialised delivery extension which is used to pre-load a cache with ready-to-view parameter reports. This is not available for users in individual subscription but used by administrators in data-driven subscriptions to improve reporting server performance by pre-loading the cache.

In my screenshot, EMail Delivery option is not available because it's setting is not enabled so I have selected Windows File Share:



After Selecting Windows file share option, You have to provide below details:

  • File Name
  • File Path
  • Render Format
  • Write mode - Auto-increment or Overwrite
  • User Name
  • Password


After Providing details, Click Next & Select schedule times as per Your requirement:



Select the Parameters: Object, Time Duration & Time Zone, Click Finish:



and,



Now click on Scheduled Reports to see all the reports which are scheduled, By Selecting scheduled report, You can Open, Edit Schedule or Cancel Schedule by clicking option in Task View on right side:




Report is successfully exported:




You can also view report:



This is the all process for scheduling any report.


Some Important Reports which gives useful monitored data reports which are good to know:


There are some important reports which can give You very useful monitored data for Your organisation so I will share screenshots for the same.


Microsoft Generic Report Library:



Microsoft ODR Report Library:




Microsoft System Center Virtual Machine Manager 2012 R2 Reports: (This folder will be avialble after configuring PRO-Tips between SCOM & SCVMM which I have shown in previous blog post):



System Center Core Monitoring Reports:




Windows Server Operating System Reports:





Some Sample Reports:


Alerts Per Day Report:




Management Pack ODR Report:




Most Common Alerts Report:



and,



Data Volume by Workflow & Instance:

Virtual Machine Utilization:

Performance By System:


and,



and,



and,




Like above, You can view many reports. SCOM is powerful tool for monitoring & reporting Your infrastructure, databases & applications... :)



Happy Reading!!!


If You like my post then follow my updates:

Join my Facebook group for updates on trending technologies/technical references/issues etc:

https://www.facebook.com/groups/technicalskillsenhancementworld/



No comments:

Post a Comment