SQL database Reporting

Usage and Config
1

(imported topic written by Gallus2391)

Hi All,

Is it possible for BigFix to list the number and name of SQL database on a server.

Can if query SQL driect as I don’t belive this information is in the registry

Mike.

2

(imported comment written by jessewk)

Does this get you close?

http://forum.bigfix.com/viewtopic.php?id=295

3

(imported comment written by Gallus2391)

Closer yes. Is there any way to list the databases that are within SQL ?

4

(imported comment written by sthull)

Hi Mike,

You would have to use a command line tool to query SQL, like osql:

osql -U sa -P pswd -Q “select name from sysdatabases” > sqldbs.out

Then use ‘lines of file “sqldbs.out”’ relevance to pull the info you want.

Regards,

Steve

5

(imported comment written by Gallus2391)

Ok. I’ll give it a try. Thanks