Having multiple sites and checking the status of WSUS synchronization on all servers tedious job and child sites must sync with its parent sites to ensure right compliance levels from clients.
This report will give you the status of WSUS server with Right content version.
When SCCM sync with Microsoft Updates,Content version will get increment to +1 and it passes this information to its child sites to sync with right version.
US.SiteCode, S.ServerName, S.SiteName, US.ContentVersion, US.SyncTime
update_syncstatus US, v_Site S
where US.SiteCode=S.SiteCode and US.contentversion <@Version
Prompt for @Version :
SELECT distinct ContentVersion from