web analytics

Blog

How to measure Operating system deployments

Posted by:

Two months ago we started to measure our OS deployments and now we have measured over 1000 installations. This solution writes information directly to SQL database and if you have that information in SQL, then you can create very nice reports for Managers. With this solution we have found many different location where are strange problems and the OSD deployment takes a lot of time.

How to configure your environment

    1. Download and extract OSD_Stats.zip file. 

    2. OSD_Stats.zip contains these files:

    3. Open OSD_Database.sql file with SQL Management Studio
    4. Make sure that OSD database location is correct
    5. Execute OSD_Database.sql
    6. Open INSERTOSDTIMES.sql with SQL Management Studio
    7. Execute INSERTOSDTIMES.sql
    8. Open Table-OSDInstallationTimes.sql with SQL Management Studio
    9. Execute Table-OSDInstallationTimes.sql
    10. Verify that OSD database, OSDInstallationTimes table and InsertOSDStats stored procedure exists
    11. Move Statistics folder to correct drive and make sure that the folder structure is like this:
    12. Set correct permissions in SQL that Configuration Manager Primary Site Server can connect and write information to OSD database
    13. Move Insert_OSD_stats.ps1 to scripts folder.
    14. Open Configuration Manager Console
    15. From the Configuration Manager Console, open Administration workspace
    16. Select sites and on the home tab select Status Filter Rules
    17. On the Status Filter Rules window, press Create.
    18. On the Create Status Filter Rule wizard , you need to fill the following text boxes:
      1. Name – example value : “Windows 8 x64 with Adobe Apps – START
      2. Source – example value: Client
      3. Message ID – example value: 11144
      4. Property – example value: Package ID
      5. Property Value – example value: TPT0005a (TPT0005a is a TASK SEQUENCE ID)
      6. Run a program– example value: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -file C:\Scripts\Insert_OSD_Stats.ps1 -ComputerName %msgsys -TS “Windows 8 x64 with Adobe Apps“ –START
      7. Click Next to finish the Wizard
    19. On the Status Filter Rules window, press Create.
    20. On the Create Status Filter Rule wizard , you need to fill the following text boxes:
      1. Name – example value : “Windows 8 x64 with Adobe Apps – END
      2. Source – example value: Client
      3. Message ID – example value: 11171
      4. Property – example value: Package ID
      5. Property Value – example value: TPT0005a (TPT0005a is a TASK SEQUENCE ID)
      6. Run a program– example value: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -file C:\Scripts\Insert_OSD_Stats.ps1 -ComputerName %msgsys -TS “Windows 8 x64 with Adobe Apps“ –END
      7. Click Next to finish the Wizard
    21. Open Insert_OSD_Stats.ps1 with Windows PowerShell ISE or Notepad and modify only this part
      1. $ServerName – SQL server name
      2. $Database – OSD database name
      3. $Statfolder – history, etc.
      4. $LogFile – log file location

 Now you can start the OSD Bare Metal Installation and monitor the folders and Status Messages

 Example SQL Data

 

Insert_OSD_Stats.ps1 PowerShell script process overview

Sample Graph for Managers

This Graph shows how much time it took in september, october etc to install one PC (Average)



About the Author:

Kaido Järvemets is a developer, consultant, trainer specializing in Microsoft System Center Configuration Manager and PowerShell Solutions at Coretech. Kaido frequently speaks at European conferences and had his US debut as speaker at MMS April 2013. Kaido is well-known in the Configuration Manager communities where he’s a key player in the PowerShell game. Kaido host one of the most complete Configuration Manager PowerShell library’s in the world with hundreds of free code samples ready to download and implement – www.cm12sdk.net. Kaido has been awarded Microsoft Most Valuable Professional (MVP) in Microsoft Enterprise Client Management for his work with Configuration Manager from 2011 – to present. Kaido is the founder of System Center User Group Estonia in 2011.

Discussion

  1. Michael  March 19, 2013

    Hi,
    First of all this is great blog… :-)
    I’m trying to get “How to measure Operating system deployments” to work, but I’m facing some problems.
    I see this in “OSD_Stats.log”:
    Successfully created D:\Statistics\2013\3\Start\BS023072.txt
    Successfully added 03/19/2013 12:34:20 to D:\Statistics\2013\3\Start\BS023072.txt
    Failed to read D:\Statistics\2013\3\Start\BS023072.txt

    I think it have something to do with the permissions¨on the OSD database.
    But I’m not sure which permission I need to add… ?
    I’ve tried to add Siteserver$ without any luck and data doesn’t seem to be written to database.

    (reply)

Add a Comment