Endpoint Insights
How Many Software Updates Are Within My WSUS Database?

Receive notification right in your inbox whenever new content like this is released & sign up for our email list!
We’ll send you the latest updates, how-to’s, and solutions to empower you at every endpoint.
By signing up you agree to our Privacy Policy.
Recently I set up System Center Configuration Manager to work in an air gap environment. During this process, I needed to determine the number of software updates (SU) that were within the Windows Software Update Services (WSUS) database. Being a bit of a SQL guy, I opened SQL Server Management Studio (SSMS) and queried the WSUS database.
If you ever find yourself in a similar situation, use this query to determine how many English SU are within your WSUS database.
To find other locales, simply change the locale ID number to the appropriate ID number. A list of locale IDs can be found on the following MSDN site. https://msdn.microsoft.com/en-us/goglobal/bb964664.aspx
select CT.Title, C.DefaultTitle, Count(*) from [PUBLIC_VIEWS].[vUpdate] U join [PUBLIC_VIEWS].[vClassificationText] CT on CT.ClassificationId = U.ClassificationId and LocaleId = 1033 join [PUBLIC_VIEWS].[vUpdateInCategory] UIC on U.UpdateId = UIC.UpdateId and UIC.CategoryType = ‘Product’ join [PUBLIC_VIEWS].[vCategory] C on C.CategoryId = UIC.CategoryId Group by CT.Title, C.DefaultTitle order by CT.Title, C.DefaultTitle
|
I hope that you find this information useful. If you have any questions about how to find out the number of software updates in your WSUS database, please feel free to leave a note in the comment section below or contact me at @GarthMJ.
Related Resources

Customer Stories: Endpoint Insights Enables Powerful Device Warranty Management for Carr, Riggs & Ingram



Better Together: Endpoint Insights and Right Click Tools Webinar Highlights






Endpoint Insights: Create a Collection of Computers with a Specific Docking Station






Use Endpoint Insights to Budget with Confidence, Gain Asset Insights, and Stay Ahead of Issues





















