Posts

Showing posts with the label System

How to Find System Server details using SQL

Image
DECLARE @test varchar ( 20 ) ,             @key varchar ( 100 ),             @NUMBER_OF_PROCESSORS   varchar ( 20 ) ,             @PROCESSOR_IDENTIFIER   varchar ( 100 ) ,             @SystemManufacturer   varchar ( 20 ) ,             @ProcessorNameString varchar ( 100 ),             @connection varchar ( 50 ),             @SystemProductName varchar ( 100 ) select             @connection = convert ( varchar ( 50 ), CONNECTIONPROPERTY ( 'local_net_address' ), 1 ) set @key = 'System\CurrentControlSet\Control\Sess...