...
- the register of names needs to use only the latest date if there are multiple lines; how to do that? try a pivot table that filters the maximum value only, and do the inquiry against that.
- have the spreadsheet understand which survey invitation string to use; make a long set of upload commands that work from a single directory and not subdirectories...
- receive the survey transactions into a spreadsheet and divide it up by queue and autogeneate the reports across muliple worksheets. Simpler is better. (Process of letting go)
...
The using-Brio query...
Based on the inside-RT queiries documented below, a reasonable Brio query for RT tickets to survey would include these queues:
Software::Licensing,
Software::Licensing::Filemaker
Software::Licensing::Mathematica
Software::Licensing::RHEL
Software::Licensing::Questions
Software::Matlab::Billing
what to do about Subject NOT LIKE "Maple" ?
Help Desk::Athena
Help Desk::Business Help
Help Desk::Call Center
Help Desk::HDweb
Help Desk::Mobile Devices
Help Desk::Presales
Help Desk::Service Center
Help Desk::UNIX/Linux
(what do about about filtering out Special Tag = Stellar, except to do them anyway in a generic survey form.)
Help Desk::Stellar
EdTech::Stellar
TNIS::Trouble Calls
TNIS::Inbox
TNIS::Installs
Network::Requests
RCC::BriggsField
RCC::EastCampus
RCC::MassAve
RCC::NorthWest
RCC::WestCampus
Telecom::Telephone Help
Software::Mobile Devices
SAIS::SS Support
Help Desk::SIP
and what to about ' OR 'CF.{Problem Type} ' IS NOT 'NULL' ) from the Telephone Help thing? Maybe fuggedaboudit.
...
The inside-RT queries...
These queries are how the queues are queried now. The fields returned are Tickt Number, Requestor, Created date. Some queues also do Queue, and all of them should...
...