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

How do we find the Report view in the database?

I grabbed a WSUS report that was posted here, nice report. To turn it to a chart I made a new report that needs to query that existing report. the control seems to save them as DB views, web50rep..... some ID value I am guessing. when I try to query ...

AZHockeyNut by • Champion Sweeper III
  • 5941 Views
  • 2 replies
  • 0 kudos

Resolved! Software Report With Different Applications

Hello I am trying to show a report of two different applications: Shortel, Inc. and Microsoft Office 2007. What statement would best show the two? Here is what I have so far:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblADComputers....

Windows 10 OSCode

HiI need extra build info for Windows 10 OSI have made a new report with OS 10 listed with build numbers, but I'm missing the last xxx digits Ex. 10.0.14393.xxxIs it possible to get that?

Klaus_Munk by • Engaged Sweeper
  • 15538 Views
  • 6 replies
  • 0 kudos

Resolved! Specific User PC Department Report

Hi there,I'm quite new to writing up SQL queries and am having some difficulty producing particular reports. Hoping someone can help!In this report, I'm using the last seen user and their respective department listed in AD.I'd like to expand on the f...

Drexilla by • Engaged Sweeper II
  • 6579 Views
  • 1 replies
  • 0 kudos

Sub Reports or report off a report

A report called Report1 for example, say it lists all servers under warranty, can you then run a sub report off it to show only the Dell servers for example? Any similar report will do, I am really after how can I run a sub report or query the result...

AZHockeyNut by • Champion Sweeper III
  • 8647 Views
  • 6 replies
  • 0 kudos

Resolved! USB device report

Looking through past questions and answers, it appears that with Version 6, Lansweeper can now scan USB devices? The data appears to be there on the assets, but not sure how to report it out. How could I report for all USB devices plugged into all c...

TekTok by • Engaged Sweeper II
  • 10439 Views
  • 2 replies
  • 0 kudos

Resolved! Basic Inventory Report needs help

I have a basic inventory report that somehow is ignoring non-Windows devices. I would like it to show all devices (like the built-in location inventory reports), and simply ignore missing columns.Here is my report. Thanks in advance for any assista...

davidc by • Engaged Sweeper
  • 5775 Views
  • 2 replies
  • 0 kudos

Resolved! Windows Server Service startname report

I have recently taken over a new environment that is is bad shape. In order to get a handle on service accounts, I want to run a report showing all services on servers and what logon name they are using. I can then sort these and pick out all the on...

Sleezel by • Engaged Sweeper
  • 8661 Views
  • 3 replies
  • 1 kudos