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: http://www.deploymentresearch.com/Research/tabid/62/EntryId/173/Links-from-ConfigMgr-2012-R2-preconference-at-TechEd-2014-NA.aspx

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],
    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);

Index and Statistics Maintenance: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

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

Software Update Report dashboard rdl file

Software Update step-by-step: http://blogs.technet.com/b/gary_simmons_mcs/archive/2013/12/09/creating-a-custom-report-for-system-center-2012-r2-configuration-manager-part-1.aspx

By | 2014-05-13T15:36:49+00:00 May 13th, 2014|Configuration Manager (SCCM), Events|3 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.

3 Comments

  1. Cade May 14, 2014 at 23:59 - Reply

    Your class was great! Looking for a couple links:

    Your new report – Software Updates Summary kca & script to check sql hard drive performance (IOPs)

    Thanks!

  2. Thuy May 20, 2014 at 19:40 - Reply

    Thank you for following-up with these links. Your precon session was great!

  3. Simon May 27, 2014 at 15:14 - Reply

    Are there any information regarding the “Software Update Report”. On what basis are the graph drawn? What are the difference between installed or required?

Leave A Comment