Kent Agerlund

About Kent Agerlund

Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

News in configMgr 2012 R2

Today at TechED 2013 in New Orleans the System Center 2012 Configuration Manager and Service Pack 1 Overview WCA-B328 also contained some very need news about the upcoming ConfigMgr 2012 R2 release. Below are the info that I managed to take from a very awesome presentation. Windows 8.1 support for a lightweight ConfigMgr agent (BYOD) scenarios Corp owned devices still have the “full” ConfigMgr agent Mobile device management with Intune Some of the key take aways from the session was: Selective wipe New branding options for the portal Company Apps for IOS and Android Software push support for IOS Workplace [...]

By | 2013-06-04T11:26:07+00:00 June 4th, 2013|Configuration Manager (SCCM)|1 Comment

Notes and slides from the TechEDNA 2013 precon – Simplify and Maximize System Management with Microsoft System Center 2012 SP1 – Configuration Manager: Notes from the Field

First, a huge thank to all the attendees in the Sunday precon session. Johan and I asked for questions in the morning, and I must say that I do not remember the last time we got so many good questions. Download the slide deck Download information about SQL recommendations: SQL re-indexing scripts: Working with Management Point and SQL replicas:Step-bystep guide to create a Management Point replica: Download the Collection update scripts Migrate reports from ConfigMgr 2007 to ConfigMgr 2012: Update the package source location: Shutdown tool: Managing 3rd. party software updates: Complete SCUP 2012 [...]

By | 2013-06-03T20:55:59+00:00 June 3rd, 2013|Configuration Manager (SCCM), Events|2 Comments

Where are my Software Update state messages

My experienced ConfigMgr 2007 administratos are wondering how it can be that Software Update compliance reports are not showing states like “Waiting for Maintenance Windows” but only Enforcement State unknown or Compliant. The answer to that question can be found in the State Message detail settings for the software update deployment. By default only Error and success messages are reported. Example 1 – using the default software update state details settings:   Example 2 – Software Update deployment configured to send all state messages :   Controlling the state message detail level The correct way to configure the state message [...]

By | 2013-05-31T13:13:53+00:00 May 31st, 2013|Configuration Manager (SCCM), General info|2 Comments

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

System Center 2012 ConfigMgr Advanced infrastructure session notes

Here are the promised links to our demos from the advanced infrastructure session @MMS 2013 in Las Vegas. View the session on channel 9 and download slides: Working with Management Point and SQL replicas: Step-bystep guide to create a Management Point replica: Video on setting up a Management point replica:  Working with Software Updates: Software Updates: Installing Workgroup clients: Orchestrator runbook by Andreas Falck to install Workgroup clients with PKI Distribution Points and WAN: Coretech Distribution Point Utilization Monitor: Brian Mason on twitter: @AbetterPC Brian Mason blog: Kent Agerlund on twitter: @Agerlund

By | 2013-04-17T13:58:43+00:00 April 17th, 2013|Configuration Manager (SCCM)|7 Comments

Coretech Distribution Point Utilization Monitor

Ever wanted to see how much content is being downloaded by each ConfigMgr. client and from where? Then look no further, the Coretech Distribution Point utilization monitor will give you the answers. The tool has a server portion with a database and a client that you install on all distribution points. Once a day the client (agent on the Distribution Point) will collect information from the IIS log files, convert the files to a CSV format and copy them to the server. The server uses a scheduled task in Windows to import all data into the database. Once in the [...]

By | 2013-04-16T23:45:42+00:00 April 16th, 2013|Configuration Manager (SCCM), General info|31 Comments

Slide deck from Birds of a Feather “BOF08 PowerShell – Examples from the Real Word”

First, a huge thank to all of you who decided to spend a Wednessday evening in Las Vegas with Kaido and I – we hoped for 20 and 4 times that number showed up. The slide deck from BOF sessions are not available on You can download our slide deck from the BOF08 PowerShell – Examples from the Real Word session here

By | 2013-04-11T15:14:03+00:00 April 11th, 2013|Configuration Manager (SCCM), General info|1 Comment

Getting ready for MMS 2013

It’s that time of year again – MMS in Vegas. This year I’ll be (co)-hosting 6 sessions – if you still have an empty slot in your schedule please consider one of these Managing Third Party Updates with System Center 2012 Configuration Manager SP1  - Sunday, April 7, 5:00 PM - 6:15 PM Kent Agerlund, Lawrence Garvin The session will provide you with tips and tricks to solve the daily challenges around patching your environment with Microsoft and non-Microsoft updates. You will learn how to design and configure a Software Update solution that will be easy to manage and yet [...]

By | 2013-04-02T17:47:52+00:00 April 2nd, 2013|Configuration Manager (SCCM), General info|1 Comment

