SQL: Query SUSDB for MS17-010
-
Has anyone made a query to peer in the SUSDB for the presence of a specific update being applied? I was hoping someone else has this so I can copy their work.
-
Rather than query the SQL backend use Powershell!
-
I found an article on technet that pointed me to the right table. For reference, it's vComputerTarget. If you are using Excel, like me, then you can make the sql connection to that table in the sudb and get the meaningful material. Finding the technet article took a bit of searching. If anyone else needs it, here you go.
https://msdn.microsoft.com/en-us/library/windows/desktop/bb410149(v=vs.85).aspx
-
Cant you just use the wsus console to view this information? It will tell you how many computers and which computers need/have a specific update applied.
I suppose you could take that page, find the query it uses and copy it.
Or just use the console.
