Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Resolved! Page Count report split by Color and B&W?

I've been asked to use Lansweeper to create a monthly report showing how many B&W prints and how many color prints are being done for each copier in our business.  Lansweeper shows page counts, but I don't see any way to differentiate between b&w and...

Resolved! Find computers with duplicate Office entries on tblSerialNumber

Hi all,Due to some mishap (still being investigated) during a Microsoft Office upgrade, we ended up with several machines with duplicate Office entries on the Software->License Keys table, we have the old version entry and the new version there, for ...

fjca by Champion Sweeper II
  • 3 replies
  • 0 kudos

Resolved! Users that logon locally

Is it possible to generate a report of computers and/or users that are logging in locally instead of the domain?I recently found that some of the computers have local computer accounts on them and I suspect that some of the users might be logging on ...

ejensen by Engaged Sweeper III
  • 5 replies
  • 0 kudos

Filtering of Reports in the Web Interface

What sort of inputs are allowed in the filter at the top of a report? I know I can enter various text and it filters that column based on that, but does it accept wildcards or anything else? I haven't been successful at finding something, if it does.

HammettMike by Engaged Sweeper III
  • 5 replies
  • 1 kudos

SQL server version info

The built in shows the edition and sp level like sql express 2012 sp1 in its reports is there a report that returns also the number you would see when you query sql itself like 11.0.6248 since not all Dot releases are service packs?

AZHockeyNut by Champion Sweeper III
  • 3 replies
  • 0 kudos

Can't get like/not like syntax to work in reports

I'm trying to use the following clause in a reportWhere tblAssets.IPAddress Not Like '10.2.%'orWhere tblAssets.IPAddress Like '10.2.%'Every time I do, I save it, run the report, it shows nothing, so I go back in to edit it, and I see that it got chan...

AndrewP by Engaged Sweeper
  • 6 replies
  • 0 kudos