Windows: Disk with no NTFS filesystem (Built-in)

[Daniel_B]

Old name: Disk: No NTFS filesystem (Built-in)

The report lists Windows assets without NTFS formatted hard-disk

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• The asset has no hard-disk with NTFS file system available

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblDiskdrives.Caption AS Drive, 
  tblDiskdrives.FileSystem
From tblAssets
 Inner Join tblDiskdrives ON tblDiskdrives.AssetID = tblAssets.AssetID
 Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
 Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
 Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID 
 Inner Join tblState On tblState.State = tblAssetCustom.State
 Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active' 
 And tblDiskdrives.FileSystem != 'NTFS' And tblDiskdrives.FileSystem <> '' 
 And (Case When tblDiskdrives.DriveType = 3 then 'Local Disk' else '' end) = 'Local Disk'
Order By tblAssets.Domain, tblAssets.AssetName