In the previous post we created Queries and built query based collections.
In this post we will create and manage reports.
In this post we will create Queries and build query based collections.
Creation of Reports
Configuration Manager 2012 now works with SQL server Report Builder 2.0.
We have to first install the Reporting services point role for the server.
Go to Administration, Site Configuration, Sites, and Add Site System Roles. Select Next, and next again. Select Reporting Services Point and select Next.
On username, select set.. Select the SMSreports account and select Next.
Select Next and Next again to complete the installation of the new role.
Now go to Monitoring, Reporting, Reports. A list of reports becomes available.
If you go to Assets and Compliance, Asset Intelligence, and inventoried software you should see some software listed. If not you may have to wait for awhile for SCCM to build this information from your clients. It can take days!
Creating a Report
To create a Report select Reports and select Create Report. The type of reports we create will be TSQL reports. WMI reports get pulled from SQL commands. Select SQL-based Report. In name type in: Memory.
Select Browse next to path. Select Hardware – Memory and select OK. Select Next.
Select Next again to create the report. The report has been created. Select Close.
It will create the report builder application and open it in Internet Explorer. I had to copy the url to get it to launch from Internet Explorer to SQL Studio as it would not work in chrome.
Click on Table or Matrix
Select Create a Dataset. Select Next. The Data Source Connection is connected to: http://configmgr/ReportServer/ConfigMgr_BP1
Select Next. You will be prompted with entering a User account that has permission to connect to the Database. Enter your credientals and select Next.
Under database view select dbo, Views, v_GS_DEVICE_MEMORY, and select StorageTotal0.
Select Next. Select the StorageTotal0, that will put it in the values section. Select Next.
Select Next again. On the style select Ocean, select Next and the field has been added to the report.
The storage field has now been added to this report.
Permission changes to the ConfigMgr website
Defining permissions of the ConfigMgr site can help define what reports and access you would like people to have. Some people may not need access to the entire site in order to do their job.
Go to http://configmgr/Reports/Pages/Folder.aspx the root of your Configuration Manager reporting. Select folder settings. Select New Role Assignment. Here is where you can define a new role for viewing data on the site.
If you now go to Configuration Manager, Monitoring, Reports and the All software Companies report, Properties, Security Tab, you can see which users have access to this report.
In order to change permissions to this report you have to break inheritance of this report, by selecting Inheriting rights from parent object. Now when you select Add you can see the different permissions you can give to this report.
You can define what reports for users to receive on a regular basis. They allow the depositing of the file on a fileserver, or if you have exchange installed they can send it to a user via email.
Go to Reports, and select Computers with a specific amount of memory. Right click on the item and select Create Subscription. On file Name type: Memory, on Path type: \\configmgr\share, on Render format select: CSV, Username use: SMSAdmin, enter the password and select Next.
On the delivery schedule, select Next.
You can specifically set in the amount of memory you would like to see:
Select 2097000 and select OK. Select Next. The subscription has now been created.
If you receive an error that the SQL server agent is not running, go to services.msc and start the SQL Server Agent.
On the next post we will package and deploy software.