Show all Asset States

[triggert]

Hello,

I have the following report that I want to use to keep track of loaners, spares, etc. The basic info is there but when I change the state it disappears from the report. I want to be able to view all states. Can someone provide some direction?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetGroups.AssetGroup,
tblAssetCustom.Custom1 As [Check Out By],
tblAssetCustom.Custom2 As [Check In By],
tblAssetCustom.Custom3 As [Check Out Date],
tblAssetCustom.Custom4 As [Check In Date]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'Loaners' And tblAssetCustom.State = 1

[Daniel_B]

Most reports and pages on the web console will display only assets in Active state. In reports you can indeed change this by removing the filter

...
tblAssetCustom.State = 1

[triggert · Accepted solution]

At a second look I figured it out. Removed the = 1 from the end of the statement to show all.

tblAssetCustom.State = 1