Hi,
I have the below code and I want to limit the report result of all NOT SCANNED OS ONLY
Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Custom6 As 'Environment',
tblAssetCustom.Location,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Domain,
tblAssetCustom.Custom1 As 'Technology Product',
tblAssetCustom.Custom2 As 'Application Name',
tblAssetCustom.Custom3 As 'Asset Role',
Case
When Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease,
tblMacOSInfo.SystemVersion) Is Null Then 'Not Scanned'
Else Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease,
tblMacOSInfo.SystemVersion)
End As 'Operating System',
tblAssetCustom.Custom4 As 'Contact Person',
tblAssetCustom.Custom5 As 'IT Support Unit',
tblAssetCustom.Custom8 As 'Remote IP',
tblAssetCustom.Custom16 As 'Provision Mode',
tblAssetCustom.Custom7 As 'Rack Number',
tblAssetCustom.Custom17 As 'PCI Status',
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Where tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
TIA
