ESX or XEN is no "computer"?

[Fossy777]

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

[Hemoco]

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]

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]

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]

Hi Support,

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

Best regards, Jochen

[Hemoco · Accepted solution]

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