cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
davidvanders
Engaged Sweeper
I have this reports for my printers infos

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Printerstatus As Status,
tblAssetCustom.Printedpages As [Printed Pages],
tblAssetCustom.Model As [Device model],
tblAssets.Lastseen,
tblAssets.AssetID,
tblAssetCustom.Warrantydate,
tblAssets.IPAddress,
tblAssetCustom.Serialnumber,
tblAssetCustom.Contact,
tblAssets.Mac
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssetCustom.Printedpages Is Not Null And tblAssetCustom.State = 1
Order By tblAssets.AssetName


It returns me 11 printers.

If on the main page of lansweeper i choose the dynamic assets group it returns me 38 printers. Anyone sees the issue?

thanks
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
The only restrictions in that report are that the asset must be active, and the number of printer pages must be scanned. I presume that the ones in your dynamic report have either of these missing. Most likely they do not have a number of printed pages scanned.