Several months ago I created a script that would allow someone to extract information from the ConfigMgr SQL Database and e-mail that data. I wrote this as a workaround to SSRS subscription reports at the time as the...
Category - SQL Server
Jordan Benzing
How to use SMSProv.log to build reports
When working in ConfigMgr I frequently find information in the console is placed in inconvenient or inefficient locations especially when working with large chunks of information. Today I want to talk about a trick...
Patch Compliance Reporting in Configuration Manager with PowerBI
If you’ve done any work with System Center Configuration Manager sooner or later, you’ll get asked about leveraging it for patching. It might even be one of the first questions you get from management...
Unable to manage Subscriptions in SSRS for ConfigMgr 2012 Reports
When you install a Reporting Service Point in ConfigMgr 2012, you might want allow your users to be able to manage Subscriptions to the reports through the web interface of SSRS. In the default setup, the behavior is...
Nickolaj Andersen
Export and Import Reports in ConfigMgr 2012 with PowerShell
When I tweeted that I was working on a script to export reports from a Reporting Service point, I received a lot of response on that subject. In fact, I was only playing around to see if there was a quick way to...
Create Custom Reports for ConfigMgr 2012 with Report Builder
Reporting in ConfigMgr 2012 is a powerful way to get alot of information about almost everything in your environment. But sometimes the built in reports that Microsoft has provided is not enough. If you search on google...
Perform a test upgrade of the database before ConfigMgr 2012 R2 installation
Before you go ahead and begin the installation of ConfigMgr 2012 R2 in your ConfigMgr 2012 SP1 hierarchy, it’s recommended that you perform a test upgrade of the database. This post will help you along the way to...
Install SQL Server 2012 SP1 for ConfigMgr 2012 SP1
This post will cover the necessary steps in order to prepare a SQL Server 2012 SP1 installation for ConfigMgr 2012 SP1. Overview Create Active Directory accountsPrepare for the installationInstall SQL Server 2012...
Upgrade your Lab environment to ConfigMgr 2012 R2 Preview
I guess that you’ve already heard that Microsoft has released a preview of System Center 2012 R2 Configuration Manager Preview this week. Due to all the great new features, I think we should all upgrade our lab...
Shrink the SQL Server Reporting Services log database used by ConfigMgr 2012
When you install ConfigMgr 2012 and add Reporting Services (SSRS) in order to utilize all the built-in reports, you may not think of that the ReportServer_log.ldf file will eventually eat up all the disk space on the...