Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Feature Requrest - SQL SERVER Detection https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6321 |
Page 1 of 1 |
Author: | torstenj1969 [ Tue Apr 22, 2014 11:05 pm ] | ||
Post subject: | Feature Requrest - SQL SERVER Detection | ||
Hi to the Team! I have here a Little script which will Show more detailed informations about SQL Server installations. Is it possible to add this script? Within the XLS is a complete list about all current existing SQL Servers with detailed informations about Version Number, File System Numbers, Release Date and (very important) also the fact if it is a MSDN Edition. It would be great if it is possible to Color the line in the Database if the SQL Server would be a MSDN Edition because that is a licence violation if you use this within an production Environment. [code] Dim strSKUName,strSPLEVEL,strVERSION,strFILEVERSION Dim objWMI, objProp On Error Resume Next 'First, seek for SQL Server 2000/2005: Set objWMI = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement") If Err.Number <> 0 Then ' Now try SQL Server 2008/2008 R2: Set objWMI = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement10") If Err.Number <> 0 Then ' Next, try SQL Server 2012: Set objWMI = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement11") End If End If For Each objProp In objWMI.ExecQuery("select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'SKUNAME'") strSKUName = objProp.PropertyStrValue next For Each objProp In objWMI.ExecQuery("select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'SPLEVEL'") strSPLEVEL = objProp.PropertyStrValue next For Each objProp In objWMI.ExecQuery("select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'VERSION'") strVERSION = objProp.PropertyStrValue next For Each objProp In objWMI.ExecQuery("select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'VERSION'") strFILEVERSION = objProp.PropertyStrValue next WScript.Echo strSKUName WScript.Echo strSPLEVEL WScript.Echo strVERSION WScript.Echo strFILEVERSION [/code] In addition it would be great also to add the Value "CLUSTERED" and to check how many instance of the SQL Server are running but I have currently no clue how to filter addional values. Here is a CSV list of all values within "SqlServiceAdvancedProperty" [code] IsReadOnly,PropertyIndex,PropertyName,PropertyNumValue,PropertyStrValue,PropertyValueType,ServiceName,SqlServiceType,SetNumericalValue,SetStringValue,SetBoolValue True,0,CLUSTERED,0,,1,SQLAgent$ADK,2,,, True,0,CLUSTERED,0,,1,SQLBrowser,7,,, True,0,SQLSTATES,2099205,,2,MSSQL$ADK,1,,, True,1,INSTANCEID,,MSSQL11.ADK,0,SQLAgent$ADK,2,,, True,1,INSTANCEID,,MSSQL11.ADK,0,SQLBrowser,7,,, True,1,VERSION,,11.0.2100.60,0,MSSQL$ADK,1,,, True,2,VSNAME,,,0,SQLAgent$ADK,2,,, True,2,SPLEVEL,0,,2,MSSQL$ADK,1,,, False,2,ERRORREPORTING,0,,1,SQLBrowser,7,,, True,3,CLUSTERED,0,,1,MSSQL$ADK,1,,, False,3,ERRORREPORTING,0,,1,SQLAgent$ADK,2,,, False,3,DUMPDIR,,C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL\LOG\,0,SQLBrowser,7,,, False,4,DUMPDIR,,C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL\LOG\,0,SQLAgent$ADK,2,,, False,4,SQMREPORTING,0,,1,SQLBrowser,7,,, True,4,INSTALLPATH,,C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL,0,MSSQL$ADK,1,,, False,5,SQMREPORTING,0,,1,SQLAgent$ADK,2,,, False,5,BROWSER,1,,1,SQLBrowser,7,,, True,5,DATAPATH,,C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL,0,MSSQL$ADK,1,,, True,6,LANGUAGE,1033,,2,MSSQL$ADK,1,,, True,6,ISWOW64,1,,1,SQLAgent$ADK,2,,, True,6,ISWOW64,1,,1,SQLBrowser,7,,, True,7,FILEVERSION,,2011.110.2100.60,0,MSSQL$ADK,1,,, True,8,VSNAME,,,0,MSSQL$ADK,1,,, True,9,SKU,-1592396055,,2,MSSQL$ADK,1,,, True,10,SKUNAME,,Express Edition,0,MSSQL$ADK,1,,, True,11,REGROOT,,Software\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL11.ADK,0,MSSQL$ADK,1,,, True,12,INSTANCEID,,MSSQL11.ADK,0,MSSQL$ADK,1,,, False,13,STARTUPPARAMETERS,,-dC:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL\DATA\master.mdf;-eC:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL\Log\ERRORLOG;-lC:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL\DATA\mastlog.ldf,0,MSSQL$ADK,1,,, False,14,ERRORREPORTING,0,,1,MSSQL$ADK,1,,, False,15,DUMPDIR,,C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.ADK\MSSQL\LOG\,0,MSSQL$ADK,1,,, False,16,SQMREPORTING,0,,1,MSSQL$ADK,1,,, True,17,ISWOW64,1,,1,MSSQL$ADK,1,,, [/code] Thanks in advance!
|
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |