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

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
  • 4422 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
  • 2206 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
  • 5015 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
  • 4584 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
  • 4605 Views
  • 3 replies
  • 0 kudos

Resolved! Bitlocker Report not contain all computers

We have introduced Bitlocker in our enterprise and we would like to manage the computer inventory where Bitlocker is installed or not.I observed that a builtin report already exist to show BitLocker machines... But I dont known why this report not li...

Glenn_Gagne by • Engaged Sweeper III
  • 10617 Views
  • 4 replies
  • 0 kudos