CountTickets - Revision history

Phanousk at 14:41, 6 February 2019

2019-02-06T14:41:39Z

← Older revision		Revision as of 10:41, 6 February 2019
Line 1:		Line 1:
	This script, written in BASH, will query for how many tickets there are in the DB for either all status (configurable inside the script) or a supplied argument naming a queue.		This script, written in BASH, will query for how many tickets there are in the DB for either all status (configurable inside the script) or a supplied argument naming a queue.

	<source lang="bash">#!/bin/bash		<source lang="bash"><pre>
			#!/bin/bash

	Statuses=( new open stalled resolved rejected deleted )		Statuses=( new open stalled resolved rejected deleted )
Line 14:		Line 15:
	done		done

	</source>		</pre></source>

	I echo the time after each entry in case it takes a while for each query to finish - for use in timing ticket count changes (perhaps while watching [[RTx]]-Shredder at work).		I echo the time after each entry in case it takes a while for each query to finish - for use in timing ticket count changes (perhaps while watching [[RTx]]-Shredder at work).

	This is especially handy for 'deleted' tickets. Those aren't searchable via the RT interface.		This is especially handy for 'deleted' tickets. Those aren't searchable via the RT interface.

Phanousk at 14:23, 6 February 2019

2019-02-06T14:23:46Z

← Older revision		Revision as of 10:23, 6 February 2019
Line 1:		Line 1:
	This script, written in BASH, will query for how many tickets there are in the DB for either all status (configurable inside the script) or a supplied argument naming a queue.		This script, written in BASH, will query for how many tickets there are in the DB for either all status (configurable inside the script) or a supplied argument naming a queue.

	<~~nowiki~~>#!/bin/bash		<source lang="bash">#!/bin/bash

	Statuses=( new open stalled resolved rejected deleted )		Statuses=( new open stalled resolved rejected deleted )
Line 14:		Line 14:
	done		done

	</~~nowiki~~>		</source>

	I echo the time after each entry in case it takes a while for each query to finish - for use in timing ticket count changes (perhaps while watching [[RTx]]-Shredder at work).		I echo the time after each entry in case it takes a while for each query to finish - for use in timing ticket count changes (perhaps while watching [[RTx]]-Shredder at work).

	This is especially handy for 'deleted' tickets. Those aren't searchable via the RT interface.		This is especially handy for 'deleted' tickets. Those aren't searchable via the RT interface.

Admin: 2 revisions imported

2016-04-06T20:03:34Z

2 revisions imported

New page

This script, written in BASH, will query for how many tickets there are in the DB for either all status (configurable inside the script) or a supplied argument naming a queue.

<nowiki>#!/bin/bash

Statuses=( new open stalled resolved rejected deleted )
if [ $1 ] ; then Statuses=( $* ) ; fi

for Status in ${Statuses[@]} ; do
echo -en "$Status:\t"
if [ ${#Status} -lt 7 ] ; then echo -en "\t" ; fi
count=`echo "select count(*) from Tickets where Tickets.Status=\"$Status\";" | mysql rt3`
count=`echo $count | awk '{print $2}'`
echo -e "$count\t`date -d '7 hours ago' '+%D %T'`"
done

</nowiki>

I echo the time after each entry in case it takes a while for each query to finish - for use in timing ticket count changes (perhaps while watching [[RTx]]-Shredder at work).

This is especially handy for 'deleted' tickets. Those aren't searchable via the RT interface.