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

Lansweeper All USB devices connected
by  RC62N  
Go to last post Go to first unread
Last post: Yesterday at 6:40:58 PM(UTC)
Lansweeper Software audit with installation date
by  RC62N   Go to last post Go to first unread
Last post: 7/3/2020 3:39:41 PM(UTC)
Lansweeper Duplicates (3-4) in report please helppppp!
by  AlexMZetec  
Go to last post Go to first unread
Last post: 7/2/2020 3:15:16 PM(UTC)
Lansweeper Report to find all computers with no logon data
by  Andy.S  
Go to last post Go to first unread
Last post: 7/2/2020 9:55:53 AM(UTC)
Lansweeper Change processes report to show opposite results
by  RC62N   Go to last post Go to first unread
Last post: 6/29/2020 9:38:46 PM(UTC)
Lansweeper Keep link to items when using column names
by  Tom Galvin  
Go to last post Go to first unread
Last post: 6/27/2020 12:16:03 AM(UTC)