Configuration Manager 2007 Reporting Point – Cannot set application role ‘webreport_approle’
Stumbled over an issue with a Configuration Manager 2007 Reporting point this morning. The customer couldn’t run a report, instead they got this message in the browser: Cannot set application role ‘webreport_approle’ because it does not exist or the password is incorrect For what-ever reason it turned out the application role has dropped the default [...]
Category: Config Mgr. Inventory and Reporting, Configuration Manager, Troubleshooting | Comment
Error installing SQL Reporting Builder 3.0 in ConfigMgr. 2012
It has happen to me before, and it will happen again. I ran my ConfigMgr. 2012 administrator console without starting it as Administrator. When trying to edit a report I got the error message: Report Builder 2.0 is not installed as a click-once application on report server The error message is kind of funny, as [...]
Category: Config Mgr. Inventory and Reporting, Configuration Manager, SQL Reporting services, Tips and tricks | Comment
Easy way to change logos in Configuration Manager 2012 reports
During my session I03 @ Microsoft Campus Days in Copenhagen I demonstrated how to easily change the default logo on all the canned reports in Configuration Manager 2012. As promised on the session, here are the needed steps. My demo environment has SQL Reporting Services and Configuration Manager installed in D:\Program files on the same [...]
Category: Config Mgr. Inventory and Reporting, Configuration Manager, Configuration Manager 2012, Tips and tricks | 2 Comments
Asset Intelligence 3rd. party software utility
Configuration Manager 2007 and 2012 allows you to import licens information from a CSV file. The data are shown in the License 15A – General License Reconciliation Report. The problem for many is, that it’s often a bit to difficult to create the CSV file in the correct format. Highly inspired by the CM2007 AILW [...]
Category: Config Mgr. Inventory and Reporting, Config Mgr. Tools, Configuration Manager 2012, Tips and tricks | 8 Comments
How to assign basic reporting permissions in Configuration Manager R2
Configuration Manager 2007 R2 offers two options when it comes to reporting. The classical reports and SQL Reporting Services. This post will explain how you assign permissions to both solutions. Classical reports Add the user/group to the local SMS Reporting Users group on the Reporting Point In the Configuration Manager console, navigate to Security and [...]
Category: Config Mgr. Inventory and Reporting, Configuration Manager | 3 Comments
Configuration Manager Power Management charts won’t show
At a few sites I have experienced a problem where none of the Power Management charts will show in the canned SQL Reporting Services reports. Everything looks like fine from the client side, power management is part of the inventory and data is being send correctly back to the Management Point. Yesterday evening I found [...]
Category: Config Mgr. Inventory and Reporting, Configuration Manager, Configuration Manager R3, Troubleshooting | Comment
Modifying the execution account after installing Configuration Manager R3
In a previous post I described how you create and configure an execution account for SQL Reporting Services and Configuration Manager R2. The execution account is a requirement for those who want to use the e-mail subscription feature. Due to changes in security the execution account does not have the needed permission to open the [...]
Category: Config Mgr. Inventory and Reporting, Configuration Manager, Tips and tricks, Troubleshooting | 2 Comments
SQL Reporting Services and antivirus settings
Just installed and configured SQL Reporting Services 2008 with ConfigMgr. 2007 R2 SP2 this morning. Everything went smoothly except for one minor detail; I got an error in my mail subscription: Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not [...]
Category: Config Mgr. Inventory and Reporting, SQL Reporting services, Troubleshooting | 1 Comment
Using the archive_reports.sms file to monitor inventory data
As you might know SMS/Configmgr; has some secret files that can change the way agents behave. One of the files is called archive_reports.sms. When you add this file to the inventory temp folder (\system32\ccm\inventory\temp\) it will prevent the inventory xml files from being deleted after they are send to the management point. This can be [...]
Category: Config Mgr. Inventory and Reporting, Tips and tricks | Comment
Audit software installations r2
With this basic report you will be able to monitor any new applications installed and registrered in Add/Remove programs during the last 7 days on a client computer. Thanks to Claus Codam for helping out The SQL code SELECT TOP (100) PERCENT dbo.v_R_System.Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0, DATEDIFF(Day, CONVERT(date,dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0), GETDATE()) AS [days since installed] FROM dbo.v_R_System INNER [...]
Category: Config Mgr. Inventory and Reporting, Software distribution | 12 Comments
