Report "Used by" relation ship even when field is empty

[xdubois]

Hi,

I'm trying to add a column in my custom report to display the "used by" relation ship information.

But this information is either not filled in or not necessary on some assets. So I have troubles displaying it.



2 questions:
1- Is it possible to create the relationship "used by" even with empty field with a asset mass edit?
2- Is it possible to display the relationship "used by" even if it is not created?

Here is my custom report in which I would like to add this "used by" information for ALL assets:

Select Top 1000000 tblAssets.AssetName,
tblAssets.AssetID,
tblAssetCustom.CustID,
tsysAssetTypes.AssetTypename As AssetType,
tsysAssetTypes.AssetTypeIcon10 As icon,
Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.SystemVersion)
As OS,
tblAssets.Domain,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssets.Mac As MACAddress,
tblAssets.IPAddress,
tblState.Statename As State,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssetCustom.Location,
tblAssetCustom.Serialnumber,
tblAssetCustom.OrderNumber,
tblAssetCustom.Custom1 As [Property of],
tblAssets.Username
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
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
Order By tblAssets.AssetID

Thanks for your help.

Best regards

Xavier