cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pfrench1
Engaged Sweeper III
Has anyone successfully created a report that includes whether or not an asset is active or inactive?

Thanks in advance.
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
The default query explicitly filters for active (state = 1). If you want to filter for a different state, change that value.

State value definitions are found in tblState.
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblstate.State,
tblstate.Statename
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

View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
The default query explicitly filters for active (state = 1). If you want to filter for a different state, change that value.

State value definitions are found in tblState.
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblstate.State,
tblstate.Statename
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