New Warranty report which includes Device Location

[steven_reid]

Hi,

I am trying to create a report that shows assets that are out of warranty by a set time.  I have modified a previous report that I found to include the Asset Location

The Asset location is set here for each asset

Sometimes there is an asset which doesnt have a location allocated, and this asset is excluded from the report

How can I change the report to have that show up on the report?  I have tried a Right Join but it is still not showing. 

Select Top (1000000) tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets1.AssetName As LocationName,
tblAssetCustom.Department,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate As [Purchase Date],
tblAssetCustom.Warrantydate As [Warranty Expiration],
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypename As Type,
tsysAssetTypes.AssetType As TypeID,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.LsAgentVersion,
tblAssets.LastLsAgent,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan],
tblAssets1.AssetID As LocationID
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetRelations On tblAssetRelations.ChildAssetID =
tblAssets.AssetID
Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
tblAssetRelations.Type
Right Outer Join tblAssets As tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ParentAssetID
Right Outer Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Where tblAssetCustom.Warrantydate < '2024-08-01' And tblAssetCustom.State = 1
And tblAssets.Assettype Not In (288, 66, 208)
Order By [Warranty Expiration] Desc

Do I need to handle nulls?

[steven_reid]

Thank you for responding.  I hadn't heard anything so was trying a different avenue.

To confirm, you are referring to here? Because I cannot see anything in there.

[David_GF]

Hi @steven_reid , it seems you have already open a ticket with our Support engineers for help with this report. They will follow up in your ticket and, once solved, we will share the query here too so other forum users can benefit of the solution.