SCOM Reporting Services Part I: introduction

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email
Table of Contents

introduction

Hi there 

this article we will get some introduction about SQL Server Reporting Services SSRS  concept and how it is  integrated with SCOM  server 

later we will see how to configure SSRS for SCOM server 

SSRS concepts

SSRS stand for SQL Server Reporting Service 

Reports are a good way to get data specific for a certain time period,

 A report server is a computer that has an instance of Reporting Services installed.

 A report server internally stores items such as  reports, report-related items and resources, schedules, and subscriptions.

A report server can be configured as a stand-alone single server or part of SQL server or even  it can be integrated with SCOM  Server.

 You interact with report server items through the Reporting Services Web service, WMI provider, URL access, or programmatically through scripts.

 The way that you interact with a report server depends on the deployment topology and the configuration.

In our case [use SSRS for SCOM server ] : we will access SSRS from SCOM server itself [from reporting workspace ]

 

 

 

Reporting and SQL

most common SQL editions these days are 

  • SQL 2016 : SSRS is part SQL installation DVD , and there is NO need to be downloaded from MS website 
  • SQL 2017 : SSRS is NOT part SQL installation DVD , and there is  need to be downloaded from MS website 

 

SSRS & SCOM

Reports are a good way to get data specific for a certain time period,

A Reporting Server is a component of the SCOM architecture processing the reporting of monitoring data.

In SCOM 2007, the Reporting Server was an optional component, like the Web Console.

BUT ….

since SCOM 2012 : It became a mandatory component  

 

The Reporting Server is a server role processing the reporting in the SCOM environment. It requires to work a SQL Server Reporting Services instance and make the connection with the Operational Database and the Data Warehouse.

Conclusion

reporting service is ONE of the MOSt useful SCOM tools   to represent data in readable and analysable content  

this was a brief introduction to SCOM reporting services 

next article : we will discuss how to install and use reporting service 

 

Share this post
Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email

About Me

Our Power in Numbers

 17 

Courses

321

Articles

3,882

Images
and All configurations images are proudly made in Pioneers Lab

Articles By Course

Recent Articles

Subscribe

Contact us

have a challenge ? don’t hesitate to contact us