Reporting Email & Web Interface Tickets

nickmorrisonrrp

We are trying to find out how many tickets are being created via web interface.

We are moving away from specific Request Types and using generic types for efficiency. This will cause reporting to be less specific.

Any ideas?

Thanks in advance.

kellytice

I was trying to see if there was an obvious field in the database but i haven't found one. 

So, i don't have a good answer on how to find this out for historical tickets, but with little bit of work you could set something up to track current/future ones (even if you only leave this in place temporarily).

In a nutshell, you could create 2 different Action Rules that check the tickets when they are created and automatically does one of the following things:

• Writes a Note into the ticket (that only Techs can see) with some text like "ThisIsAPortalTicket" or "ThisIsAnEmailTicket" according to the type of ticket it actually is
• Sets a custom field (that only Techs can see) a particular way

In that type of setup my first Action Rule would look like this:

• First tab (Action Rule Info)
  • Give it a name
  • Set Rule Triggering to "only when updated by a Client" and "only at Ticket Creation"

• Second tab (Criteria)
  • Set "Last Update Trigger" to "E-Mail From a Client"

• Third tab (Actions)
  • Click "Modify Ticket" and click "edit" to enter a dialog where i could add a Note to the ticket automatically. 
    I'd want to make the text i use for the note unique (so it is easily searchable) and I'd want to uncheck the "Visible to Client" box.

Alternatively, on this Actions tab I could choose to do something other than adding a Note, like choosing a particular value in a Custom Field.

Since the steps above only cover the email tickets, I would repeat the steps above to add a 2nd Action Rule.  

The main differences there is that the second tab would have a rule for Latest Update Trigger = Client Interface

and the third tab's Action would be putting in a slightly different (but still easily identifiable) bit of Text into a Note or setting a slightly different option on the Custom field.

This is what it would look like:

As you might surmise, having 'extra' notes or custom fields in my tickets might be somewhat annoying if you had to have it long term, but it would be pretty to leave something like this in place for a short amount of time.  It would make it easy to search on all tickets in that time range that have a Note with "ThisIsAnEmailTicket" or "ThisIsAPortalTicket" to get a count.