Page History

h2. The inside-RT queries...


h3. Software

&nbsp;Status = 'resolved'&nbsp; AND Resolved < '6/15/2009'&nbsp; AND Resolved > '6/8/2009'&nbsp; AND ( Queue = 'Software::Licensing'&nbsp; OR Queue = 'Software::Licensing::FileMaker'&nbsp; OR Queue = 'Software::Licensing::Mathematica'&nbsp; OR Queue = 'Software::Licensing::RHEL'&nbsp; OR Queue = 'Software::Licensing::Questions'&nbsp; OR Queue = 'Software::Matlab::Billing' ) AND Subject NOT LIKE 'Maple'

h3. Helpdesk

&nbsp;Status = 'resolved'&nbsp; AND Resolved < '6/15/2009'&nbsp; AND Resolved > '6/8/2009'&nbsp; AND ( Queue = 'Help Desk::Call Center'&nbsp; OR Queue = 'Help Desk::HDweb'&nbsp; OR Queue = 'Help Desk::Mobile Devices'&nbsp; OR Queue = 'Help Desk::Presales'&nbsp; OR Queue = 'Help Desk::Service Center'&nbsp; OR Queue = 'Help Desk::UNIX/Linux' ) AND 'CF.
\{Special Tag}' NOT LIKE 'Stellar'

h3. Business

 Status&nbsp;Status = 'resolved' &nbsp; and Resolved < '6/15/2009' &nbsp; and Resolved > '6/8/2009' &nbsp; and Queue = 'Help Desk::Business Help'

h3. Athena

 Status&nbsp;Status = 'resolved' &nbsp; AND Resolved < '6/15/2009' &nbsp; AND Resolved > '6/8/2009' &nbsp; AND ( Queue = 'Help Desk::Athena' )

h3. Stellar

 Status&nbsp;Status = 'resolved' &nbsp; AND Resolved < '6/15/2009' &nbsp; AND Resolved > '6/8/2009' &nbsp; AND Created > '1/1/2009' &nbsp; AND ( 'CF.Help Desk::Call Center.{Special Tag}

' LIKE 'Stellar'&nbsp; OR Queue = 'Edtech::Stellar'&nbsp; OR Queue = 'Help Desk::Stellar' )

h3. Etc

&nbsp;Status = 'resolved'&nbsp; AND Resolved < '6/15/2009'&nbsp; AND Resolved > '6/8/2009'&nbsp; AND Created > '6/8/2008'&nbsp; AND ( Queue = 'TNIS::Trouble Calls'&nbsp; OR Queue = 'TNIS::Inbox'&nbsp; OR Queue = 'TNIS::Installs'&nbsp; OR Queue = 'Network::Requests'&nbsp; OR Queue = 'RCC::BriggsField'&nbsp; OR Queue = 'RCC::EastCampus'&nbsp; OR Queue = 'RCC::MassAve'&nbsp; OR Queue = 'RCC::NorthWest'&nbsp; OR Queue = 'RCC::WestCampus'&nbsp; OR Queue = 'Telecom::Telephone Help'&nbsp; OR Queue = 'Software::Mobile Devices'&nbsp; OR Queue = 'SAIS::SS Support'&nbsp; OR Queue = 'Help Desk::SIP'&nbsp; OR 'CF.
{Problem Type}

' IS NOT 'NULL' )
\\