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.

Collections not being refreshed in ConfigMgr 2012 R2

Case, old collections do not refresh when adding or removing objects to the collection. New collections are updated, it just takes a long time. Looking in the colleval.log file there was a lot of errors like this: *** exec dbo.sp_TransferMembership 'PS100014', 0    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0) *** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the CHECK constraint "ClientOfferStatus_ItemKey_Partition_CK". The conflict occurred in database "CM_PS1", table "dbo.ClientOfferStatus", column 'ItemKey'. : CollectionMembers_ins_upd_del    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0) CCollectionSource_SQL::RefreshResults - could not execute SQL cmd exec dbo.sp_TransferMembership 'PS100014', 0    SMS_COLLECTION_EVALUATOR    02-06-2014 23:14:36    7392 (0x1CE0) STATMSG: ID=601 SEV=E LEV=M SOURCE="SMS [...]

By | 2014-06-03T12:26:49+00:00 June 3rd, 2014|Configuration Manager (SCCM)|7 Comments

Links and notes from the MVP Expert Session @TechED 2014 Houston

One word – Awesome! Attending the MVP Expert session along with 1000 attendees as speaker was nothing short of an awesome experience. For those of you who couldn’t attend session, you can catch the recording here: The scripts I used The collection/Excel tool

By | 2014-05-13T16:10:07+00:00 May 13th, 2014|Configuration Manager (SCCM), Events|10 Comments

Links and notes from the “ConfigMgr in the Real World” precon @ TechEd NA 2014

First a huge thanks to the 341 attendees showing up at the precon, you all contributed to making this a day to remember for both Johan and I. By now we should have answered all questions that was posted to #TEPRC10 on Tweeter. Precon links from Johans blog: Pre-creating the database using this script Checking the database fragmentation: Use CM_PS1 Go SELECT DB_NAME(database_id) AS [Database Name], OBJECT_NAME(ps.OBJECT_ID) AS [Object Name], AS [Index Name], ps.index_id, index_type_desc,     avg_fragmentation_in_percent, fragment_count, page_count FROM sys.dm_db_index_physical_stats(DB_ID(),NULL, NULL, NULL ,N'LIMITED') AS ps     INNER JOIN sys.indexes AS i WITH (NOLOCK)     ON ps.[object_id] [...]

By | 2014-05-13T15:36:49+00:00 May 13th, 2014|Configuration Manager (SCCM), Events|3 Comments

Dealing with Jailbroken/Roted devices in ConfigMgr 2012 R2 & Intune

As you enroll a mobile device into Intune/ConfigMgr 2012 R2, inventory data will automatically be uploaded to the ConfigMgr database. One of the data being collected is the Jailbroken/rooted condition. In the below example the device is being detected as a jailbroken device. One of the many benefits of using Intune as the MDM solution is the integration with System Center 2012 R2 Configuration Manager. Once data is in the database we can use the entire ConfigMgr engine to manage the device. MDM devices in ConfigMgr can be managed using the Application Model and the Compliance Management feature. Especially the [...]

By | 2014-04-10T10:18:04+00:00 April 10th, 2014|Configuration Manager (SCCM), General info|0 Comments

ConfigMgr 2012 R2 and Windows Azure Cloud Distribution Point

  In order to use a Windows Azure distribution point, you need a few things like a Windows Azure account, Access to internal DNS, a couple of certifcates and 45 minutes. The Azure distribution point can act as a fallback distribution point for your Windows clients and do support most content type. To calculate the cost for each Azure distribution point, checkout this Azure calculator What a Cloud-Based Distribution Point do not support ·Apple MAC OS X clients UNIX clients 3rd party Software updates thru the Windows Update feature Windows Updates Streamed Applications Task Sequences that are NOT configured [...]

By | 2014-03-21T17:30:18+00:00 March 21st, 2014|Configuration Manager (SCCM), General info|4 Comments

Installing ConfigMgr R2 2012 client for Mac OSx

