Not seeing Macintosh computers in "Computer" asset reports

[bbazian]

Here is a report that I customized. Why do Mac computers not show up?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.Image As icon,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Memory,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As nvarchar) As [Disk size],
tblAssets.NrProcessors As #CPU,
tblAssets.Processor,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.BarCode,
tblAssetCustom.Serialnumber As Serial,
tblAssets.IPAddress As [IP Address],
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.BarCode <> '0000' And tblAssetCustom.State = 1 And
tblDiskdrives.Caption = 'c:'
Order By tblAssets.AssetUnique

[Susan_A · Accepted solution]

The problem is the way tblDiskdrives and tsysOS (Windows-only tables) are linked to tblAssets. Use the report below instead.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tsysOS.OSname,
  tblAssets.Description,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.Memory,
  SubQuery1.[Disk size],
  tblAssets.NrProcessors As #CPU,
  tblAssets.Processor,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.BarCode,
  tblAssetCustom.Serialnumber As Serial,
  tblAssets.IPAddress As [IP Address],
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
  Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join (Select Top 1000000 tblDiskdrives.AssetID,
    Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 /
    1024 As numeric) As nvarchar) As [Disk size]
  From tblDiskdrives
  Where tblDiskdrives.Caption = 'c:') SubQuery1 On SubQuery1.AssetID =
    tblAssets.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tsysAssetTypes.AssetTypename Like '%windows%' Or
    tsysAssetTypes.AssetTypename Like '%mac%') And tblAssetCustom.BarCode <>
  '0000' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName