Recently, we were looking into when someone had updated some management packs and when. I went digging a bit and found the following query helped me out. Run it against the OperationsManager database.
Here is the plaintext code:
SELECT TOP (1000) [MPName]
ORDER BY [MPLastModified] DESC
My operations team runs System Center Operations Manager 2012 R2 internally.
I host the OperationsManager database on a SQL Server 2012 Availability Group, and for the most part, it works well. However, for space reasons, we needed to move the Data Warehouse database to its own server backed by SAN storage.
After following this guide (https://technet.microsoft.com/en-us/library/hh268492.aspx), the database was successfully moved, and the data is flowing correctly. In addition, all reporting is working as expected. It was moved from scomsql (SQL 2012 Availability Group) to scomsql3 (standalone instance).
Everything worked out except for the Get-SCOMDataWareHouseSetting PowerShell cmdlet. It would return the name of the old server.
To find the current value, I ran the following:
And now it returns the correct value.
Update: due to the vagaries of WordPress, I’m linking to the SQL script here.