Notification

Icon
Error

Report for NOT SCANNED OS - Report that display failed scan OS - limited to windows active server

Posted: Wednesday, October 30, 2019 9:43:00 AM(UTC)
Alexandria

Alexandria

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

Active Discussions

Lansweeper "add cc user" doesn't show the correct listings
by  JLPingree   Go to last post Go to first unread
Last post: Yesterday at 8:12:44 PM(UTC)
Lansweeper Default User Date Format
by  RickW99456  
Go to last post Go to first unread
Last post: Yesterday at 5:00:51 PM(UTC)
Lansweeper Duplicate assets (Servers)
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 3:20:28 PM(UTC)
Lansweeper Lansweeper load the disk subsystem
by  Alexey Gorbachev  
Go to last post Go to first unread
Last post: Yesterday at 3:13:17 PM(UTC)
Lansweeper Lost Configuration tab (Admin rights)
by  kspap   Go to last post Go to first unread
Last post: Yesterday at 10:30:12 AM(UTC)
Lansweeper Deployment with different user rights
by  Jupiter_IT  
Go to last post Go to first unread
Last post: Yesterday at 9:39:20 AM(UTC)
Lansweeper cisco fuji device not linking with connected devices
by  char   Go to last post Go to first unread
Last post: 7/5/2020 9:12:07 AM(UTC)
Lansweeper Microsoft CVE-2020-1425
by  Richard_B  
Go to last post Go to first unread
Last post: 7/3/2020 4:29:41 PM(UTC)