When Power BI met the SCCM Community

SCCM Community meet Power BI – Power BI meet the SCCM Community… This blog post is the part 1 of 2 blog posts – and as you can see it’s all about introductions. Power BI is not a “new” thing, it’s been around for some time but is really just now starting to take off. (https://powerbi.microsoft.com/en-us/) So what is Power BI? It’s a new online service for us to get insight of our SCCM data, and for us to further display data internally or to others. Previous versions was a coop between Power BI and Office 365, but now we [...]

By | 2015-12-03T23:06:28+00:00 December 3rd, 2015|Configuration Manager (SCCM), Office 365|1 Comment

Troubleshooting: An error occurred when creating the WSUS Signing Certificate (Secunia)

Lately I have been doing some Secunia integrations with System Center 2012 R2: Configuration Manager (SCCM/ConfigMgr 2012). When you are setting up the connector between Secunia CSI and WSUS one of the first things the wizard is asking you to do is to Configure a WSUS Self-Signed Certificate, the WSUS signing certificate is required to create and install local packages. Without it, only packages from Microsoft Update will be installed. How-ever this time I got this error when trying to 'Automatically create and install certificate'  during the Connector Wizard: An error occurred when creating the WSUS Signing Certificate Now this [...]

By | 2015-10-20T20:14:46+00:00 October 20th, 2015|Configuration Manager (SCCM), Security|1 Comment

How to: Create custom SQL- based Reports in System Center 2012 R2: Configuration Manager

A customer asked me  for a “how-to” on how to Create reports in SCCM 2012, so why not share with everyone. This post is not intended to show how to write or design queries, but show you have to create  a report based on a SQL query you might already have. Even-though we are skipping how to write SQL Queries for know, this post is still going to be a bit long. Time for that cup of coffee! First some requirements: You need to have an SQL Server instance for SCCM with SQL Reporting Services running You need to have [...]

Error when running Application reports in ConfigMgr 2012

During the SQL Reporting Services site system role, SCCM automatically create a login in SQL and assign the required permissions to the account that you have specified. However I have seen several times that the account do not have the permissions required to run some of the Application reports.   When running the Software Distribution - Application Monitoring > All application deployments (advanced) report I get the following error An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'FirstMatchingAppOrCollection'. (rsErrorExecutingCommand) The EXECUTE permission was denied on the object 'fnGetSiteNumber', database 'CM_PS1', schema 'dbo'. To solve the [...]

State of the Empire: How to use E-mail Notifications in ConfigMgr 2012 SP1

In the old days you found out something was wrong when phones started to ring and senior management was at you "doorstep" with an angry look. In Configuration Manager 2012 SP1 we have many ways of being proactive with the state of our environment and the state of our precious clients. In this blog post ill cover: Client Status alerts (Check, Remediation & Activity) Endpoint Protection alerts (Malware detection & outbreak) Site Server status alerts (Site backup, Software Update sync, Database free space & replication) Reports Note: E-mail Notification component has to be configured in the Configuration Manager environment. Client [...]

Migrate reports from SCCM 2007 to SCCM 2012 SP1

The built-in migration wizard in ConfigMgr 2012 can migrate most objects but not reports. In ConfigMgr 2012 classical ASP reports (as we know them from earlier versions) are no longer supported. Migrate the classical reports to SQL Reporting Services in SCCM 2007 Below is a walk thru of how you migrate your existing classical reports to SQL reporting Services in SCCM 2007. Notice that you will still be able to run all classical reports after the migration. On you SCCM 2007 site server install either SCCM 2007 R2 or SCCM 2007 R3, both will add SQL Reporting Services support for [...]

By | 2013-02-09T09:42:03+00:00 February 9th, 2013|Configuration Manager (SCCM), General info|11 Comments

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 I had already configured ConfigMgr. 2012 to launch Reporting Builder 3.0 and not the default 2.0 version. When I finally managed to start the Configuration Manager Administrator console as administrator I successfully launched Reporting Builder 3.0 for information about tweeking ConfigMgr. 2012 to launch report [...]

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 assign the User/Group Read permissions on the Reporting Class. SQL Reporting Services Open the SQL Reporting Services website http://server/reports For SQL Reporting Services 2008 R2, Click Folder Settings. For SQL Reporting Services 2008, Click Properties. Click New Role Assignment Assign the Browser role for all [...]

By | 2011-02-24T07:14:11+00:00 February 24th, 2011|Configuration Manager (SCCM)|5 Comments