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

All Users with LastLogon Computer

Help me, please. I can't even figure out how to do a branching report like this. I need a list of all AD Users who have LastLogon Computer There should be fields in the report:Username, JobTitle, LastLogonComputer, CPU, AssetLocation, Custom10, Custo...

dukedizel by Engaged Sweeper II
  • 2126 Views
  • 0 replies
  • 0 kudos

Total by Asset State

I have the following query that I'd like to run in a report, click a selected statename and have it generate another detailed report with all assets that match that state.SELECT ts.Statename, ts.State, count(ta.AssetID) AS TotalFROM tblAssets AS ...

compuag by Engaged Sweeper
  • 3390 Views
  • 1 replies
  • 0 kudos

Computers with Anti-virus out of date

Hello, I am wondering if I can modify the built in report for anti-virus expired. I have several computers with 2, and even one or two with 3. Antivirus programs installed. But more often than not one of them is disabled and out of date. I am really ...

ddanks by Engaged Sweeper
  • 2589 Views
  • 0 replies
  • 1 kudos

Custom Reports Email Question

I know there have been questions on changing the email body text from the default below but most of the questions were from a few years ago. Is there a way to change the text of the email is there something in the SQL that can be changed or the Progr...

Customized Printer Toner Report

I am working on a custom report, modified from the built-in "low toner" report. I am working on trying generate the report based on 30% toner remaining or less. However, one part really bothers me .... in the "RemainingPercentage" column, not only ...

mhammond by Champion Sweeper
  • 9493 Views
  • 7 replies
  • 0 kudos

Resolved! Pages printed in the last 30 days

This is a baseline for what I believe I am attempting to pull. I can pull the total pages ever printed on a printer on our network, using this:Select Top 1000000 tblAssets.AssetName, tblAssetCustom.Model As [Device model], tblAssetCustom.Printerst...

Developer by Engaged Sweeper
  • 3860 Views
  • 1 replies
  • 0 kudos

Software List by Computer/Server Name

Hello,What is the best way to export a list of all software installed on a machine basis? IE everything installed on machine A and everything installed on machine B? Within the Software screen I see that you can drill down into lists of all machine...

mmullen by Engaged Sweeper
  • 8538 Views
  • 5 replies
  • 0 kudos