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 Show attached USB devices
by  Dannnnooo   Go to last post Go to first unread
Last post: Today at 10:42:17 AM(UTC)
Lansweeper Lansweeper Ubiquiti AP Bullet Devices
by  Beta_Tester  
Go to last post Go to first unread
Last post: Today at 8:59:06 AM(UTC)
Lansweeper Report to find ScanServer 'not working'
by  Rocher Vincent   Go to last post Go to first unread
Last post: Today at 8:07:26 AM(UTC)
Lansweeper Security: HSTS Missing
by  Grey  
Go to last post Go to first unread
Last post: Yesterday at 9:36:49 PM(UTC)
Lansweeper Include custom ticket fields as email tags
by  brownscar   Go to last post Go to first unread
Last post: 9/29/2020 4:09:02 PM(UTC)
Lansweeper SSH - Keyboard Interactive Authentication
by  blackmoonwolf  
Go to last post Go to first unread
Last post: 9/29/2020 1:21:59 PM(UTC)
Lansweeper Lansweeper Dark Theme
by  blackmoonwolf   Go to last post Go to first unread
Last post: 9/29/2020 1:18:32 PM(UTC)
Lansweeper Drag and Drop Email
by  Chris Durham  
Go to last post Go to first unread
Last post: 9/29/2020 7:13:09 AM(UTC)