Links and downloads from SCU 2014 in Basel

Below is a list of the links and scripts that I used in my two sessions today on Compliance Management and Troubleshooting ConfigMgr.

Compliance examples – download

Configuration Manager Support Center:

Microsoft System center 2012 R2 Configuration Manager Toolkit:

Optimizing ConfigMgr database:

Background on maintenance task:

Configuring SQL Backup and recovery, includes link to demo:

Autmating the WSUS Cleanup process

SQL PowerShell audit script

Splitting existing ConfigMgr database into multiple SQL files

Pre-creating the database before installing Configmgr – download script

SQL Script to for fragmentation on the SQL DB


Checking the database fragmentation:
Use CM_PS1
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] = i.[object_id] AND ps.index_id = i.index_id
WHERE database_id = DB_ID()
AND page_count > 1500
ORDER BY avg_fragmentation_in_percent DESC OPTION (RECOMPILE);

By | 2014-09-19T18:30:27+00:00 September 19th, 2014|Configuration Manager (SCCM), General info|4 Comments

About the Author:

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.


  1. Jörn Rink September 25, 2014 at 10:47 - Reply

    The sccm management tool looks great, not so great, that it needs .net 4.5.2

    Is it possible to install and work with the tool from an admin workstation?

  2. Kent Agerlund September 25, 2014 at 10:48 - Reply

    Yes, it’s not a server tool

  3. Terence October 20, 2014 at 16:04 - Reply

    Is there a reply of this event, Thanks

  4. Jörn Rink November 21, 2014 at 12:36 - Reply

    Hello Kent,
    if i remember correctly, you show at the SCU how i can disable the auto repair functionality in the client health check. I cannot found something in this links. Or was this in a different session?

Leave A Comment