SQL report will show Name Serial Number Manufacturer Model OS Type OS Version TopConsoleUser0 Last Logged BIOS Date IP Address Default IP Gateway Chassis Type

For Server :
SQL :

SELECT   
 dbo.v_GS_COMPUTER_SYSTEM.Name0 AS [NetBIOS Name], 
 --dbo.v_GS_COMPUTER_SYSTEM.Roles0 AS [Roles],
 dbo.v_GS_OPERATING_SYSTEM.Description0 AS [Description], 
 dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS [Make],
 dbo.v_GS_COMPUTER_SYSTEM.Model0 AS [Model], 
 dbo.v_RA_System_IPAddresses.IP_Addresses0 AS [IP Address], 
 dbo.v_GS_SYSTEM_ENCLOSURE.SerialNumber0 AS [Service Tag (Dell)]
 
FROM         dbo.v_GS_COMPUTER_SYSTEM
  
 INNER JOIN  
  dbo.v_GS_PC_BIOS 
  ON 
  dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_GS_PC_BIOS.ResourceID 
 INNER JOIN 
  dbo.v_RA_System_IPAddresses 
  ON
  dbo.v_GS_PC_BIOS.ResourceID = dbo.v_RA_System_IPAddresses.ResourceID 
 INNER JOIN
  dbo.v_GS_SYSTEM_ENCLOSURE 
  ON
  dbo.v_RA_System_IPAddresses.ResourceID = dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID 
 INNER JOIN
  dbo.v_GS_OPERATING_SYSTEM 
  ON
  dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID 
 WHERE    
  (dbo.v_RA_System_IPAddresses.IP_Addresses0 LIKE '10.%')
  AND
  (Roles0 like '%Server_NT%')
ORDER BY
  [NetBIOS Name]