Notification

Icon
Error

Help With Field And Colour Coded Report

Posted: Monday, November 4, 2019 1:01:27 AM(UTC)
CyberCitizen

CyberCitizen

Member Original PosterPosts: 266
0
Like
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.

Code:
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

Active Discussions

Installer Windows 10 Upgrade
by  CyberCitizen  
Go to last post Go to first unread
Last post: 12/2/2019 12:20:57 AM(UTC)
Installer Team Viewer Host update / install
by  BastiOn   Go to last post Go to first unread
Last post: 11/27/2019 2:09:10 PM(UTC)
Installer Office 2016 Update
by  Cem Serdar  
Go to last post Go to first unread
Last post: 11/7/2019 12:05:50 PM(UTC)
Installer Mozilla FireFox 70.0 Install
by  CyberCitizen   Go to last post Go to first unread
Last post: 11/7/2019 12:09:14 AM(UTC)
Installer Update Chrome browser with GoogleUpdate.exe ?
by  Mike Carey  
Go to last post Go to first unread
Last post: 11/6/2019 10:35:43 PM(UTC)
Installer CutePDF and Ghostscript install (Print to PDF)
by  Ruben1  
Go to last post Go to first unread
Last post: 10/15/2019 10:35:05 AM(UTC)