→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now