→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Fossy777
Engaged Sweeper III
Hi,

I wonder about report "Computer: Warranty overview". It does not contain ESX and VMware hosts, though I think these ARE computers and not devices. Wouldn´t it be good to change this default report to also contain these?

I would appreciate it if somebody shares the neccessary sql query to update this report to do that - myself I don´t have the time to figure out right now, sorry. I only found this right now I plan hardware support subscriptions for my budgets and thought I should tell...

Regards, Jochen
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
You can use the report below to list the warranty information of all of your assets.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
Order By tblAssets.IPNumeric

View solution in original post

5 REPLIES 5
Hemoco
Lansweeper Alumni
You can see the report criteria in the Criteria column. The only criterion we added is the one below, which excludes non-active machines from the report. All other machines should be included.
Where tblAssetCustom.State = 1
Fossy777
Engaged Sweeper III
Hi,

I can only say: here it does not. I have at least 3 VMware servers (active) which are not shown in this report. I also have some active devices not shown here, but for example the report "Devices: out of warranty in 90 days" shows the devices.

I simply copied the sql statement and created new report from it, so I uess there is also no error in my report.

Regards, Jochen
Hemoco
Lansweeper Alumni
The report we provided lists non-Windows machines as well. Please verify whether your non-Windows machines are set to non-active. Non-active assets are not included in the report.
Fossy777
Engaged Sweeper III
Hi Support,

thank you for your answer. This code also displays only Windows systems. Can have a look again, please?

Best regards, Jochen
Hemoco
Lansweeper Alumni
You can use the report below to list the warranty information of all of your assets.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
Order By tblAssets.IPNumeric

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now