SELECT 
  sys.netbios_name0, 
  wi.datescriptran0 AS [Timestamp data gathered],
  wi.ServiceTag0 AS [Service Tag],
  wi.SystemType0 AS [System Type],
  wi.provider0 AS [Provider],
  wi.shipdate0 AS [Ship Date],
  wi.Description0 AS [Description],
  wi.Startdate0 AS [Warranty Start Date],
  wi.Enddate0 AS [Warranty End Date],
  DATEDIFF(DAY,GETDATE(),wi.Enddate0) AS [Warranty Days Remaining],
  wi.WarrantyExtended0 AS [Warranty Extended],
  wi.dellIBU0 AS [Dell IBU]
FROM v_r_system as [SYS] 
JOIN v_gs_Warranty_Info2 AS [WI] 
ON sys.resourceid=wi.resourceid
ORDER BY sys.netbios_name0