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

All switches and the assets connected to them

List of switches, some details of the switch and IP, Mask, Mac and Name of the asset connected to them.No criteria.Sorted on:- Assetname name of the switch- If (alias for IfIndex)Select Distinct Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tb...

Bart_M by • Lansweeper Alumni
  • 16799 Views
  • 3 replies
  • 6 kudos

Printer network interfaces

I'm trying to make a report that shows all of the network interfaces for each printer (wired, wireless)and their status. I do see them when I look at a printer asset detail but can't find a way to pull them into a report.

Saraee by • Engaged Sweeper II
  • 2888 Views
  • 1 replies
  • 0 kudos

Max Software Version and Deploy to Only Outdated

I have a simple report that searches for a software name, looks at the version, and the says if it's out of date or not while changing the background color. Below is the code I use for Chrome.What I'd like is:1. I'd like it to use the highest version...

GenDev by • Engaged Sweeper
  • 3670 Views
  • 1 replies
  • 0 kudos

Resolved! Find machines missing any 1 of several apps

Hello, I am trying to put together a report that will output a list of assets missing any 1 of our basic applications. I can make a report for any 1 application, but I'd like to merge reports and possibly report for each entry what that machine is mi...

Windows: Static IP address configured (Built-in)

Old name: Network: Static IP address configured (Built-in)The report below lists all Windows computers having configured a static IP addressThe report will only list assets that meet all of the following criteria:The asset state is set to "active".Th...

Daniel_B by • Lansweeper Alumni
  • 7548 Views
  • 1 replies
  • 0 kudos

Resolved! Adding top user to asset report

I have a report of all of our computers. I would like to add a column that list the user who logs into it the most. I've seen some example reports and queries, but it looks like most of them list all users, and then the primary machine they use, wher...

feffrey by • Engaged Sweeper
  • 9489 Views
  • 5 replies
  • 0 kudos

Resolved! User Last Login (If Any)

Hi, I am trying to run a report based on AD Users and when was the LAST TIME, or if they have ever logged on.I am using this code:Select Top 1000000 tblADusers.Displayname, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Department, tblADus...

kevinoie by • Engaged Sweeper III
  • 14792 Views
  • 4 replies
  • 0 kudos

A Report to find a single file

I was wondering if anyone has already built a report that can simply enough find any asset or server that has one specific file in this case ATMFD.DLL Has someone already created a report like that?

jstrong71 by • Engaged Sweeper II
  • 5201 Views
  • 2 replies
  • 0 kudos