This section will dive into advanced report creation in IT Analytics 7.1 using Microsoft Report Builder to create and publish a SQL Server Reporting Services report.
Report Builder is a component of SQL Server Reporting Services that allows ad-hoc reporting functionality, enabling end users to build their own reports and charts. Users can then publish these reports into Reporting Services where they can be accessed, viewed and incorporated back into IT Analytics alongside existing reporting.
NOTE: Although the output produced by Report Builder is integrated with IT Analytics, the tools and subsequent query language behind it are separate Microsoft entities and are thereby outside the default capabilities of the IT Analytics product itself.
In this exercise we will create a custom dashboard that displays the trend of Software Updates.
OPTIONAL: In this exercise we will add an additional chart to the custom dashboard created above.
Click the icon in the Report Builder toolbar to save this report.