Notification

Icon
Error

Pages printed in the last 30 days - A report that pulls a count of pages printed via each printer on a network within a month

Posted: Saturday, August 8, 2020 12:56:43 AM(UTC)
Developer

Developer

Member Original PosterPosts: 1
0
Like
This issue has been solved! Click here to view the solution
This is a baseline for what I believe I am attempting to pull. I can pull the total pages ever printed on a printer on our network, using this:

Select Top 1000000 tblAssets.AssetName,
tblAssetCustom.Model As [Device model],
tblAssetCustom.Printerstatus As Status,
tblAssetCustom.PrintedMonoPages As [Printed Black & White Pages],
tblAssetCustom.PrintedColorPages As [Printed Color Pages],
tblAssetCustom.Printedpages As [Total Printed Pages],
tblAssets.Lastseen,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.Printedpages Is Not Null And tblAssetCustom.State = 1
Order By tblAssets.AssetName


However, I was informed of the possible parameter of "tblAssets.Lastseen > getdate() - 30" to only pull the last 30 days of information. However when simply adding that to the scripting it is not capatible. Is what I am referring to even possible in a normal environment?
RC62N
#1RC62N Member Posts: 470  
posted: 8/10/2020 5:18:05 PM(UTC)
Filering for assets last seen within the last 30 days will only produce a list of assets last seen within the last 30 days, it won't filter page count values. All that's recorded is the page count when each printer was last seen. I don't see LANSweeper maintaining historical logs of that information, so I expect that you're going to need to run your report monthly and store the results externally in something like Excel or Access, then use that to compare the values over time.

Active Discussions

Lansweeper Konica Minolta print counters
by  Paolo   Go to last post Go to first unread
Last post: 7/17/2020 10:23:50 AM(UTC)
Lansweeper Custom OID Scan - HP C3000 Blade Enclosure
by  Fille  
Go to last post Go to first unread
Last post: 7/9/2020 11:49:33 AM(UTC)
Lansweeper Mobotix Camera
by  SSE   Go to last post Go to first unread
Last post: 3/23/2020 1:34:11 PM(UTC)
Lansweeper mobile devices (android, ios) not found in scan
by  Luan Costa  
Go to last post Go to first unread
Last post: 2/27/2020 2:42:06 PM(UTC)
Lansweeper Ubiquiti Unifi OID and MIB files
by  cscherrey   Go to last post Go to first unread
Last post: 9/4/2019 10:05:38 PM(UTC)
Lansweeper Cisco Catalyst Switch
by  Esben.D  
Go to last post Go to first unread
Last post: 4/24/2019 10:28:29 AM(UTC)
Lansweeper Palo Alto Firewalls
by  Esben.D   Go to last post Go to first unread
Last post: 4/24/2019 10:22:58 AM(UTC)
Lansweeper Lanier MP Printers
by  Esben.D  
Go to last post Go to first unread
Last post: 1/28/2019 10:06:16 AM(UTC)