Hi, I have a report to show the tickets closed in the last 30 days, i now need to show the agent assigned to the ticket within this report i believe the info i need is in htblticketssummary however every time I add this to the report my report goes f...
I have created a simple report that would show us a simple overview (Agent, Requester, subject, and description of all tickets), opened and closed in the last 24 hours.The report I have so farSelect Top 1000000 htblticket.date As [Date Created], htb...
Looking to generate a report for all computers that are missing a specific service. The name of it is "Remote Access Service".Could someone point me in the right direction? I tried looking at the tblServices but I'm not even sure that's the right tab...
Below is my report. It shows the same data for User as it does Manager and I'm not sure why. Can someone show me what I did wrong?Edit:The idea is to show all the assets from tblAssets, the user of that computer, and the manager of that user. OK, I t...
