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

Server uptime for all equipment

Hello,I'm trying to create a report where the total uptime for every piece of network equipment is listed. This includes Windows servers, virtual servers, Linux servers, WiFi devices, NAS, firewalls, switches, etc. In other words, everything except t...

dimi3 by Engaged Sweeper
  • 89 Views
  • 0 replies
  • 0 kudos

Virtual Machine report

Hi,I'd like to have the following repport :Guest Computer Name | Guest IP address | Host Computer Name | Host IP addressFor now Ihave Guest Name | Host Computer Name | Host IP addressIn this case the Guest Name is not the computerI don't know with wi...

kaddynet by Engaged Sweeper
  • 5096 Views
  • 2 replies
  • 0 kudos

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
  • 16162 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
  • 2538 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
  • 3159 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
  • 7074 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
  • 8392 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
  • 13798 Views
  • 4 replies
  • 0 kudos