Awarded Most Valuable Proffesional– MVP 2013

What a nice day, Sun is shining, the snow is melting and I just got this mail     Dear Kent Agerlund, Congratulations! We are pleased to present you with the 2013 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in System Center Configuration Manager technical communities during the past year.

By | 2013-04-01T16:49:42+00:00 April 1st, 2013|Configuration Manager (SCCM), Personal|6 Comments

Automatic Client Upgrade greyed out

In ConfigMgr 2012 SP1 you might run into the Automatic Client Upgrade feature being greyed even if you are a full administrator. In this example I have a group called ConfigMgr Administrators that has been assigned Full Administrator rights but are still not able to enable the Automatic Client Upgrade settings. To fix the issue log in with the account that installed the primary site server. In the Administration workspace, select Security, Administrative Users and open the properties for the ConfigMgr Administrators group. Click Add, Security Scope and select All Security Scopes. Click OK and all users in the ConfigMgr [...]

By | 2013-02-19T18:00:33+00:00 February 19th, 2013|Configuration Manager (SCCM), Security|11 Comments

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

Slides and notes from my Advanced Infrastructure session @NIC 2013

A huge thanks to all NIC 2013 attendes, once again you proved that Norway is a perfect place to host the Nordic Infrastructure Conference. Two great days where I also had the pleasure of attending sessions hosted by some A-Class speakers. As promised here is my slide deck from my Friday afternoon session on dvanced infrastucture. Key take-away from the session is “ways to max the performance in your ConfigMgr infrastructure and plan for redundancy”. Step-by-step guide on Creating Management Point database replicas Great blog post from Brian Mason on Management Points and database replicas Must see SCCM Guru video [...]

By | 2013-02-04T14:23:18+00:00 February 4th, 2013|Configuration Manager (SCCM), General info|2 Comments

Slides and notes from my 3rd. party Patch Management session @NIC 2013

A huge thanks to all NIC 2013 attendees, once again you proved that Norway is a perfect place to host the Nordic Infrastructure Conference. Two great days with some A-Class speakers. As promised here is my slide deck from my 3rd. party software update session. During my session, I discussed how to prepare your environment for 3rd. party patch management and demonstrated two different solutions. Download Slide deck System Center Updates Publisher Download the complete SCUP 2021 guide here Checkout the SCUP videos  Checkout the PatchMyPc catalog here: Check out the “scupdates” catalog here: Secunia Download Secunia PSI, a freeware [...]

Slides and demo files from NIC 2013– Software Update Management

A huge thanks to all NIC 2013 attendes, once again you proved that Norway is a perfect place to host the Nordic Infrastructure Conference. Two great days with A Class speakers.  Slides from my first session SC 2012 Configuration Manager - Software Update Management 5 minutes is all it takes During the session I demonstrated how you could use PowerShell to create a Software Update Packages and modify the update package in an existing Automatic Deployment Rule. Both scripts can be downloaded here – all credit goes to my colleague and undefeated powerShell champ Kaido I also demonstrated a nice [...]

By | 2013-01-26T14:44:25+00:00 January 26th, 2013|Configuration Manager (SCCM), Events, General info|7 Comments

Working with database replicas on your Management Point

Wonder why you should consider database replicas on your Management Points? The answers are in this webcast from Brian Mason (fellow Configuration Manager MVP from Minnesota.) The keywords are fault tolerance and performance and who do not want that as part of their Configuration Manager infrastructure. Download the MP replica step-by-step guide Huge thanks to Brian Mason for helping out with the document and for convincing me to use this feature.

By | 2013-01-20T21:01:58+00:00 January 20th, 2013|Configuration Manager (SCCM)|5 Comments

Correct – SCCM 2012 does not support SQL Mirroring and can breake a SCCM SP1 upgrade

As stated here SQL mirroring is not supported for the ConfigMgr database. However a technet article do not stop all database administrors’s from enabling the setting anyway believing that it will not cause any issues – but boy it does. SQL mirroring will break the SCCM SP1 upgrade process and leave the primary site server in a non-functional mode where a site restore is the only way back. The issue can be found in the ConfigMgrSetup.log file. USE [cm_ps1]; ALTER DATABASE [cm_ps1] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;  $$<Configuration Manager Setup><01-11-2013 10:38:29.887+00><thread=4136 (0x1028)> *** [42000][1468][Microsoft][SQL Server Native Client 11.0][SQL Server]The operation [...]

By | 2013-01-13T10:29:19+00:00 January 13th, 2013|Configuration Manager (SCCM), General info|5 Comments

Role Based Administration change in ConfigMgr SP1

