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! All Assets Report

We are implementing an Asset Management software and I have been asked to pull in a lot of information. Here is my query however I am returning the same machine literally thousands of times, is there a way to only list each machine only once?Select T...

mmeetze by • Engaged Sweeper III
  • 6578 Views
  • 2 replies
  • 1 kudos

Switch Interface Mac Changes Report

We are looking for a report that will show AssetMacAddress changes on switch interface port in the past 24 hours. Similar to the builtin report Switch: Ports but only show Ports that have AssetMacAddress changed in the past 24 hours. Also show previ...

ponyisa by • Engaged Sweeper II
  • 4200 Views
  • 1 replies
  • 0 kudos

list assets manually edited in last 30 days

I'm trying to find a field that would indicate the last time the asset record was manually edited. For instance, if you enter some data into Custom4 and save the record, is there a field that updates with the current date/timesamp at that time? Ideal...

Jeff_Henze by • Engaged Sweeper III
  • 6575 Views
  • 3 replies
  • 0 kudos

Resolved! Report Laptops: Report shows duplicate entries

Hi,my report shows duplicate entries.I figured out that it is because some assets have more than 1 battery installed.How can I edit the report, so that only one entry for each asset is shown?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName,...

MrCount by • Engaged Sweeper III
  • 5102 Views
  • 1 replies
  • 0 kudos

Resolved! Add header to export reports

Hi folks,I am facing the problem, that we have several different reports which still need to be printed out.For that, we export to Excel and then print it.But as the exported report has no title on it, we sometimes swap the reports.So it would be nic...

MrCount by • Engaged Sweeper III
  • 4785 Views
  • 1 replies
  • 0 kudos

Resolved! Existing Report Filtering Options

Hello,I'm looking for a description of what I can filter on at the top of an existing report. Let's say I open a report for an installed program with several versions. At the top of the report I can type a version number and the report filters down...

ngebhar2 by • Engaged Sweeper II
  • 13363 Views
  • 3 replies
  • 3 kudos

Feature not installed report

Hi,Can anyone help? I'm working on a report with criteria:* Is server* Has folder shares* Feature 'FSRM Infrastructure' NOT installedI'm struggling on the feature not installed bit. I think I need something like the example here but I'm new to SQL an...

heybobby1 by • Engaged Sweeper III
  • 4815 Views
  • 1 replies
  • 0 kudos

Resolved! Export Printable Reports

Hello,How can we export the printable reports of the individual assets?Preferably as Directory Alert Typ and PDF greetings

Kilian by • Engaged Sweeper
  • 5713 Views
  • 1 replies
  • 0 kudos