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.
SELECT
US.SiteCode, S.ServerName, S.SiteName, US.ContentVersion, US.SyncTime
FROM
update_syncstatus US, v_Site S
where US.SiteCode=S.SiteCode and US.contentversion <@Version
ORDER BY
SyncTime
Prompt for @Version :
SELECT distinct ContentVersion from
update_syncstatus
4 Comments
Hi Eswar, Since being an newbie could you please explain how do i create a prompt value (or) specifically how can i fetch version details through query itself without giving an prompt?
Hi Praveen,
I do not have any blog post on 'how to create prompt value in SSRS' but if you have any variables used in the SQL report, prompts will be automatically created in tools that you use like BIDS,report builders etc and all you need is to go properties of the prompt and choose what is needed.
You can refer these post https://technet.microsoft.com/en-us/library/aa337432(v=sql.105).aspx and https://technet.microsoft.com/en-us/library/aa337401(v=sql.105).aspx
Regards,
Eswar
created Report but it is prompting for Version.. what exactly we need to provide input??
didnt the blog says to create prompt value ? like this for @Version:
SELECT distinct ContentVersion from
update_syncstatus