warranty end for servers

[tamirt]

I need a reports for:

1. all servers that warranty end until 31.12.2017

Thks
Tamir

[tamirt]

Hi

I need your help to change this reporet as all my serevrs run Vmware esxi 5.5 and so as this look for OS and as all my server os are vmware it will not give me any info
so i need to look for the hardware of os as for dell hp servers and for them i need the info as for warranty

thanks
Tamir

[Niko0]

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssetCustom.Serialnumber As [Identifying Number],
  tblAssetCustom.PurchaseDate As [Purchase Date],
  tblAssetCustom.Warrantydate As [Warranty Expiration],
  tblAssets.Domain,
  tblAssets.Username,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.Lastseen
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
    And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssetCustom.Warrantydate < '2017.12.31' And
  tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc