<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.emailstyle17
{font-family:Arial;
color:navy;}
span.EmailStyle20
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks Michele,</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>So basically there are 5 tables need to be
cleaned up: </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Tickets, TicketCustomFieldValues, Transactions, Attachments,
Links</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>And it should be safe.</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Jesse, I would appreciate it if you could confirm
this.</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Thanks!</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Dimitry</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:windowtext'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Michele Hershey
[mailto:michele.hershey@mhpcc.hpc.mil] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, June 18, 2004 12:54
PM<br>
<b><span style='font-weight:bold'>To:</span></b> Dimitry Faynerman<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [rt-users] URGENT -
delete tickets from DB</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt'>I wrote this and use it<br>
<br>
Check against your version and can be critiqued and modified by anyone that
sees any error/conflict/junk.<br>
<br>
============<br>
<br>
<br>
clear<br>
echo Delete Ticket from RT script<br>
echo<br>
echo<br>
<br>
while true # enclose everything in a main while loop<br>
do<br>
<br>
echo<br>
echo Please specify a ticket id or 0 to exit:<br>
read ticket_id<br>
echo<br>
<br>
if [[ $ticket_id == "0" ]]<br>
then<br>
exit 0<br>
fi<br>
<br>
<br>
#### mysql below<br>
<br>
user=####<br>
<br>
#May uncomment next two lines for Security<br>
#echo Please enter the password<br>
#read pass<br>
<br>
pass=######<br>
db=rt2<br>
<br>
### Run query sub<br>
<br>
run_query()<br>
{<br>
echo "$query" | mysql -u$user -p$pass $db<br>
}<br>
<br>
### Find the Subject & Display<br>
<br>
query="select Subject from Tickets where id = $ticket_id"<br>
subject=`echo "$query" | mysql -u$user -p$pass $db -s`<br>
echo Subject - $subject<br>
<br>
### Accept Action<br>
echo Are you Sure?<br>
echo<br>
echo '( Y/n )'<br>
read reply<br>
<br>
if [[ $reply != "Y" && $reply != "y" ]]<br>
then<br>
exit 0<br>
fi<br>
<br>
### Find the Transaction ID<br>
<br>
query="select id from Transactions where Ticket = $ticket_id"<br>
trans_id=`echo "$query" | mysql -u$user -p$pass $db -s`<br>
echo Trans_id = $trans_id<br>
<br>
### Delete from Attachments<br>
<br>
query="delete from Attachments where TransactionId = $trans_id;"<br>
<br>
run_query<br>
<br>
### Delete from Transactions Table<br>
<br>
query="delete from Transactions where Ticket = $ticket_id;"<br>
<br>
run_query<br>
<br>
<br>
### Delete from Watchers Table<br>
<br>
query="delete from Watchers where Value = $ticket_id;"<br>
<br>
run_query<br>
<br>
<br>
### Delete from ObjectKeywords Table<br>
<br>
query="delete from ObjectKeywords where ObjectId = $ticket_id;"<br>
<br>
run_query<br>
<br>
### Delete from Links Table<br>
<br>
query="delete from Links where LocalBase = $ticket_id;"<br>
<br>
run_query<br>
<br>
### Delete from Links Table<br>
<br>
query="delete from Links where LocalTarget = $ticket_id;"<br>
<br>
run_query<br>
<br>
### Delete from Tickets Table<br>
<br>
query="delete from Tickets where id = $ticket_id;"<br>
<br>
run_query<br>
<br>
done # main while loop<br>
<br>
<br>
Dimitry Faynerman wrote:<br>
<br>
</span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Hello,</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>I know that RT
doesn’t allow to delete anything forever…but I really need to
delete all tickets from the database</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Of course I can manyally
delete them from Tickets table. But that won’t be enough, right?</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Which other tables I will
have to clean up? Can anybody help with that? It’s really urgent.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Thanks,</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Dimitry</span></font></p>
</div>
<p style='margin-left:.5in'><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>------------------------------------------------------------<br>
This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distribution, use or copying of
this e-mail or the information it contains by other than an intended recipient
is unauthorized. If you received this e-mail in error, please advise me (by
return e-mail or otherwise) immediately. <br>
<br>
Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce
pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation
ou copie de ce message ou des renseignements qu'il contient par une personne
autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce
courrier électronique par erreur, veuillez m'en aviser immédiatement, par
retour de courrier électronique ou par un autre moyen.<br>
<br>
============================================================</span></font></p>
<pre style='margin-left:.5in' wrap=""><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:.5in;text-align:center'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'>
<hr size=4 width="90%" align=center>
</span></font></pre><pre style='margin-left:.5in'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:.5in'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>_______________________________________________</span></font></pre><pre
style='margin-left:.5in'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><a
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a></span></font></pre><pre
style='margin-left:.5in'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
.5in'><font size=2 color=black face="Courier New"><span style='font-size:10.0pt'>RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.</span></font></pre><pre
style='margin-left:.5in'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><a
href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a></span></font></pre><pre
style='margin-left:.5in'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
.5in'><font size=2 color=black face="Courier New"><span style='font-size:10.0pt'>Sign up early, as class space is limited. </span></font></pre><pre
style='margin-left:.5in'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre></div>
</body>
</html>