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

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
  • 3744 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
  • 2836 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
  • 10888 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
  • 4369 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
  • 9643 Views
  • 5 replies
  • 0 kudos

Resolved! Assistance With Colour Coding

Hi Guy's,I have a report based on BIOS hardware age. Wanting to use this to target our laptop replacements.I have the odd colour reports but not sure how to colour this one based on the Years Old column.Basically wanting it green up until 3 years old...