→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cjcox
Engaged Sweeper III
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
0 REPLIES 0