That info is not readily available from WMI as there's no SQL Server
class that I am aware of that holds that data.
However, I believe data you are looking for is in the registry and in
SQL tables, that could be gathered remotely using WMI's stdRegProv or
"ADODB.Command"s or from SQL-DMO
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode
= 1
-- SQL-Server mode
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode
= 2
-- Mixed-mode
(ADODB.Command and SQL-DMO would help you with SQL queries database
database enumerations.)
Steven
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
eyal edri
Sent: Sunday, November 12, 2006 6:28 AM
To: perl-win32-users@listserv.activestate.com
Subject: Extract SQL server information using WMI
(Scriptomatic..?)
Hi,
I'm trying to extract information from various SQL servers on
the network.
I can't find the proper WMI class in scriptomatic2 for this,
anyone know how can i get the SQL version (service pack) and any other
general info on the server?
(like authentication mode (mixed, windows), databases
installed....
thanks,
--
Eyal Edri | System & Security Engineer | [EMAIL PROTECTED]
Communication.
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
