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

Regular expression in query builder

Hi,I want to filter out certain assetnames that have specific structure (first two letters, then 6 numbers). I want to use regex for this, but I can't get it to work. I'm sure my regex works (verified it at https://regexr.com/), but when I use it in ...

Resolved! Report for specific IP range

The short of what I want is to create a disk space report for a specific subnet range. So I want to scan 192.168.0.x and I'm using the following script. The alternative would be to add the names of the servers i want in the report somehow but its cur...

Culejoe by Engaged Sweeper
  • 10318 Views
  • 4 replies
  • 0 kudos

Resolved! Report Help - Only show assets past a certain time

Select Top 1000000 tblassets.AssetID, tblassets.AssetName, tsysassettypes.AssetTypename, tsysassettypes.AssetTypeIcon10 As icon, tblassets.Lastseen, tblassetcustom.LastPatched, tblassets.IPAddress, tblassets.Lasttried, tblassets.UsernameFrom ...

Tythesly by Engaged Sweeper III
  • 4891 Views
  • 6 replies
  • 1 kudos

Resolved! Software Authorization report

Apologies in advance if this has been answered already (I couldn't find anything with a search), and apologies also if it's quite simple, but I couldn't figure it out.I wanted to know if there was a way to generate a report of the Software Authorizat...

sbugler by Engaged Sweeper II
  • 3562 Views
  • 2 replies
  • 0 kudos

Two query real machine and virtual machines

Hi! I tried to make that query and is hard for me. I need two query, one which have every phisical assets and other one who has every virtual machine. We have EXSi servers and Hyper-V too so i tried so hard but is something bigger than a 21 years old...

Firefox 89 & ESR 78.11

Firefox 89 and Firefox ESR 78.11 have just been released. You can find a report to check your update progress here.

Esben_D by Lansweeper Employee
  • 1739 Views
  • 0 replies
  • 0 kudos

Assets WITHOUT A Specific Software Title

I presume the title says it all.I am trying to create a report that shows assets that DON'T have a specific software title included, but ONLY that title. I've gotten close, but my limited knowledge of the SQL language not only yields results of asse...

mhammond by Champion Sweeper
  • 3663 Views
  • 3 replies
  • 0 kudos