For anyone interested, I had also opened a ticket with Lansweeper and they provided me with the following report code. So far it's working just as I had intended.
Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
Case
When tblAssets.UserName Is Not Null And tblAssets.username != '' Then
tblAssets.userdomain + '\' + tblAssets.Username
Else ''
End As hyperlink_name_Lastuser,
Case
When tblAssetUserRelations.Userdomain Is Null Then ''
Else '/user.aspx?username=' + tblAssets.Username + '&userdomain=' +
tblAssets.Userdomain
End As hyperlink_Lastuser,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.KernelVersion)
As OS,
tblAssets.SP,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan],
tblAssets.Lasttried As [Last scan attempt],
tsysAssetRelationTypes.RelationTypeIcon10 As Icon3,
tsysAssetRelationTypes.Name As RelationType,
tblAssetUserRelations.Comments As RelationComments,
tblAssetUserRelations.StartDate As RelationStartDate,
tblAssetUserRelations.EndDate As RelationEndDate,
Case
When tblAssetUserRelations.Userdomain Is Null Then ''
When tblADusers.Displayname Is Null Or
tblADusers.Displayname = '' Then tblAssetUserRelations.Userdomain + '\' +
tblAssetUserRelations.Username
Else tblADusers.Displayname
End As hyperlink_name_RelationUser,
Case
When tblAssetUserRelations.Userdomain Is Null Then ''
Else '/user.aspx?username=' + tblAssetUserRelations.Username +
'&userdomain=' + tblAssetUserRelations.Userdomain
End As hyperlink_RelationUser,
Replace(tblAssetUserRelations.Ou, ',', ', ') As hyperlink_name_Ou,
Case
When tblAssetUserRelations.Ou Is Null Then ''
Else '/Report/report.aspx?det=web50findusersbyOU&title=' +
Replace(tblAssetUserRelations.Ou, '&', '%26') + '&@OU=' +
Replace(tblAssetUserRelations.Ou, '&', '%26')
End As hyperlink_Ou,
tblADGroups.Name As [hyperlink_name_AD Group],
Case
When tblAssetUserRelations.AdObjectId Is Null Then ''
Else '/Report/report.aspx?det=web50usersbyadgroup&title=' + tblADGroups.Name
+ '&@id=' + Cast(tblAssetUserRelations.AdObjectId As nvarchar(10))
End As [hyperlink_AD Group],
Case
When tblAssetUserRelations.EndDate < GetDate() Then '#dddddd'
Else '#ffffff'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetUserRelations On
tblAssets.AssetID = tblAssetUserRelations.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tsysAssetRelationTypes On tblAssetUserRelations.Type =
tsysAssetRelationTypes.RelationTypeID
Left Outer Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Left Outer Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Left Outer Join tblADusers On
tblADusers.Userdomain = tblAssetUserRelations.Userdomain And
tblADusers.Username = tblAssetUserRelations.Username
Left Outer Join tblADGroups On tblADGroups.ADObjectID =
tblAssetUserRelations.AdObjectId
Where tblState.Statename = 'Active' And (Lower(tblADusers.Userdomain) !=
Lower(tblAssets.Userdomain) Or Lower(tblADusers.Username) !=
Lower(tblAssets.Username))
Order By Case
When tblAssetUserRelations.EndDate Is Null Then 1
Else 0
End Desc,
RelationEndDate Desc,
RelationStartDate Desc,
tblAssets.AssetName,
tblAssets.Domain