cancel
Showing results forĀ 
ShowĀ Ā onlyĀ  | Search instead forĀ 
Did you mean:Ā 
gcrucitti
Engaged Sweeper II

Hello.

I'm trying to create a report for custom Assets/State type.

I have a Asset Group with 49 Assets but my report is showing only 5/49 assets.

 

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssetCustom.Location,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  tblAssets.Mac,
  tblAssetCustom.Custom1,
  tblAssetCustom.Custom2,
  tblAssetCustom.Custom3,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssetUserRelations.Username,
  tblAssetUserRelations.StartDate,
  tblAssetUserRelations.EndDate,
  tblAssets.Description,
  tblAssetUserRelations.Comments,
  tblState.Statename
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetUserRelations On
      tblAssets.AssetID = tblAssetUserRelations.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
Where tsysAssetTypes.AssetTypename Like 'Tablet'
Order By tblAssets.AssetName

 

 

Any idea?

 

2 REPLIES 2
gcrucitti
Engaged Sweeper II

Didn't work here

brandon_jones
Champion Sweeper III

I removed the  tblAssetUserRelations database and the query worked for me. Before I removed it I was only seeing assets that had a date in the tblAssetUserRelations.StarteDate field. If you want to see the last logged on user use the tblassets.username field.