Install Update Rollup 10 SCOM 2012 SP1

Standard

In this blog post I will take you true the steps of installing System Center Operations Manager 2012 Sp1 update Rollup 9 to Update Rollup 10

The following issues are fixed in this Update

  • The home page link on the Web Console noscript.aspx file is vulnerable to cross-site scripting (XSS)
  • Backport CLR load order change to Update Rollup 7 for System Center 2012 R2
  • p_GroomTypeSpecificLogTables does not groom all MT_*log tables
  • Operational Insight name is changed to Operations Management Suite in the Operations Manager Console.

You can download the Update Rollup 10 form here
The downloaded files consist of an update for the “System Center Operations Manager Console”, “System Center Operations Manager ACS”, “System Center Operations Manager Agent”, “System Center Operations Manager Gateway”, “System Center Operations Manager Server” and the “System Center Operations Manager Web Console”.  

 Download Update Rollupo 10

The following steps outline the process of installing the Update

  1. Backup the operations Manager Databases and unsealed Management Pack’s
  2. Install Update to the Management server
  3. Install update to the secondary Management Servers
  4. Install Update to the Operations Manager Gateway
  5. Install Update to the Operations Manager Web Console
  6. Install Update to the Operations Manager Console
  7. Run the SQL scripts
  8. Import Management Pack’s
  9. Deploy the update to the agents

1. Backup the operations Manager Databases and unsealed Management Pack’s

I did a manual backup from my databases using the SQL Console

  1. Start the "SQL Server Management Studio"
  2. Connect to the Database server
  3. Right click on the database that you want to backup, select "Tasks" and click "Backup

    Backup Database

  4. On the "Backup Database Select the setting that you want to use and click "Ok

    BackupRunning

  5. When the Backup is completed click "Ok
  6. Repeat the steps Above for all the databases

You can backup your management pack’s using the powershell Operations Manager shell and type the following command:

Get-SCOManagementPack | Export-SCOManagementPack -path D:\Backup\ManagementPack

Powershell Backup Management Pack

2. Install Update to the Management server

  1. Extract the cabinet file
  2. Start a "elevated powershell command prompt"
  3. Run the "KB3071088-AMD64-Server.msp"

    Powershell Update Management Server

  4. Installation is running. This can take some time.

    ManagementServerUpdateRunning 

3. Install update to the secondary Management Servers

I installed the update the same way is installed it on the Management Server. So follow Step 2

4. Install Update to the Operations Manager Gateway

  1. Extract the cabinet file
  2. Start a "elevated Powershell command prompt"
  3. Run the "KB3071088-AMD64-Gateway.msp"

    Powershell Update Gateway Server

  4. Installation is running. This can take some time.

5. Install Update to the Operations Manager Web Console

  1. Extract the cabinet file
  2. Start a "elevated Powershell command prompt"
  3. Run the "KB3071088-AMD64-ENU-WebConsole.msp"

    Powershell Update Web Console

  4. Installation is running. This can take some time.

6. Install Update to the Operations Manager Console

  1. Extract the cabinet file
  2. Start a "elevated Powershell command prompt"
  3. Run the "KB3071088-AMD64-ENU-Console.msp"

    Powershell Update Web Console

  4. Installation is running. This can take some time.

7. Run the SQL scripts

  1. Start the "SQL Server Management Studio"
  2. Connect to the Database server and select the “OperationsManagerDW" Database

    SelectOperationManagerDW

  3. On the File menu, click Open, browse to D:\Program Files\System Center 2012\Operations Manager\Server\SQL Script for Update Roll ups , select the "UR_Datawarehouse.SQL" file and then click Open.
  4. When the file is loaded, click "Execute" in the SQL Editor tool bar
  5. Your Result should look something like:

    RowsAffected

Next we need to run the following script against the OperationsManager database

  1. Start the "SQL Server Management Studio"
  2. Connect to the Database server and select the “OperationsManager" Database

    SelectOperationManager

  3. On the File menu, click Open, browse to D:\Program Files\System Center 2012\Operations Manager\Server\SQL Script for Update Roll ups , select the "update_rollup_mom_db" file and then click Open.
  4. When the file is loaded, click "Execute" in the SQL Editor tool bar
  5. Your Result should look something like:

    RowsAffected3

8. Import the management Pack

  1. Start the System Center Operations Manager Console and select the "Administration pane"
  2. Right click "Management Pack" and click "Import Management Packs…"
  3. In the "Import Management Packs" and click "Add" and click "Add from Disk…"
  4. Browse to "D:\Program Files\System Center 2012\Operations Manager\Server\Management Packs for Update Rollups" and select the management Pack’s in that folder
    • Microsoft.SystemCenter.Advisor.Internal.mpb
    • Microsoft.SystemCenter.Advisor.mpb
    • Microsoft.SystemCenter.AlertAttachment.mpb
    • Microsoft.SystemCenter.Apm.Infrastructure.Monitoring.mp
    • Microsoft.SystemCenter.Apm.Infrastructure.mpb
    • Microsoft.SystemCenter.Apm.Library.mpb
    • Microsoft.SystemCenter.DataWarehouse.Report.Library.mp
    • Microsoft.SystemCenter.DataWarehouse.Reports.mp
    • Microsoft.SystemCenter.DataWarehouse.ServiceLevel.Report.Library.mp
    • Microsoft.SystemCenter.Image.Library.mp
    • Microsoft.SystemCenter.IntelliTraceProfiling.mpb
    • Microsoft.SystemCenter.TFSWISynchronization.mpb
    • Microsoft.SystemCenter.Visualization.Component.Library.mpb
    • Microsoft.SystemCenter.Visualization.Library.mpb
  5. Click "Install"

    Import Management Pack

  6. Click "Close"

9. Deploy the update to the agents

  1. Start the System Center Operations Manager Console and select the "Administration pane"
  2. Select " Device Management" and then "Pending Management"
  3. Select the a "Agent" and click "Approve"

    Aprove

  4. On the "Agent Update" page click "Update"

    Update

  5. when you open de the "Agent by Version" view you should see something like this:

    UpdatedWorkStations

More information on installing Update Rollup 10 for System Center Operations Manager 2012 sp1 can be found here.