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

Report to show all tickets that aren't assigned?

I'm trying to find a report that will show me a list of all tickets that have been opened but not "picked up" yet. Any suggestions? I've tried this with no luck:Select Top 1000000 htblticket.ticketid As [Ticket Number], htblticket.date As [Date Op...

pryan67 by • Champion Sweeper II
  • 5601 Views
  • 3 replies
  • 0 kudos

Resolved! Uptime report ordering

But at the moment, it goes down the list for 1,12,13,14,2,20,23,24,3,30,34 etcWe wold like it to be sequential, like 1,2,3,10,12,14,19,20,21etc, I hope that makes senseHere is my code.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAss...

Tholmes by • Engaged Sweeper III
  • 3818 Views
  • 2 replies
  • 0 kudos

ALL Inventory - Dockin Station connected - Report

Anyone, know how to write the report script?Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblBaseBoard.Manufacturer As MBManufacturer, tblUSBController.*From tblAssets Inner Join tblBaseBoard On tblAssets.AssetID = tblBaseBo...

Problem filtering out Software from report

Hi,See below code. Why am I still getting Veeam Backup for Office 365 in my report?Thank you!Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblSoftwareUni.softwareName As software, tblSoftware.softwareVersion As vers...

Johnny by • Engaged Sweeper II
  • 2575 Views
  • 1 replies
  • 0 kudos

Resolved! Include File Scanning Within another report

I have a piece of software that doesn't appear in the add remove programs in Windows. I have set up a file scan for this software and I have a report for it, but I have written a report that show the software on computers that is out of date and I w...