There is no published schema and direct access to the WSUS database schema
>> Stay informed about: query the WSUS sql db
is not supported.
Access to the WSUS database data is accomplished via the WSUS API. The SDK
can be downloaded from the WSUS website.
"Bob Findlay" wrote in message
> I would like to search the SQL database that WSUS creates, but I'm having
> trouble working out how it all fits together. Is there a published
> schema anywhere?
> What I would like to do, is run an SQL query which will return a list of
> updates which are required but have not been approved for "all computers".
> This list could then be e-mailed so that we don't have to check the status
> the server every day
> Any ideas?