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: 

Topics in this forum

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
  • 12871 Views
  • 5 replies
  • 1 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
  • 21544 Views
  • 6 replies
  • 0 kudos

Resolved! One field that shows VM or Hyper-V host

Hey everyone,I'm not an expert in SQL, but so far, I haven't run into anything in Lansweeper that I can't handle. Except for this. I'm trying to create a single report which shows something like this:Assetname OS PlatformServer1 ...

DLorien by Engaged Sweeper
  • 8143 Views
  • 2 replies
  • 0 kudos

Shorten Active Directory user and computer OUs

The report below lists your Windows domain computers, their Active Directory OU, their last logged on user and their last logged on user's OU. The OUs are shortened, e.g. from "OU=Servers,DC=lansweeper,DC=local" to "Servers".The report will only list...

Susan_A by Lansweeper Alumni
  • 14599 Views
  • 2 replies
  • 4 kudos