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: 

Topics in this forum

Sign in/Join

Software Version Compatibility Report (Solved)

Edit: I figured out the code. I decided to go a different way. If the software was compatible I set the background to green, if not I set it to red. Here is a sample of the query: When tblOperatingsystem.Version Like '10.0.18362%' And (tblSof...

All USB devices connected

Hello, I am new to Lansweeper so I apologize in advance if this has already been answered. I need to run a report for ever usb device that is connected to a system on out network. The only exclusion would be mice and keyboards. I could not find how t...

earmor by • Engaged Sweeper
  • 5360 Views
  • 2 replies
  • 0 kudos

Software audit with installation date

I want to make a software audit report with installation date using the default report "Assets: Installed software by computer" as base.The error “All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressio...

Report to find all computers with no logon data

I'm attempting to run a report to find all devices that either have Config > User Info > Last logon as blank/null or that have a logon time older than X days but i keep getting blank results. Would someone be able to assist? Thank you.I've used thi...

mlevar by • Engaged Sweeper
  • 4001 Views
  • 1 replies
  • 1 kudos

Change processes report to show opposite results

I found the below script in the forum:Select Top 1000 tblAssets.AssetName, tblProcesses.CaptionFrom tblAssets Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetIDWhere tblProcesses.Caption = 'OneDrive.exe'https://www.lansweeper.com/f...

William382 by • Engaged Sweeper III
  • 3472 Views
  • 1 replies
  • 0 kudos

Keep link to items when using column names

I searched the forums but could not find a solution. Using the following Select statement will allow me to click on the items in AssetName columnSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName,But if use a Column Name then the link is no ...

TomGalvin by • Engaged Sweeper
  • 3426 Views
  • 0 replies
  • 0 kudos