Welcome to ServerForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

query the WSUS sql db

 
   Windows Server (Home) -> Windows Server Update Services RSS
Next:  Faster Deployments  
Author Message
Bob Findlay

External


Since: Jan 20, 2005
Posts: 8



(Msg. 1) Posted: Thu Dec 15, 2005 11:58 am
Post subject: query the WSUS sql db
Archived from groups: microsoft>public>windows>server>update_services (more info?)

hi
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 database
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 of
the server every day

Any ideas?

Cheers,

Bob

 >> Stay informed about: query the WSUS sql db 
Back to top
Login to vote
"Lawrence Garvin

External


Since: Dec 05, 2005
Posts: 889



(Msg. 2) Posted: Fri Dec 16, 2005 1:31 am
Post subject: Re: query the WSUS sql db [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There is no published schema and direct access to the WSUS database schema
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

> hi
> 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
> database
> 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
> of
> the server every day
>
> Any ideas?
>
> Cheers,
>
> Bob

 >> Stay informed about: query the WSUS sql db 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How do you query the WSUS database directly?? - Our organization needs to comply with various vulnerability alerts put out by organizations such as CERT. We need to correlate the MS security bulletin number to KB article number to the CERT announcement number to the computers that need to be..

How to query WSUS for servers pending a reboot? - Is there a way to get a list of servers that are waiting for a reboot to finish applying patches? I know I can go look at each patch indivitually, I'd prefer a SQL query if possible. Thanks!

Extremely slow query performance WSUS/MSDE - Hello, I have set up WSUS on a Win 2000 Server, which has 512MB RAM and 2,4GHz Pentium 4 CPU. The database is MSDE, used only for the single purpose of storing WSUS data and was the latest package that came with SQL Server 2000's SP4. Whenever I..

Update Searcher Search query - The Search method for update searcher allows you to specify a criteria string. Part of that allows you to specify the type of update you are searching for. The SDK gives examples of Driver and Software. "Software" is a bit too generic for my...

Another Connection to Database Failed Query - Hello everyone, has anyone seen this one: Error from Event Log - Application Log: ---- Connection to database failed. Reason=Cannot open database "SUSDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK ...
   Windows Server (Home) -> Windows Server Update Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Warning: fopen(/home/adsense_reject.txt) [function.fopen]: failed to open stream: Permission denied in /home/autoforu/public_html/Giga/GigaFunctions.php on line 1142

Warning: fwrite(): supplied argument is not a valid stream resource in /home/autoforu/public_html/Giga/GigaFunctions.php on line 1143

Warning: fclose(): supplied argument is not a valid stream resource in /home/autoforu/public_html/Giga/GigaFunctions.php on line 1144



[ Contact us | Terms of Service/Privacy Policy ]