'Safe' ThenWhen subquery7. 'Safe' Then '#ffadad'When subquery6. 'Safe' ThenWhen subquery4.

'Safe' Then '#ffadad'Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetIDInner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.AssettypeInner Join tsysIPLocations On tsysIPLocations.LocationID =Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetIDInner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softIDLeft Join tsysOS On tsysOS.OScode = tblAssets.OScodeInner Join tblState On tblState.State = tblAssetCustom.StateLeft Join (Select Distinct Top 1000000 tblAssets.AssetID,TblNetworkAdapter.Name As NetworkAdapter,TblNetworkAdapter.Manufacturer As AdapterManufacturer,When (tblNetworkAdapter.Name Like '%AX201%' OrTblNetworkAdapter.Name Like '%9461%') AndTblNetworkAdapter.Manufacturer Like '%Intel%' ThenTblAssets.AssetID = tblNetworkAdapter.AssetIDEnd = 'Yes') As subquery1 On subquery1.AssetID = tblAssets.AssetIDLeft Join (Select Top 1000000 tblAssets.AssetID,When tblSoftwareUni.softwareName Like '%VTune%Profiler%' AndCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 2021 ThenCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 2021 AndCast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 1 ThenCast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 1 AndCast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 1 ThenWhen tblSoftwareUni.softwareName Like '%VTune%Profiler%' ThenWhere tblSoftwareUni.softwareName Like '%VTune%Profiler%') As subquery2 OnTblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%'And Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 4 ThenAnd Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 4 AndCast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 5 ThenEnd As Where tblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%')As subquery3 On subquery3.AssetID = tblAssets.AssetIDWhen tblSoftwareUni.softwareName Like '%Driver & Support Assistant%' AndCast(ParseName(tblSoftware.softwareVersion, 4) As bigint) > 20 ThenCast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 20 AndCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 11 ThenCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 11 AndCast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 50 ThenCast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 50 AndCast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 9 ThenWhen tblSoftwareUni.softwareName Like '%Driver & Support Assistant%'Where tblSoftwareUni.softwareName Like '%Driver & Support Assistant%') AsSubquery4 On subquery4.AssetID = tblAssets.AssetIDWhen tblSoftwareUni.softwareName Like '%Intel Unite%Client%' AndCast(ParseName(tblSoftware.softwareVersion, 4) As bigint) > 4 ThenCast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 4 AndCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 2 ThenCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 2 AndCast(ParseName(tblSoftware.softwareVersion, 2) As bigint) >= 25031When tblSoftwareUni.softwareName Like '%Intel Unite%Client%' ThenWhere tblSoftwareUni.softwareName Like '%Intel Unite%Client%') As subquery5When tblSoftwareUni.softwareName Like '%PMem Software%' AndCast(ParseName(tblSoftware.softwareVersion, 4) As bigint) > 2 ThenWhen tblSoftwareUni.softwareName Like '%DCPM Software%' AndCast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 1 AndCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 0 ThenCast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 0 AndCast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 0 ThenCast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 0 AndCast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 3515 ThenCast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 2 AndWhen tblSoftwareUni. 'Safe' ThenWhen subquery10. 'Safe' Then '#ffadad'When subquery9.

Intel Drivers Update Assistant