Slides and links

Here is the link to the slides:
http://deploymentresearch.com/DRFiles/MSIgnite2015preday.zip

Video to deploying Windows 10 IoT to Raspberry Pi 2
https://www.youtube.com/watch?v=Q5SfPTykM6A

Hydration Kit for System Center 2012 R2
http://deploymentresearch.com/Research/Post/407/The-Hydration-Kit-for-System-Center-2012-R2-is-available-for-download

The script that exported task sequences was gathered from the following post
http://trevorsullivan.net/2010/05/13/exporting-configmgr-task-sequences (by Trevor Sullivan)

The script that imported task sequences was gathered from the following post
http://www.david-obrien.net/2012/09/29/how-to-backup-restore-your-tasksequenceconfiguration-manager-2012-and-powershell (by David O’Brien)

TechNet Docs – Create a Windows 8.1 Reference Image
http://technet.microsoft.com/en-us/library/dn744290.aspx

TechNet Docs – Deploy a Windows 8.1 Image Using MDT 2013
http://technet.microsoft.com/en-us/library/dn744279.aspx

TechNet Virtual Labs – Creating a Windows 8.1 reference image 
http://go.microsoft.com/?linkid=9845755

Building reference images like a boss!
http://www.deploymentresearch.com/Research/tabid/62/EntryId/174/Building-reference-images-like-a-boss.aspx

Running the Data DeDuplication process in PowerShell
http://deploymentresearch.com/Research/Post/397/Running-the-Data-DeDuplication-process-in-PowerShell

Automatically Populate the PATCH Property for the ConfigMgr Client Installation – Script Update
http://blogs.technet.com/b/deploymentguys/archive/2013/06/04/automatically-populate-the-patch-property-for-the-configmgr-client-installation-script-update.aspx

Mobile Device Management

Getting started with Microsoft EMS:

http://www.microsoft.com/en-us/server-cloud/enterprise-mobility/overview.aspx

Enterprise Mobility Suite Getting Started Guide – Download

http://blogs.technet.com/b/in_the_cloud/

Reporting Advices:

  • Only show the data that are needed
  • Use graphics and colour to emphasize data
  • Eliminate fluff
  • Thin font
  • Space instead of lines
  • Dim labels not values
  • Limit number of accent colors
  • Visualize KPI’s
  • Trend over time, consider using sparkline instread of raw data

SQL stuff

  1. SQL Audit script – https://stevethompsonmvp.wordpress.com/2014/05/19/powershell-sql-audit-script/
  • Collection information
    • Select * from Collections_L
    • Select * from Collections_G
    • Use CEViewer from the ConfigMgr 2012 R2 Toolkit
  • Monitor IO

    WITH Aggregate_IO_Statistics

    AS

    (SELECT DB_NAME(database_id) AS [Database Name],

    CAST(SUM(num_of_bytes_read + num_of_bytes_written)/1048576 AS DECIMAL(12, 2)) AS io_in_mb

    FROM sys.dm_io_virtual_file_stats(NULL, NULL) AS [DM_IO_STATS]

    GROUP BY database_id)

    SELECT ROW_NUMBER() OVER(ORDER BY io_in_mb DESC) AS [I/O Rank], [Database Name], io_in_mb AS [Total I/O (MB)],

    CAST(io_in_mb/ SUM(io_in_mb) OVER() * 100.0 AS DECIMAL(5,2)) AS [I/O Percent]

    FROM Aggregate_IO_Statistics

    ORDER BY [I/O Rank] OPTION (RECOMPILE);

  • Example on how to fix the susdb VLF issue

    WSUS Fix VLF

    USE SUSDB

    GO

    DBCC SHRINKFILE(SUSDB_log, TRUNCATEONLY)

    ALTER DATABASE SUSDB

    MODIFY FILE (NAME = SUSDB_log, SIZE=1024MB);

    GO

Azure AD & PowerShell –

Microsoft Online Services Sign-In Assistant for IT Professionals RTW – http://www.microsoft.com/en-us/download/details.aspx?id=41950

Azure Active Directory Module for Windows PowerShell (64-bit version) – https://msdn.microsoft.com/en-us/library/azure/jj151815.aspx

Example queries – https://msdn.microsoft.com/en-us/library/azure/dn394289.aspx>

Site Systems & DMZ

WSUS return codes:

Connect to \\<siteserver>\root\sms\site_<sitecode>

Query SELECT * FROM SMS_SCI_Component

Open the SMS_WSUS_CONFIGURATION_MANAGER record

Click the Refresh Object button

Open the Props property

Click the View Embedded button

Find the record with the PropertyName WSUS Scan Retry Error Codes

Add the new value to the Value2 property

Click the Save Property value

 

or in SQL

Select

ID, SiteServerName, Name, Value2 as WSUSErrorCodes

from SC_Component_Property SCPROP

Join SC_SiteDefinition SCSITEDEF on SCSITEDEF.SiteNumber = SCProp.SiteNumber

where SCProp.Name = ‘WSUS Scan Retry Error Codes’ and SCSITEDEF.SiteCode = ‘ps1‘