WSUS 3.0 database tables?

[Claude Lachapelle]

Hi!

It seem that WSUS 3.0 database are now more complicated than version 2.0 --
I explain, before with MSDE Query, I was able to get all informations related
to a computer by querying only one table, now the same informations in that
computers table are missing, so I assume it have been stored in another table.

My question is, where I could find the database table schema or if someone
could provide me the list of table I will do my homeworks!

I saw on the Microsoft web site, a WSUS SDK, does this is something that
could help me querying WSUS database for inventory informations?

Thanks.

Claude Lachapelle
Systems Administrator, MCSE

[Claude Lachapelle]

Finally I found this documentation about using WSUS Views... but still unable
to list computer elements from PUBLIC_VIEWS.vComputerTarget using MSDE Query.

http://msdn2.microsoft.com/en-us/library/bb410149.aspx

Anybody knows how to access views into MSDE Query?

Thanks.

[Ivan.V...@gmail.com]

Hi Claude,

Yes. Install SQLCMD on your wsus server.

Connect as following

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E
1> select * from PUBLIC_VIEWS.vComputerTarget
2> go

This will return all records. I am still trying to find out how to
export this to csv file or html report.

Cheers,

Ivan Versluis
http://www.networknet.nl

On Dec 4 2007, 2:56 pm, Claude Lachapelle

> > Systems Administrator, MCSE- Hide quoted text -
>
> - Show quoted text -

[Claude Lachapelle]

Thanks for the information... I installed the SQLCMD utility and tried your
commands, and I'm always getting:

Msg 208, Level 16, State 1, Server WSUS01\MICROSOFT##SSEE, Line 1
Invalid object name 'PUBLIC_VIEWS.vComputerTarget'.

What's wrong with my WSUS server? I'm using the built in database engine...
not the SQL one.

Thanks.

[leny.b...@gmail.com]

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -D "Database" -Q "Query"