Earlier this week Microsoft released a new ConfigMgr R2 2012 Mac OSx client. Althoug it has been possible to enroll Mac OSx 10.9 clients without this new client, I still recommend a client upgrade. How to install the new client Download the new installer from: ConfigMgr 2012 R2 Mac Client Run the ConfigmgrMacClient.msi on a Windows machine. The installer will extract a dmg file in C:\Program Files (x86)\Microsoft\System Center 2012 R2 Configuration Manager For Mac Client. Copy the Macclient.dmg to a Mac OSx client that has an existing ConfigMgr client installed (can be the old SP1 client). Open a Terminal [...]

By | 2014-03-01T18:10:56+00:00 March 1st, 2014|Configuration Manager (SCCM), General info|14 Comments

Configuration Manager Support Center

Microsoft just released a Configuration Manager Support Center tool in beta on The Support Center is perfect for troubleshooting clients and collecting client data. There is two tools and some PowerShell cmdlets in the support Center. The data collection tab in the support center, will allow you to collect data from a client (local and remote) and store the information in a zip file. The zip file can be opend in the Support Center Viewer for troubleshooting. A view of the local content on a client from the Content tab Viewing and changing log settings from the Logs tab. [...]

By | 2014-02-05T00:07:08+00:00 February 5th, 2014|Configuration Manager (SCCM), General info|2 Comments

Community tools from System Center Universe 2014

These are some of the tools the I used in my demonstraiton @SCU 2014 in houston Remember to hug your community contributers today!!! Infrastructure and Client Management Johan Arwidmark ConfigMgr R2 Hydration Kit - Mikael Nyström System center Hydration Kit - Startup Script - Right Click tools - Right click took - Client Center - David’s Inventory Script PowerShell - Garth’s Inventory Script vbSript - CM12Healthcheck toolkit - ConfigMgr 2012 Registration Request - PowerShell Right Click tools - RegkeyToMof - Now Micro Right Click tools - Http:// ConfigMgr 2012 [...]

By | 2014-01-30T16:36:03+00:00 January 30th, 2014|Configuration Manager (SCCM), Events, General info|6 Comments

Coretech HTA

The main idea with this HTA is to assist small and medium sized organizations with an easy way to implement a custom OSD solution without having any developer or HTML skills. The HTA solutions can be used when booting directly into WinPE and to prestage computers. Why; You might ask, Why, do Coretech create this tool instead of using the built-in tools in Configuration Manager or using the UDI wizard in Microsoft Deployment Toolkit?  The answer is straight forward. We often run into customers who do not have the knowledge it takes to build custom solutions or use the UDI [...]

Dealing with reboot pending clients in Configuration Manager 2012

Guess most of you are struggling with troubleshooting software update compliance and installing applications in Configuration Manager 2012. What I have found, is that clients in a reboot pending state often is the root cause to the problems. In previous posts I have described how you can use tools like Coretech Shutdown Utility to automatically restart computers that has been in a reboot pending state for X number of hours/days.  The information about the reboot pending state is stored in WMI Root\ccm\ClientSDK namespace as illustrated here with the Coretech WMI & PowerShell explorer: Identify reboot state using PowerShell Launch PowerShell [...]

By | 2014-01-19T17:14:28+00:00 January 19th, 2014|Configuration Manager (SCCM), General info|19 Comments

NIC 2014 – Deck and links from my ConfigMgr Community session

Once again, to all who has ever contributed to the community – We salute you – keep on working and know that you are making a difference for 1000’s of IT pros “out there”. Download deck Just some of the community tools: Infrastructure and Client Management Johan Arwidmark ConfigMgr R2 Hydration Kit - Mikael Nyström System center Hydration Kit - Startup Script - Right Click tools - Right click took - Client Center - David’s Inventory Script PowerShell - Garth’s Inventory Script vbSript - CM12Healthcheck toolkit - ConfigMgr 2012 Registration Request - [...]

By | 2014-01-19T12:01:17+00:00 January 19th, 2014|Configuration Manager (SCCM), Events, General info|1 Comment

Error enrolling Apple MAC OS X 10.9.1 client in Configuration Manager 2012 R2

