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.

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: http://channel9.msdn.com/Events/MMS/2013/UD-B308 Working with Management Point and SQL replicas: Step-bystep guide to create a Management Point replica: http://blog.ctglobalservices.com/kea/working-with-database-replicas-on-your-management-point/ Video on setting up a Management point replica: http://myitforum.com/myitforumwp/2012/08/06/next-sccm-guru-webcast-features-brian-mason/  Working with Software Updates: Software Updates: http://blogs.technet.com/b/configmgrteam/archive/2013/03/27/software-update-points-in-cm2012sp1.aspx Installing Workgroup clients: Orchestrator runbook by Andreas Falck to install Workgroup clients with PKI  http://falckbloggen.wordpress.com/2013/03/13/configuration-manager-2012-and-deploy-agent-to-dmz/ Distribution Points and WAN: Coretech Distribution Point Utilization Monitor: http://blog.ctglobalservices.com/kea/coretech-distribution-point-utilization-monitor/ Brian Mason on twitter: @AbetterPC Brian Mason blog: http://www.mnscug.org/blogs/brian-mason 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|29 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 http://www.2013mms.com/ 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|10 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|5 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)|3 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 | 2012-08-18T14:57:59+00:00 August 18th, 2012|Configuration Manager (SCCM), General info|27 Comments

Slides and links from the TechEd 2012 Pre-conference session

To all of you who participated in the User-Centric Application Delivery Rocks the World: Using Microsoft System Center Configuration Manager 2012 pre-conf sessions @Teched 2012 in Orlando and Amsterdam – thanks. Johan Arwidmark and I had a great time with lots of very good questions (more than 200 questions). During the session we promised to provide you with links to some of the tools and documents that we spoke about. Slides: http://www.deploymentresearch.com/DRFiles/SlidesFromPreconTEUS2012.zip The project plan for ViaMonstra: ViaMonstra-SC-2012-ConfigMgr-Project-criterias.pdf Software updates ConfigMgr 2007:Script to remove expired updates from you distribution points and update packages ConfigMgr 2012: Script to remove expired updates [...]

By | 2012-06-26T09:42:46+00:00 June 26th, 2012|Events|0 Comments

Error migrating from Configmgr 2007 to ConfigMgr 2012

I have done several Configmgr 2007 to Configmgr 2012 migrations, and so far all of them have been without to many issues. Well, that is, until this week. I was starting to migrate more than a 100 ConifgMgr 2007 sites into a single Configmgr 2012 primary site (YES, no CAS). After creating the source connecting to the ConfigMgr 2007 Central site, I received this error in the migmctrl.log file The error By reading the log file I could see that most of my objects were successfully analyzed and could be migrated. The error came was shown in the middle of [...]

By | 2012-06-22T19:46:01+00:00 June 22nd, 2012|Configuration Manager (SCCM)|2 Comments

ConfigMgr 2012 SP1 announced @TechEd 2012

System Center 2012 Configuration Manager SP1 Just finished my first session @TechEd 2012 in Orlando with Wally Mead and Mark Florida. During the session they revealed some of the upcoming features in ConfigMgr 2012 SP1. There will be support for new platforms like: Windows 8 Windows 8 tablet - Intel SoC tablets support Mac OS X Linux and Unix Application changes Support Metro style applications and Deep link applications Network cost support, which is intelligence support for detecting and controlling/blocking traffic from connections like 3G and 4G networks Hierarchy changes You can add a new CAS to an existing stand-alone [...]

By | 2017-08-22T13:03:45+00:00 June 11th, 2012|Configuration Manager (SCCM)|23 Comments