SQL Reporting Services

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 Henrik Hoe|2015-12-03T23:06:28+01:00december 3rd, 2015|Configuration Manager (SCCM), Office 365|1 Kommentar

Læs mere

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 Marius A. Skovli|2015-10-20T20:14:46+01:00oktober 20th, 2015|Configuration Manager (SCCM), Security|1 Kommentar

Læs mere

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 [...]

By Marius A. Skovli|2015-10-16T10:45:45+01:00oktober 16th, 2015|Configuration Manager (SCCM), SQL, SQL Server Reporting Services (SSRS)|3 Comments

Læs mere

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 [...]

By Kent Agerlund|2013-04-30T15:08:00+01:00april 30th, 2013|Configuration Manager (SCCM), General info, SQL Server Reporting Services (SSRS)|5 Comments

Læs mere

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 [...]

By Henrik Hoe|2013-02-21T13:01:00+01:00februar 21st, 2013|Configuration Manager (SCCM), SQL Server Reporting Services (SSRS)|6 Comments

Læs mere

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 Kent Agerlund|2013-02-09T09:42:03+01:00februar 9th, 2013|Configuration Manager (SCCM), General info|13 Comments

Læs mere

No SRS Reports showing up in SCCM console

During a recent SCCM 2012 installation for a customer, we ran into some strange problems with the Reporting services point and the SCCM console.

By Ronnie Jakobsen|2012-08-21T21:22:51+01:00august 21st, 2012|Configuration Manager (SCCM), SQL Server Reporting Services (SSRS)|8 Comments

Læs mere

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 [...]

By Kent Agerlund|2012-01-04T20:21:22+01:00januar 4th, 2012|Configuration Manager (SCCM), General info, SQL Server Reporting Services (SSRS)|Kommentarer lukket

Læs mere

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 Kent Agerlund|2011-02-24T07:14:11+01:00februar 24th, 2011|Configuration Manager (SCCM)|5 Comments

Læs mere