Been spending a few good hours trying to get the super enterprise friendly operating system Apple Mac OS X 10.9.1 (In Denmark we really use irony a lot!). There a some good blog post on how to configure MAC support that I advice you all to follow and if you are working with latest version Maverick 10.9.1 I strongly advise you to read this blog post from Yvette - Here is what I did, the error I saw and how I fixed it. Configuring Apple MAC support according to Technet Enrolled the client on OS X version 10.9.1 (which is [...]

By | 2014-01-05T12:26:00+00:00 January 5th, 2014|Configuration Manager (SCCM)|1 Comment

Error in policypv.log after upgrade to ConfigMgr 2012 R2

Ran into an interesting error today after updating ConfigMgr 2012 SP1 to ConfigMgr 2012 R2. The hierarchy is a CAS and 3 primary sites (but I do not believe that the error is releated to having multiple primary sites). *** insert DepPolicyAssignment (PADBID, PolicyAssignmentID, PolicyID, DepPADBID, DepPolicyAssignmentID, DepPolicyID, IsTombstoned, LastUpdateTime) values (67118015, N'{ccff0eb1-db33-49c3-9dd3-c704c3a638f8}', N'PS120012-PS10013D-6F6BCC28', 67689129, N'{060a13d7-7ed8-46ae-927f-4420b0fefdcb}', N'DEP-PS120012-PS1002B1-6F6BCC28', 0, GetUTCDate()) *** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "DepPolicyAssignment_1_FK". The conflict occurred in database "CM_PS1", table "dbo.PolicyAssignment", column 'PADBID'. Failed to create policy and policy assignment based on package PS1002B1, program * and offer [...]

By | 2013-11-12T20:32:56+00:00 November 12th, 2013|Configuration Manager (SCCM)|1 Comment

Configure Coretech Application E-Mail Approval tool to always use the fallback mail

As you can read in this blog post – we recently released a new version of our E-Mail approval tool. One of the new features in the tool is to configure a fallback address. You can either specify a Manager as the approver or a fallback group like Servicedesk. In order to configure the tool to always use the fallback address follow these steps: Open C:\Program Files (x86)\coretech\Coretech Application Approval Service Edit the CM_AppReqListen.exe.config.xml file Find the Section in called <setting name="UseManager" serializeAs="String"> Change <value>True</value> to <value>False</value> Save and close the file Restart the Coretech CM Application Request Listener service

By | 2013-10-15T14:50:00+00:00 October 15th, 2013|Configuration Manager (SCCM), General info, Tools|12 Comments

Coretech Application E-Mail Approval Tool

A little over a year ago we released the first version of our Application E-mail approval utility. Ever since our first release we have received lots of positive feedback and ideas to new features. Most of the ideas are implemented in this new release. Thanks for all the feedback and please keep it coming. This blog post will explain how you can install CTAA (Coretech Application Approval tool) – Download Additional blog posts will follow and explain how you can customize the tool. Why the need for this utility The idea with this utility is to integrate a “real approval [...]

By | 2017-09-13T11:42:26+00:00 October 11th, 2013|Configuration Manager (SCCM), General info, Tools|165 Comments

The Coretech Software Update Management Tool

As demonstrated @TechEd in Australia and New Zealand our latest free tool is the Software Update Management Tool. The sole purpose of the tool is to automate the creation of software update deployments. The benefits of using the tool are: All deployments will be using the same naming standard. the naming standard is WRK/SRV + Year + Value of Month WRK 2013 09. The names are automatically generated using the actual month. You save time by automating the process. You eliminate errors by automating the process. All deployments are created as disabled deployments. This gives you complete control over the [...]

By | 2013-09-20T13:45:06+00:00 September 20th, 2013|Configuration Manager (SCCM)|30 Comments

Slides and scripts from the System Center 2012 Configuration Manager R2 Advanced Infrastructure session #WCL307

As promised in the session here are the scripts and links that I was using. Video and slides available on Channel 9: Blog: Management Point replica   SQL Scripts: Index and Statistics Maintenance: Pre-creating the SQL database: Download   My generel SQL recommendations:   Planning for Cloud based Distribution Points   Getting started with PowerShell:

By | 2013-09-11T22:24:35+00:00 September 11th, 2013|Configuration Manager (SCCM), Events|1 Comment

Automate importing and creating driver packages in SCCM 2012 R2

  I take that you are familiar with drivers and manually creating driver categories and driver packages in Configuration Manager. Here I will show you how you can optimize the process by running a very need little PowerShell script called ImportDrivers.ps1 (main developer is Claus Codam). There are a few prerequisites that needs to be in place before the script will work. Driver source has to be 3 levels deep like this example (Make\Model\OS). The driver source is where you store the original driver packages from the vendor. You need to create a Driver packages folder (where ConfigMgr will import [...]

New System Center 2012 Configuration Manager SP1 book

It’s truly with great pleasure and excitement I can announce that my new book System Center 2012 Configuration Manager SP1 Mastering the Fundaments, 2nd edition is finished, and will be available later in July. The new book not only covers how to get started correctly, it also includes information about the new Cloud features like Windows Intune integration (Mobile Device Management), Windows Azure distribution point (Cloud DP), Mac/Linux management, PKI, installing Configuration Manager on Windows Server 2012, deploying Windows 8, handling Windows & 3rd party updates and much more. ISBN for the book is 978-91-87445-01-9.   

By | 2013-07-03T11:10:32+00:00 July 3rd, 2013|Configuration Manager (SCCM)|23 Comments

How to run Secunia CSI scanning without installing the CSI agent

Lately I have done a lot of Secunia CSI installations. One of the questions that keeps coming up is “what client scanning options do we have, if we do not install the CSI agent locally?”. You basically have three options as described below. Software Inventory You can use ConfigMgr Inventory and gather information about *.EXE, *.OCX and *.DLL files. This process will get the job done although you are gathering much more information than CSI requires. This method requires that the Site Server (where you installed CSI) have access to the Cloud based database hosted by Secunia. Network scanning Perform [...]

By | 2013-07-01T08:36:01+00:00 July 1st, 2013|Configuration Manager (SCCM), General info|6 Comments

Coretech WMI & PowerShell Explorer Part II

As mentioned in my previous post (using the WMI feature of the tool) we have recently released a new tool – the Coretech WMI and PowerShell Explorer. For information about downloading and installing the tool checkout this blog post from Kaido Järvemets.  The second main feature of the Coretech WMI and PowerShell Explorer is the PowerShell module. The intention with this module is to help you get started with Microsoft PowerShell and especially System Center 2012 Configuration Manager SP1 and PowerShell. The feature can be used to import custom PowerShell modules as well as built-in PowerShell modules. Once imported you [...]

By | 2013-06-19T15:59:03+00:00 June 19th, 2013|Configuration Manager (SCCM), General info|3 Comments

Coretech WMI & PowerShell Explorer–Using the WMI feature

Earlier today Coretech released a brand new tool that we call Coretech WMI and PowerShell Explorer. For information about downloading and installing the tool checkout this blog post from Kaido Järvemets.  The tool has two main features, a WMI and a PowerShell explorer. This blog post will explain how you can use the WMI feature. Working with Coretech WMI and PowerShell Explorer Connect to the local computer Root\Cimv2 Namespace Launch the Coretech WMI and PowerShell Explorer as Administrator. From the upper left corner, expand the Menu and click Connect. In the Connect dialog box, type the Namespace or use the [...]

By | 2013-06-17T08:02:48+00:00 June 17th, 2013|Configuration Manager (SCCM), General info|1 Comment

SCCM 2012 PowerShell Class coming in the Fall

Summer is finally here, and what better to spend the Summer than developing a brand new System Center 2012 Configuration Manager PowerShell class. We (Kaido Jävemets & Kent Agerlund) are currently busy writing lots of labs and examples that will help you unleash the power of PowerShell. Why a PowerShell class you might ask? Well, because PowerShell is King and we love it The class will be running at a training center near you – and if not, please contact us. The agenda for the 3 day lab look like this: Mastering SCCM 2012 R2 with PowerShell Title: Mastering Configuration [...]

By | 2013-06-15T12:32:24+00:00 June 15th, 2013|Configuration Manager (SCCM)|1 Comment