→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TonyLC
Engaged Sweeper

I have modified the following report that gives me the information I need

But each printer is listed multiple times in the output

Any help would be appreciated.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model As [Device model],
tblCustDevPrinter.AssetID,
tblAssetCustom.PrintedMonoPages As [Printed Black & White Pages],
tblAssetCustom.PrintedColorPages As [Printed Color Pages],
tblAssetCustom.Printedpages As [Total Printed Pages],
tblAssets.HostTypeId,
tblAssets.IPAddress
From tblCustDevPrinter
Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

1 ACCEPTED SOLUTION
brandon_jones
Champion Sweeper III

Try this instead:

 

Select Distinct tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssetCustom.Model As [Device model],
  tblCustDevPrinter.AssetID,
  tblAssetCustom.PrintedMonoPages As [Printed Black & White Pages],
  tblAssetCustom.PrintedColorPages As [Printed Color Pages],
  tblAssetCustom.Printedpages As [Total Printed Pages],
  tblAssets.HostTypeId,
  tblAssets.IPAddress
From tblCustDevPrinter
  Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

View solution in original post

2 REPLIES 2
TonyLC
Engaged Sweeper

That is perfect

Thank You

brandon_jones
Champion Sweeper III

Try this instead:

 

Select Distinct tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssetCustom.Model As [Device model],
  tblCustDevPrinter.AssetID,
  tblAssetCustom.PrintedMonoPages As [Printed Black & White Pages],
  tblAssetCustom.PrintedColorPages As [Printed Color Pages],
  tblAssetCustom.Printedpages As [Total Printed Pages],
  tblAssets.HostTypeId,
  tblAssets.IPAddress
From tblCustDevPrinter
  Inner Join tblAssets On tblCustDevPrinter.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID