Hi,
Fairly new to this, but loving the product.
I have written a custom report but struggling to get OS in the report after model, I want it to show "Windows 7" and so on....
Can anyone help? report below:
Select Top 1000000 tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.Processor,
tblAssetCustom.PurchaseDate,
tblOperatingsystem.InstallDate,
tblAssetCustom.Warrantydate,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssetCustom.State = 1