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:

http://www.microsoft.com/en-us/download/details.aspx?id=42645

Microsoft System center 2012 R2 Configuration Manager Toolkit:

http://www.microsoft.com/en-us/download/details.aspx?id=36213

Optimizing ConfigMgr database:

http://stevethompsonmvp.wordpress.com/2013/05/07/optimizing-configmgr-databases/

Background on maintenance task:

http://stevethompsonmvp.wordpress.com/2013/04/19/how-to-determine-if-the-configmgr-rebuild-indexes-site-maintenance-task-is-running/

Configuring SQL Backup and recovery, includes link to demo:

http://stevethompsonmvp.wordpress.com/2014/02/24/configmgr-2012-site-backup-and-recovery-overview/

Autmating the WSUS Cleanup process

https://blog.ctglobalservices.com/kea/house-of-cardsthe-configmgr-software-update-point-and-wsus/

SQL PowerShell audit script

http://stevethompsonmvp.wordpress.com/2014/05/19/powershell-sql-audit-script/

Splitting existing ConfigMgr database into multiple SQL files

http://myitforum.com/cs2/blogs/jnelson/archive/2009/07/27/140199.aspx

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
Go
SELECT DB_NAME(database_id) AS [Database Name], OBJECT_NAME(ps.OBJECT_ID) AS [Object Name],
    i.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);