[OpsMgr] Compare Management Packs Across Management Groups

The following query will give you the version of each management pack on multiple management groups. Replace MG1 and MG2 with your management group names. This is only useful if you have multiple management groups reporting to the same data warehouse.

With MPs(MG, MP, Version)
AS (
SELECT     vManagementGroup.ManagementGroupDefaultName, vManagementPack.ManagementPackDefaultName, vManagementPackVersion.ManagementPackVersion
FROM         vManagementGroupManagementPackVersion INNER JOIN
                      vManagementGroup ON vManagementGroupManagementPackVersion.ManagementGroupRowId = vManagementGroup.ManagementGroupRowId INNER JOIN
                      vManagementPackVersion ON
                      vManagementGroupManagementPackVersion.ManagementPackVersionRowId = vManagementPackVersion.ManagementPackVersionRowId INNER JOIN
                      vManagementPack ON vManagementPackVersion.ManagementPackRowId = vManagementPack.ManagementPackRowId
)
Select MP, MG1, MG2
from MPs
Pivot (
      max(Version)
      FOR MG in ([MG1], [MG2])) as pvt

Sample Output: