User LastLogon Relation with OU and ComputerAsset OU

[akaspar]

Hi, I was looking for a post about LastLogon User's OU relation with the ADComputers OU, but could find anything. We are looking to gather a report for the (LastUser + LastUser OU) Grouping it + (AssetComputer + ADComputer OU) Grouping it. So the report basically should display the ADLastUser and its OU + ADComputer the user last time connected and its ADComputer OU.

Thank you...

[akaspar]

Built this query, but any other suggestion is welcome'd.

Select Top 1000000 tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tblADusers.Displayname, tblAssets.Username) As Displayname,
  tblAssets.Lastseen,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblADusers.OU,
  tblADComputers.OU As OU1
From tblAssets
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Outer Join tblADusers On tblAssets.Userdomain = tblADusers.Userdomain And
    tblAssets.Username = tblADusers.Username
  Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Order By tblAssets.Lastseen Desc