Hi Guy's,
Hoping you can help with a report. I have the following report which we are using to manage out upgrades to Windows 10 1903. We are targeting certain sites first and versions etc.
The issue I have is some of our early Toshiba Laptops came with Infineon TPM Professional installed. This is a Trusted Platform Module which prevents the Windows 10 upgrades from occurring unless its uninstalled first.
What I would like is for the below report to also advise if this software is installed, if it is, have a yes / no columm and colour coded if possible.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Version,
tblAssets.Domain,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As Type,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.IPAddress Is Not Null And tblAssets.IPAddress != '' And
tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
Order By tblAssets.Version,
tblAssets.IPNumeric
