This information is being collected by the SMS Provider and sent back to be shown in the console. When you are working in the ConfigMgr console, almost anywhere you click you’re querying the database for information. Now that we’ve created the query to get devices that has Silverlight installed, we need to get our hands on the SQL query statement. Click Next again on the Summary page and then click Close. If you’ve never creating a query before, I suggest that you read this.Ħ. This post will not cover the basics of creating a Query. Click on Show Query Language and paste the following WQL query into the Query Statement field: select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Silverlight" In my lab I’ll just choose the All Systems collection.ĥ. Limit the collection to a collection that is suitable for your environment. In the Name field, give the new query a name e.g.
Go to the Monitoring node, right-click on Queries and select choose Create Query.Ģ. In this post we’ll be creating a simple Query to get all devices with any version of Silverlight installed.ġ. You may think, why are we creating an in-console Query first? The answer is simple, we will be using the this query to get the correct SQL query statement that is needed in order to create a custom report.
#Sql server report builder 2016 install
When you install the Reporting Services Point, it’s recommended to use a dedicated service account as the Reporting Services Point Account. In my case I’ve installed the Reporting Services Point on. In my lab environment I’ve got a Primary Site server called where the SQL server is running locally.
In order to use the Reporting functionality in ConfigMgr, you’ll need to have the Reporting Services Point Site System role installed on the SQL server for your Primary Site server.
#Sql server report builder 2016 how to
In this post I’ll walk through the steps to create a custom report for usage in the ConfigMgr console, and the best part, you don’t need any knowledge on how to write SQL queries. You could of course search the internet and hope that somene else has already published a query for exactly what you’re trying to accomplish, but most of the time you’ll not find what you’re looking for. What most of them lack though is how to create the actual query part of the report. If you search on google for how to create a custom report you’ll get several great articles/posts on the subject. But sometimes the built in reports that Microsoft has provided is not enough. Reporting in ConfigMgr 2012 is a powerful way to get alot of information about almost everything in your environment.
0 kommentar(er)
