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
We’re currently experiencing a high volume of support requests, which may result in longer response times — Thank you for your patience and understanding.
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

Last Windows Update

There is a chart report Last Windows Update Chart QueryAnd the SQL query is:Select Top 1000000 Case When LastPatchDate.lastPatchDate >= DateAdd(day, -7, GetDate()) Then '1. less than a week' When LastPatchDate.lastPatchDate < DateAdd(day, ...

paultech by • Engaged Sweeper
  • 3705 Views
  • 3 replies
  • 0 kudos

Resolved! Report showing multiple entries for same device

I am making a custom report that works but entries are duplicated multiple times. I have 78 printers and the report displays the printers IP location, Manufacturer, Model, SerialNumber, AssetName, Location (Custom Field 01), and the IPAddress.I have...

jatinder by • Engaged Sweeper
  • 4678 Views
  • 2 replies
  • 0 kudos

Need help with the "AD manager" field

I have an uptime report that I want to run on the regular, but the current user field is populated by the last logged on user, rather than the "AD manager" field in AD. I need to be able to pull the AD manager in order to get a clean enough report t...

Resolved! Add filter to local admin report

I have a report unauthorized local admins on pc's. I'm looking to also filter out ((User X on PC Y) and (user W on PC Q)) from the report. I can't seem to make it work though.Current report:Select Top 1000000 tblAssets.AssetName, tblUsersInGroup.A...

jdmhw6 by • Engaged Sweeper II
  • 4526 Views
  • 3 replies
  • 0 kudos

Resolved! Report without Antivirus especific

I need to create a report of all computers that do not have the "Bitdefender Endpoint ..." antivirus installed. Windows defender needs to be ignored from the report.

diogo by • Engaged Sweeper
  • 3424 Views
  • 1 replies
  • 0 kudos

Software report, return one result from a group

Hi.I am fairly terrible at SQL, I am trying to relearn it after years away from it. So hopefully someone could help me, I would be very grateful.What I am trying to do is search a specific group of assets by assetname and return an entry for each ass...

Display Microsoft Edge versions

Hi, is there a way to display the different versions of the Microsoft Edge browsers for our computers? We would like to find out which of our users have the older "Classic" version of Microsoft Edge and the newer, Chromium-based version of Microsoft ...

chenegh by • Engaged Sweeper II
  • 4623 Views
  • 1 replies
  • 1 kudos