List Owners of Windows and Linux assets

[SHib11]

LanSweeper/SQL Newbie
I found this great script, by user Susan A., which lists gets me about 90% of the way. This gets me all Windows Servers. I'm hoping for some help which will get me both Windows and Linux assets.

Sorry if this is posted already elsewhere.

Any help would be greatly appreciated.

Select Top 1000000 tblADusers.Company,
  tblAssets.AssetName,
  tblState.Statename,
  tblAssets.Username,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tsysAssetTypes.AssetTypename,
  tblAssets.SP,
  tblAssets.Domain,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  TsysChassisTypes.ChassisName,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblADComputers.AssetID,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblOperatingsystem.InstallDate,
  tblOperatingsystem.PlusProductID,
  SubQuery.Name As Relation,
  SubQuery.Username As RelatedUser,
  SubQuery.Userdomain As RelatedUserdomain,
  SubQuery.Comments As RelationComments,
  SubQuery.StartDate As RelationStartdate
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblSystemEnclosure
    On tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
    TsysChassisTypes.Chassistype
  Inner Join tsysIPLocations
    On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
    tsysIPLocations.EndIP
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
  Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Join (Select Top 1000000 tblAssetUserRelations.AssetID,
    tsysAssetRelationTypes.Name,
    tblAssetUserRelations.Username,
    tblAssetUserRelations.Userdomain,
    tblAssetUserRelations.Comments,
    tblAssetUserRelations.StartDate
  From tblAssetUserRelations
    Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
      tblAssetUserRelations.Type
  Where tsysAssetRelationTypes.Name = 'owned by') SubQuery On SubQuery.AssetID =
    tblAssets.AssetID
Where tblState.Statename Like 'Active' And tblAssets.Lastseen > GetDate() - 90
Order By tblADusers.Company,
  tblState.Statename,
  tsysIPLocations.IPLocation