
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2018 09:02 PM
I have this reports for my printers infos
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
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
Labels:
- Labels:
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-23-2018 05:25 PM
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.
