A Simple Report (or so I thought)

[vantive]

I am just trying to get a report of active computers that include both apple and windows devices and include the email address from the logged in user AD account. I do not see any in the canned reports that works for me.

Anyone have one they can share?

[Andy_Sismey]

Does this work for you ?

Select Top 1000000 tblAssets.AssetName,
  tsysAssetTypes.AssetTypename As [Asset Type],
  tblAssets.Domain,
  tsysOS.OSname As [OS name],
  tblADusers.email,
  tblAssetCustom.Manufacturer,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.Description
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
  Left Join tblComputerSystemProduct On
    tblAssets.AssetID = tblComputerSystemProduct.AssetID
  Left Join (Select Case
          When tblComputersystem.Domainrole > 1 Then 'Server'
          Else 'Workstation'
        End As type,
        tblComputersystem.AssetID
      From tblComputersystem) tComputersystem On tblAssets.AssetID =
    tComputersystem.AssetID
  Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Where (tsysAssetTypes.AssetTypename Like '%ios%' Or
    tsysAssetTypes.AssetTypename Like '%Windows%') And tblAssetCustom.State = 1
Order By tblAssets.AssetName