This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ

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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Sign in/Join

Resolved! PC Age and color formatting

I have a report that I'm using to list devices in a certain Asset Group. I'm wanting to highlight devices that are older than 5 years to help managers visually see what needs budgeted to be replaced.In the report below, I'm using a string I found to ...

mrdisco by • Engaged Sweeper II
  • 6974 Views
  • 6 replies
  • 1 kudos

Query multiple fields for reports

So I'm not a big SQL guy but I'm trying to make my life a little more efficient if possible. I tried reading up a bit on SQL stuff first before coming here.So basically what I'm doing is adding printer cartridges manually into Lansweeper. Inside th...

Persistent old data on switch port

Hi - I'm seeing some old, incorrect data appearing in column Deviceassetname in a report. Is there a way to refresh that? Re-scanning the switch didn't clear it.For example, I had a VOiP phone connected to our core switch a few months ago. It has sin...

jkoelker by • Engaged Sweeper II
  • 5034 Views
  • 4 replies
  • 1 kudos

Report on Assets in a Static Group

I do not speak SQL. I need some help with what should be a pretty simple report to create.I need to take the built in report "All licensed assets in Lansweeper" but filter it to a static asset group I created called Network Devices.NOTE: This static...

chogan201 by • Engaged Sweeper III
  • 4086 Views
  • 2 replies
  • 0 kudos

Excel Macros

Anyone know of this? "Excel Macros Bypass Your Filters and Slip in Malware Payloads"https://blog.knowbe4.com/excel-macros-bypass-your-filters-and-slip-in-malware-payloads?utm_medium=email&_hsmi=88982560&_hsenc=p2ANqtz-_20ShP5yruHljLcxfFQSB_uwWhpOAT73...

pcook by • Engaged Sweeper II
  • 2069 Views
  • 0 replies
  • 0 kudos

Resolved! Count of completed KB installation Report

Hi guys,Am trying to create a report which gives the count of latest KB installed. Here is what I tried.The below code will give the completed count of mentioned KB installed.Select Top 1000000 tsysOS.OSname As OS, Case When tsysOS.OScode Like '1...

jamie21 by • Engaged Sweeper
  • 4606 Views
  • 4 replies
  • 0 kudos

Resolved! local admin users of a specific device

Hi there,Is there a way to create a report that shows all the local admin accounts on one or all win 10 devices?I can get to it manually by clicking on a device name--> Config tab--> User info tab--> Users in GroupsThanksKirk

kdunnett by • Engaged Sweeper II
  • 4163 Views
  • 2 replies
  • 1 kudos

NOT doesn't work as expected

I'm not an SQL expert. I have some reports that are working, but I'd like to exclude certain PC models from them. If I use "NOT LIKE 'modelname'", instead of showing me every PC that matches the rest of the report and isn't that model name, I get eve...

ABECU by • Engaged Sweeper III
  • 4150 Views
  • 3 replies
  • 0 kudos

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now