Good Morning. I created a custom report to track our computer refresh by using a custom field for replacement year. This works great for us but an issue that we have run into is that the report pulls last user and not the asset relation to a user. I have tried to add asset relations to the report, but if there is not a asset relation it doesn't show up on the report. Wondering if anyone could assist in generating a report similar to the one below with asset relation to user included but if one doesn't exist it still reports the device. Here is the report that I have that I need to modify:
Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Custom2 As [Refresh Year],
tblState.Statename,
tblADusers.Displayname As [Issued To],
tblADusers.Department As Department,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.IPAddress,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblAssetUserRelations On
tblAssets.AssetID = tblAssetUserRelations.AssetID
Inner Join tblADusers On tblAssetUserRelations.Username = tblADusers.Username
Where (tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename =
'Windows' And tblAssetUserRelations.EndDate Is Null) Or
(tblState.Statename = 'Non Active')
Order By [Refresh Year],
tblAssets.AssetName
