Pages printed in the last 30 days

[Developer]

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?

[RCorbeil · Accepted solution]

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.