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

Resolved! Scan a asset tag, but not THAT asset tag .

hello I have a "positive" (1) tag and a "negative"(2) tag and the "default" (0) tag.i want a report that shows only assets that are members of the Default tag and only if they are not members of the two others.I have been fumbling around but where I’...

Emort by • Engaged Sweeper
  • 7279 Views
  • 4 replies
  • 0 kudos

Resolved! Laptop Report - LanSweeper 4 to LanSweeper 5

Hey guys,Curious is anyone can lend a hand on getting this laptop report working for Lansweeper 5 (I found it in this forum but it looks like it was made for Lansweeper 4). I'd also like help adding a field to it - Last Logged in User . Ultimately ...

RTedrow by • Engaged Sweeper II
  • 9077 Views
  • 4 replies
  • 0 kudos

Resolved! Customize for monthly report

I'm looking for a custom SQL report that will provide the following information in one easily exported excel:Physical Windows serversVirtual Windows serversTotal servers (Windows)Physical Linux serversVirtual Linux serversTotal servers (Linux)Databas...

kitkkkkk by • Engaged Sweeper
  • 6777 Views
  • 3 replies
  • 0 kudos

Resolved! Software Audit

please help with the following report for v5a big list with all computers and users where software x and software y are installedPcname, username, fullname , software (see below), lastseen 30days, ipadressrequired products:Microsoft Project Professio...

svap by • Engaged Sweeper III
  • 5671 Views
  • 2 replies
  • 0 kudos

Resolved! Show all software for all devices by location

Hello all,I'm trying to make a query for showing all my asset with all softwares installed with IP location in column.In my test, I do not show all my computer and I have a lot of duplicate...Here is my query : Something is wornd ?Select Top 1000000 ...

Kreg by • Engaged Sweeper II
  • 5785 Views
  • 2 replies
  • 0 kudos

Resolved! Modify Built-in report to include Assetname and IPLocation

Hi,I am looking for a report, similar to the built-in Lansweeper v5 report 'Software: All Microsoft software'.It needs to tell me how many computers at each IPLocation have each type of Microsoft Software installed. I'm not too worried about the 'Ver...

Hogester by • Engaged Sweeper
  • 4293 Views
  • 1 replies
  • 0 kudos

Resolved! AssetName clickable

What modifications are needed to make the resuting tblAssets.AssetName a hyperlink, so I can drill down to the resulting device from the report?Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName As [De...

harringg by • Champion Sweeper
  • 4308 Views
  • 1 replies
  • 0 kudos