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.

cancel
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...

Switch & Port reports - SNMPInfo tables missing info

Hi,So I used the report found here as base...And found out there are *some* assets, that are missing from the report,more specifically information is missing in the tblSNMPAssetMac and tblSNMPInfo tables.Yet when you go to the asset's page in the we...

Maxlieb by Engaged Sweeper
  • 1723 Views
  • 0 replies
  • 0 kudos

Resolved! Webcam report, the wrong way

And then when I view it, I have to sort the view by manufacturer, type in Logitech and get all the Logitech webcams in there. Have I gone round this a long convoluted way, or is this the best?Is there a way for me to just have the Logitech sorted on ...

Tholmes by Engaged Sweeper III
  • 5123 Views
  • 3 replies
  • 0 kudos

Resolved! zerologin posted report

the report, as posted to your page shows assets that are marked with status other than active...such as destroyed, in-active etc. when one has a lot of assets in the report these should likely get filtered out so the active ones get priority in patch...

AZHockeyNut by Champion Sweeper III
  • 8073 Views
  • 5 replies
  • 0 kudos

Need help finishing a report for Failed Logons

The report I have works great (I got it from here)!! However, I would like it to show only findings with "Unknown user name or bad password." as the reason.Any help is VERY much appreciated!-JasonSelect Top 1000000 tblAssets.AssetID, tblAssets.Asse...

Russian in Report

Hi! How to use Russian in reports?For example:Select Top 1000000 tblADusers.Userdomain + '\' + tblADusers.Username As Displayname, tblADusers.Username, tblADusers.Userdomain, tblADusers.Name, 'usersm.png' As icon, tblADusers.IsEnabled As Enable...

Resolved! Asset location report with count ?

I am currently adding in floor maps to our lansweeper db and I was wondering if a computer count can be added to a report like this?Select Top 1000000 tblAssets1.AssetID, tblAssets1.AssetName, tblAssets1.DescriptionFrom tblAssets Inner Join tsysAs...

stahly8 by Engaged Sweeper III
  • 7218 Views
  • 2 replies
  • 0 kudos

Inventory for all Connected Headphone

Hi there, can anyone help me to create a custom report for all connected Headphones to all assets. I need to make a list of headphones we use around the offices to identify their make and model. Thanks Pritpal