Find BOOTCAMP'd Windows machines (Windows on Apple devices)

[cjcox]

There's a final qualifier at the bottom that makes an extra check for a BOOTCAMP labeled volume... however if you rename your volumes, you can remove that one and it will still look for Windows running on Apple hardware.

Select Top (1000000) tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Mac,
  tblAssetCustom.Serialnumber,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Contact,
  tblAssetCustom.Model,
  tblAssets.Description,
  tblAssets.Processor,
  tblAssets.Memory,
  tblLinuxSystem.OSRelease,
  tblLinuxSystem.OperatingSystem,
  tblMacOSInfo.SystemVersion,
  tblOperatingsystem.Caption,
  tblVolume.Label
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 tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
  Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblVolume On tblAssets.AssetID = tblVolume.AssetID
Where tsysAssetTypes.AssetTypename = 'Windows' And
  tblAssetCustom.Manufacturer Like '%Apple%' And tblAssetCustom.Model Not In
  ('KVM', 'VMware Virtual Platform') And tblVolume.Label = 'BOOTCAMP' And
  tblAssetCustom.State = 1