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: 

Topics in this forum

Resolved! Specific User PC Department Report

Hi there,I'm quite new to writing up SQL queries and am having some difficulty producing particular reports. Hoping someone can help!In this report, I'm using the last seen user and their respective department listed in AD.I'd like to expand on the f...

Drexilla by Engaged Sweeper II
  • 7310 Views
  • 1 replies
  • 0 kudos

Sub Reports or report off a report

A report called Report1 for example, say it lists all servers under warranty, can you then run a sub report off it to show only the Dell servers for example? Any similar report will do, I am really after how can I run a sub report or query the result...

AZHockeyNut by Champion Sweeper III
  • 9705 Views
  • 6 replies
  • 0 kudos

Resolved! Basic Inventory Report needs help

I have a basic inventory report that somehow is ignoring non-Windows devices. I would like it to show all devices (like the built-in location inventory reports), and simply ignore missing columns.Here is my report. Thanks in advance for any assista...

davidc by Engaged Sweeper
  • 6434 Views
  • 2 replies
  • 0 kudos

Resolved! Windows Server Service startname report

I have recently taken over a new environment that is is bad shape. In order to get a handle on service accounts, I want to run a report showing all services on servers and what logon name they are using. I can then sort these and pick out all the on...

Sleezel by Engaged Sweeper
  • 9624 Views
  • 3 replies
  • 1 kudos

Resolved! Creating Report for Computers that Start with a Specific Name

I would like to create a report of all computers within a particular department. Our departments' computer name are segmented in order to quickly see which computer belongs to what department, such as the training department computers would be named ...

kerry-ann by Engaged Sweeper II
  • 12596 Views
  • 2 replies
  • 0 kudos

USB Devices Connected to Computers

Hi guys,Is there a report that shows me what USB devices are connected to a computer with the exception of Mice and Keyboards. I want to see USB pens, drives and Mobile Phones that are connected? ThanksDavid

wilkie1984 by Engaged Sweeper II
  • 7827 Views
  • 3 replies
  • 0 kudos

Resolved! How do I get Date From DateTime?

Unable to figure this out. I've tried using the SQL Server Compact documentation, but I can't figure out which one to use and functions like CONVERT(date, <datecolumn) through date = unknown data type.

laurin1 by Engaged Sweeper III
  • 6806 Views
  • 2 replies
  • 0 kudos

Resolved! Report based on Asset Groups

Hi all,i gave the best i can do but now im stuck and i dont get the Report to work HALP! What i want:create a Report for all Assets that looks if the Asset is in more than one Asset Group, if it has 2 or more Asset groups assigned dont show it. So s...

konstapel by Engaged Sweeper
  • 8301 Views
  • 1 replies
  • 0 kudos