→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tamirt
Engaged Sweeper II
I need a reports for:

1. all servers that warranty end until 31.12.2017

Thks
Tamir
2 REPLIES 2
tamirt
Engaged Sweeper II
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
Engaged Sweeper III
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