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

Action Open Teams/SfB Chat with user
by  marceman   Go to last post Go to first unread
Last post: 9/10/2020 4:10:18 PM(UTC)
Lansweeper Report showing app even after it has gone
by  TimHolmes1973  
Go to last post Go to first unread
Last post: 9/9/2020 11:50:17 PM(UTC)
Action Remote Device Manager
by  steveb   Go to last post Go to first unread
Last post: 9/4/2020 9:52:01 PM(UTC)
Action View Windows Defender detections remotely
by  steveb  
Go to last post Go to first unread
Last post: 9/4/2020 9:37:48 PM(UTC)
Action Remote Uninstaller
by  steveb   Go to last post Go to first unread
Last post: 9/4/2020 9:27:17 PM(UTC)
Lansweeper Filter Assets' groups by WinSystemLocale
by  Alex Beaumier  
Go to last post Go to first unread
Last post: 8/20/2020 4:17:17 PM(UTC)
Action Chrome History
by  csys   Go to last post Go to first unread
Last post: 8/14/2020 2:14:21 PM(UTC)
Action Offer remote assistance
by  FixitDave  
Go to last post Go to first unread
Last post: 8/4/2020 9:57:51 AM(UTC)