Query to get IP address ,DomainName,OS_version for Server

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  March 16, 2011 at 12:04 pm

  #233339

  Hi any query for getting IP address ,DomainName,OS_version for Server and

  query for getting Instance_nm,Dbms_version,Port_number for all the instances running on that server .

  Thanks in advance

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 16, 2011 at 12:09 pm

  #1299561

  You'll be able to get all of that through a CLR function/proc. Is that an option for you?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• YTZ

  SSCommitted

  Points: 1707

  More actions

  March 16, 2011 at 12:37 pm

  #1299585

  master..xp_cmdshell 'ipconfig'

  GO

  SELECT SERVERPROPERTY('ProductVersion') AS 'ProductVersion'

  GO

  DECLARE @chvDomainName NVARCHAR(100)

  EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon', N'CachePrimaryDomain',@chvDomainName OUTPUT

  SELECT @chvDomainName AS DomainName

  GO

  DECLARE @tcp_port nvarchar(5)

  EXEC xp_regread

  @rootkey = 'HKEY_LOCAL_MACHINE',

  @key = 'SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP',

  @value_name = 'TcpPort',

  @value = @tcp_port OUTPUT

  select @tcp_port AS Port_Number

  GO

  master..xp_cmdshell 'SQLCMD -L'

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  March 16, 2011 at 12:56 pm

  #1299600

  I would probably do this in SSIS with a WMI query..

  CEWII

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  March 16, 2011 at 2:50 pm

  #1299666

  Hi can you please provide me with WMI query to get the Server Name, instance names, IP address,OS_version,Dbms_version,Domain,Portnumbers for each instance

  Thanks in advance