RBA or Role Based Administration is one of the many new features in ConfigMgr 2012. It’s a very powerful feature and has already helped lots of customers minimizing the need for having multiple primary sites. One annoying fact in RTM is that all collections (users and devices) shows up when running a report. This has changed in Service Pack 1 which makes the RBA feature even more powerful. In this example I have a user (DskAdmin) who is member of the Desktop Admins group in Active Directory. Desktop admins must all be granted Application Administrator permissions and allowed to work [...]

First look at the Secunia CSI integration with Configuration Manager 2012

A few years ago I wrote a blog posts on Microsoft SCUP and Secunia CSI 5.0. Back then my conclusion was that Secunia had a superb security database but required a custom agent and didn’t have an easy Configuration Manager Console integration. With the latest release of Secunia CSI those “obstacles” are removed and the solution looks very promising. In this, my first test drive of the product, I will see how quickly I can install the solution and start patching my environment. The installation CSI requires that you first install the CSI administrator console and then the CSI SCCM [...]

By | 2012-11-30T11:27:18+00:00 November 30th, 2012|Configuration Manager (SCCM), General info, Security|2 Comments

ConfigMgr Cloud Distribution Points

One of the new features in ConfigMgr SP1 is Cloud based distribution points. ConfigMgr SP1 clients can use the CDP as a fallback solution when the requested content is not available at an on-premise distribution point (the new term for the “old fashion DP”). It is not a replacement for Internet Based Client Management. The benefit of having cloud distribution points are: You can easily create them You can easily add more resources if the scenarios where extra bandwidth is needed e.g. when upgrading to Office 2013 worldwide Nice fallback solution Clients will fallback to the Cloud DP if the [...]

By | 2012-10-16T13:59:45+00:00 October 16th, 2012|Configuration Manager (SCCM), General info|11 Comments

SMSPXE.Log in SCCM 2012

A commonly asked question the forums these days is – “anybody seen the SMSPXE.log?” With ConfigMgr SP1 the log is placed on the distribution point in <X>\SMS_DP$\SMS\Logs where X is the location of the contentlibrary. The log files contains a bit more useful information compared to Cm07 and CM2012 RTM. Below is a snippet of the log file where an unknown computer performs a PXE boot and runs an “advertisement” (what ever that is”) Client lookup reply: <ClientIDReply><Identification Unknown="0" ItemKey="0" ServerName="" ServerRemoteName=""><Machine><ClientID/><NetbiosName/></Machine></Identification></ClientIDReply>     SMSPXE    10/11/2012 5:35:33 AM    5640 (0x1608) 00:15:5D:01:75:20, B9291B40-5182-4CAB-BFFF-ADF05C1C4663: device is not in the database.    SMSPXE    10/11/2012 5:35:33 [...]

By | 2012-10-11T17:10:10+00:00 October 11th, 2012|Configuration Manager (SCCM), General info|3 Comments

Mastering SCCM 2012 SP1 training

System Center 2012 SP1 just released, and it’s not a minor release. I have been working with SMS since 1996 and I haven’t seen anything like this in the past. If you need training on Configuration Manager 2012 I highly recommend that you attend the correct class and it must be a class where the material is based on the latest Service Pack. There a huge changes in Service Pack 1 and we will make sure that you learn about all of them. Our Mastering Configuration Manager 2012 class has been running with great success since May 2011 and is [...]

By | 2012-10-04T12:50:04+00:00 October 4th, 2012|Configuration Manager (SCCM), Training|2 Comments

Updated version of the Package source Changer

As described in this blog post one of the many task involved in migrating from CM07 to CM12 is updating the package source in your packages. A new version of the tool has just been released with new cool features to make your migration experience easier and less painful. Installing and configuring the tool Download the latest version here and start the tool on the CM12 server. When the tool is launched click Configuration, specify the name of the Configuration Manager 2012 site server and click Save.  Click List, this will retrieve a list of all the source locations used [...]

By | 2012-10-03T08:17:01+00:00 October 3rd, 2012|Configuration Manager (SCCM), General info|8 Comments

System Center 2012 Configuration Manager SQL recommendations

I have two SQL related question that comes up in all of my ConfigMgr 2012 projects. Those are:   · Where are we going to install the SQL server? · How are we going to configure SQL? Where are we going to install the SQL server Answering the first question often ends in a political discussion between the ConfigMgr. administrators on one side and the SQL DBA’s on the other side. Most of the ConfigMgr. administrators that I know, strongly believe in having a local SQL installation. I’m also a true believer of that for several reasons. Remote SQL installations [...]

By | 2017-12-18T16:11:50+00:00 August 18th, 2012|Configuration Manager (SCCM), General info|28 Comments