All Computers Report

[PROSUser]

Hi there!

I cannot figure out to create a report that includes all my computers!!

I have windows, linux and OS X in my environment.

The report that I need is to show computer name, OS, last scan and username, it is simple, but when I do it, I only see the Windows OSs.. Can anyone help?

[PROSUser]

Thanks!!!

[Bruce_B · Accepted solution]

Non-Windows computers are likely being filtered out of your report because you're right joining a table that only contains Windows computer data, this action filters out non-Windows asset types, to prevent this you can use left joins instead. I've added a report below that mimics the Assets tab and shows all Mac, Windows and Linux assets. If this report is selecting too many fields, you can deselect the ones you do not want in the report builder (Edit Report).

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.Domain,
  Case tsysAssetTypes.AssetTypename When 'Windows' Then tsysOS.OSname
    When 'Linux' Then tblLinuxSystem.OSRelease
    When 'Apple Mac' Then tblMacOSInfo.KernelVersion Else '' End As OS,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssets.Mac As [MAC Address],
  tblADComputers.OU,
  tblState.Statename,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.Description,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssets.FQDN,
  tblAssetCustom.DNSName,
  tblAssetCustom.LastPatched,
  tblAssetCustom.LastFullbackup,
  tblAssetCustom.LastFullimage,
  tblAssetCustom.Location,
  tblAssetCustom.Building,
  tblAssetCustom.Department,
  tblAssetCustom.Branchoffice,
  tblAssetCustom.BarCode,
  tblAssetCustom.Contact,
  tblAssetCustom.Serialnumber,
  tblAssetCustom.OrderNumber,
  tblAssetCustom.Custom1,
  tblAssetCustom.Custom2,
  tblAssetCustom.Custom3,
  tblAssetCustom.Custom4,
  tblAssetCustom.Custom5,
  tblAssetCustom.Custom6,
  tblAssetCustom.Custom7,
  tblAssetCustom.Custom8,
  tblAssetCustom.Custom9,
  tblAssetCustom.Custom10,
  tblAssetCustom.Custom11,
  tblAssetCustom.Custom12,
  tblAssetCustom.Custom13,
  tblAssetCustom.Custom14,
  tblAssetCustom.Custom15,
  tblAssetCustom.Custom16,
  tblAssetCustom.Custom17,
  tblAssetCustom.Custom18,
  tblAssetCustom.Custom19,
  tblAssetCustom.Custom20
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Where tsysAssetTypes.AssetTypename In ('Windows', 'Linux', 'Apple Mac')
Order By tblAssets.Domain,
  tblAssets.AssetName