RE: Generate a SQL Server Instance Inventory

SSC Veteran

Points: 286

September 4, 2008 at 7:56 am

How can i determine the reporting services or analysis services in this extract of my network ?

[font="Courier New"]ServerIP,TCPPort,ServerName,InstanceName,BaseVersion,SSNetlibVersion,TrueVersion,ServiceAccount,IsClustered,Details,DetectionMethod

10.15.104.31,1433,FRXTLTORX20,MSSQLSERVER,9.00.1399.06,9.0.1399,9.00.1399.06,CONSOTO\SRVS-SQL_TURBO,No,(UDP)ServerName;FRXTLTORX20;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.1399.06;tcp;1433;;(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SA)Server present but blank SA login failed,UDP TCP WMI SCM SA

10.15.104.31,1433,FRXTLTORX20,SQL SERVER (MSSQLSERVER),9.00.1399.06,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA

10.15.104.90,1433,FRGHTGID20.CONSOTO.TRUCKS.COM,MSSQLSERVER,,,,,,,TCP

10.15.104.114,1433,FRXTLXORT10,MSSQLSERVER,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-sql_XORT,No,(UDP)ServerName;FRXTLXORT10;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.3042.00;tcp;1433;;(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SA)Server present but blank SA login failed(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,UDP TCP WMI SA SCM

10.15.104.114,1433,FRXTLXORT10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-sql_XORT,,(SA)Server present but required trusted context,REG SA

10.15.104.118,1433,FRXTLCERT10,MSSQLSERVER,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_CERT,No,(UDP)ServerName;FRXTLCERT10;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.3042.00;tcp;1433;;(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SA)Server present but blank SA login failed(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,UDP TCP WMI SA SCM

10.15.104.118,1433,FRXTLCERT10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_CERT,,(SA)Server present but required trusted context,REG SA

10.15.104.118,,FRXTLCERT10,MSSQLSERVEROLAPSERVICE,,,,CONSOTO\SRVS-SQL_CERT,,(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdsrv.exe" -s "C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config",WMI

10.15.104.123,1433,FRXTLTORX30,MSSQLSERVER,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_TURBO,No,(UDP)ServerName;FRXTLTORX30;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.3042.00;tcp;1433;;(SA)Server present but blank SA login failed(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,UDP TCP SA SCM WMI

10.15.104.123,1433,FRXTLTORX30,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA

10.15.104.124,1433,FRXTLXORT20,MSSQLSERVER,9.00.2047.00,9.0.2047,9.00.2047.00,CONSOTO\SRVS-SRVXORT-DEV,No,(UDP)ServerName;FRXTLXORT20;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.2047.00;tcp;1433;;(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SA)Server present but blank SA login failed,UDP TCP WMI SCM SA

10.15.104.124,1433,FRXTLXORT20,SQL SERVER (MSSQLSERVER),9.00.2047.00,,,CONSOTO\SRVS-SRVXORT-DEV,,(SA)Server present but required trusted context,REG SA

10.15.104.125,1433,FRXTLREP10,MSSQLSERVER,8.00.194,8.0.2039,8.00.2039,CONSOTO\SRVS-sql,No,(UDP)ServerName;FRXTLREP10;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;1433;np;\\FRXTLREP10\pipe\sql\query;;(WMI)StartMode:Auto State:Running Path:C:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe(SA)Server present but blank SA login failed(SCM)Start_Mode: 2 AUTO_START Path:C:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe,UDP REG TCP WMI SA SCM

10.15.104.158,1433,FRXTLTORX10.CONSOTO.TRUCKS.COM,MSSQLSERVER,,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_TURBO,,(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SA)Server present but blank SA login failed(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,TCP WMI SA SCM

10.15.104.158,1433,FRXTLTORX10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA

10.15.104.174,4650,FRXTLSXS30,INST20,9.00.3042.00,9.0.3239,9.00.3239.00,CONSOTO\SRVS-SQL_CRM,No,(UDP)ServerName;FRXTLSXS30;InstanceName;INST20;IsClustered;No;Version;9.00.3042.00;tcp;4650;;ServerName;FRXTLSXS30;InstanceName;INST30;IsClustered;No;Version;9.00.3042.00;tcp;3250;;(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.6\MSSQL\Binn\sqlservr.exe" -sINST20(SA)Server present but blank SA login failed(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.6\MSSQL\Binn\sqlservr.exe" -sINST20,UDP WMI SA SCM

10.15.104.174,3250,FRXTLSXS30,INST30,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_CRM,No,(UDP)ServerName;FRXTLSXS30;InstanceName;INST20;IsClustered;No;Version;9.00.3042.00;tcp;4650;;ServerName;FRXTLSXS30;InstanceName;INST30;IsClustered;No;Version;9.00.3042.00;tcp;3250;;(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlservr.exe" -sINST30(SA)Server present but blank SA login failed(SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlservr.exe" -sINST30,UDP WMI SA SCM[/font]