Asset State Inactive Report

[pfrench1]

Has anyone successfully created a report that includes whether or not an asset is active or inactive?

Thanks in advance.

[RCorbeil · Accepted solution]

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