|
WSUS SUS Wiki Community |
The WSUS database is meant to be used only by WSUS iteslf. To access WSUS data you should be using the various object models plus scripting - direct manpulation of the DB is not supported.
Comments:From Coprinicus - 10/18/05 5:54 AM Last Modified 10/19/05 7:45 AM | Hide Tools |
Gotta a question a little perhaps beyond the scope of this forum... but I will ask.
I was playing around with the WSUS$DB and threw it into SQL, then exported it into a .MDB.
I did this because I wanted a way to generate a status email to my WorkGroup managers on the same information that you would see when you went to the /servername/wusadmin administration site and pulled a listing of Updates on that particualr server. (Without telling them where to go, since I have not figured out how to lock out and particular permission functionality to the web admin tool.)
Anyhow, when I looked at the new .MDB, there was ALOT of information there and i could not really make heads or tails of how to start/combine any of them to form an intelligent query to show the information per update like you would see on the Updates tab in the web admin interface.
Anyone ever look at this?