With the SQL view vSMSSUPSyncStatus, there is a column SyncCatalogVersion. This column allows you to see what version of the WSUS (pronounced “W” “SUS”) catalog is available at each software update point (SUP). When troubleshooting CMCB environment with two or more SUP it is import to know what catalog is at each SUP server. The vSMSSUPSyncStatus has many more details available to it as compared to any of the existing SUP SQL views.
So why is this information important? Knowing Catalog version #, sync date, sync status, etc. helps when troubleshooting SUP issues. This also allows for a dashboards/reports to be created so that CM administrators can quickly look to see if there are any problems with their SUP thereby allowing them to quickly isolate what problems they might have or better yet eliminate that as the likely issue. This will also allow CM admin to meet and validate they are meeting this KPIs for SU sync times.