Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

rt-shredder-4(8) [debian man page]

rt-shredder(8)						     Request Tracker Reference						    rt-shredder(8)

NAME
rt-shredder - Script which wipes out tickets from RT DB SYNOPSIS
rt-shredder --plugin list rt-shredder --plugin help-Tickets rt-shredder --plugin 'Tickets=query,Queue="general" and Status="deleted"' rt-shredder --sqldump unshred.sql --plugin ... rt-shredder --force --plugin ... DESCRIPTION
rt-shredder - is script that allow you to wipe out objects from RT DB. This script uses API that RT::Shredder module adds to RT. Script can be used as example of usage of the shredder API. USAGE
You can use several options to control which objects script should wipeout. OPTIONS
--sqldump <filename> Outputs INSERT queries into file. This dump can be used to restore data after wiping out. By default creates files <RT_home>/var/data/RT-Shredder/<ISO_date>-XXXX.sql --object (DEPRECATED) Option has been deprecated, use plugin "Objects" instead. --plugin '<plugin name>[=<arg>,<val>[;<arg>,<val>]...]' You can use plugins to select RT objects with various conditions. See also --plugin list and --plugin help options. --plugin list Output list of the available plugins. --plugin help-<plugin name> Outputs help for specified plugin. --force Script doesn't ask any questions. SEE ALSO
RT::Shredder perl v5.14.2 2013-05-22 rt-shredder(8)

Check Out this Related Man Page

Jifty::Plugin::RequestInspector(3pm)			User Contributed Perl Documentation		      Jifty::Plugin::RequestInspector(3pm)

NAME
Jifty::Plugin::RequestInspector - Inspect requests DESCRIPTION
Do not use this plugin directly. Other plugins use this plugin. METHODS
init Sets up hooks into the request cycle. before_request Hooks into the request cycle to forward "request is beginning" and more metadata to RequestInspector plugins. after_request Hooks into the request cycle to forward "request is done" and more metadata to RequestInspector plugins. clear_requests Clears the list of request inspections. add_request Adds the current request inspection to the data store. last_id Returns the most recent request ID. get_plugin_data RequestID, Plugin::Name Returns the opaque plugin data for a particular request ID and plugin class name. get_all_plugin_data Plugin::Name Returns the opaque plugin data for all requests, for a given plugin class name. get_request RequestID Returns all data for a particular request ID. requests Returns a list of all inspections for all requests. inspector_plugins Returns a list of plugin instances that hook into RequestInspector. new_request_inspection Instantiates a new request inspection, setting up some default values. should_handle_request CGI Decides whether the request described by the CGI parameter should be handled, based on plugin configuration. version This plugin is versioned because it provides model classes. perl v5.14.2 2010-12-08 Jifty::Plugin::RequestInspector(3pm)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sql in shell script

Hey I have this shell script that I am trying to run and receive a value from a sql query.Then later use the value in an if stmt... I cannot get this to work for nothing.. Here is the script (sqlplus -s $usrname/$passwrd <<! set head off feed off pagesize 0 select b from table; set head... (9 Replies)
Discussion started by: devaris22
9 Replies

2. Shell Programming and Scripting

problem

I wrote a unix scrip which calls sql script. the problem is the query runs well in toad but doesnt work in unix script. anyone could help? query as follows: select sum(case when error_text like 'SystemError:Operation Time Out (Server Side)%' then 1 else 0 END) as count from a ... (39 Replies)
Discussion started by: YoYo
39 Replies

3. Shell Programming and Scripting

can nested SQl be run in Unix Script?

can nested SQl be run in Unix Script? I tried some and found only simply sql(one select) can work well in unix script. (21 Replies)
Discussion started by: YoYo
21 Replies

4. Shell Programming and Scripting

Executing Sql Query Using Shell Script

HI ALL i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job. (14 Replies)
Discussion started by: ragha81
14 Replies

5. Shell Programming and Scripting

Using a variable in sqlplus

Hello, I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. Currently, the script will stop at a cursor where I can then manually enter the SQL statment. This is... (11 Replies)
Discussion started by: MadHatter
11 Replies

6. UNIX for Dummies Questions & Answers

Guys..Script help

What would be the easiest way to write a script that for example I can run in a directory and: 1. look for files either 110 bytes or 150 bytes and 2. has *testing* in the file name If both conditions are met I simply remove them. I know this may sound easy for most but I really need to... (13 Replies)
Discussion started by: NycUnxer
13 Replies

7. UNIX for Dummies Questions & Answers

Script portability

Hello, May I the right place if I need competencies to migrate DOS script into Unix platforme? Thanks in advance Thierry (9 Replies)
Discussion started by: tsconetti
9 Replies

8. Shell Programming and Scripting

need help in reading a output of a sql query in unix script

i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated. my sql query provide output some thing like this - col1 col2 count ---- ---- ------ A B 10 c D 6 e... (8 Replies)
Discussion started by: pharos467
8 Replies

9. Shell Programming and Scripting

sed string manipulation in shell script

Hello, I have 1000 of sql queries and i need to push column value in query. e.g. SET INSERT_ID=1 INSERT INTO test (id,name) VALUES ('a'); SET INSERT_ID=2 INSERT INTO test (id,name) VALUES ('b'); SET INSERT_ID=3 INSERT INTO test (id,name) VALUES ('c'); SET INSERT_ID=4 INSERT INTO test... (12 Replies)
Discussion started by: mirfan
12 Replies

10. UNIX for Advanced & Expert Users

Script which will run every 10minutes and Send SMS to mobile

Hello Genuis guys, I am running Aix5 and Oracle 9 on it. I have sql query which only count a particular rows. I need to prepare a script which will run that sql query every 10 minutes and if the ouput count is greate than 20. It will send SMS to mobile numbers. Need your kind help to... (8 Replies)
Discussion started by: thepurple
8 Replies

11. UNIX for Dummies Questions & Answers

Script to change file name

Hi, I need to write a script that changes the name of the filename. Let's say my script is named change_filename and I want to use it on a file named test1.txt. After running the script I want the filename renamed to test1_fails.txt e.g. $ ls test1.txt test2.txt test3.txt $ ... (15 Replies)
Discussion started by: millsy5
15 Replies

12. Shell Programming and Scripting

Executing set of sql queries from shell script

Hi All, I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below sqlplus user/pwd@dbname << EOF > output.log $(<inputfile.txt) EOF The above code is capturing the output of queries into... (9 Replies)
Discussion started by: loggedin.ksh
9 Replies

13. Shell Programming and Scripting

Passing variable from file to sql from script

Hi Friend, I have one file in which some number are mentioned and number of lines are vary every time And i need to pass that number to my sql command from script. Suppose i have file acc.txt 45456546456 45464564565 67854353454 67657612132 Number of records are vary every time.... (20 Replies)
Discussion started by: pallvi_mahajan
20 Replies

14. What is on Your Mind?

Chess Players: Which Online Resources (and Software) Do You Use and Why?

Hi Chess Players, Which Online Resources (and Software) Do You Use and Why? As for me, I use chessgames.com and chessbase.com; but currently I'm using chessgames.com the most; I like exploring openings in the chessgames.com opening explorer. For analysis on the desktop (Mac) or iPhone I... (8 Replies)
Discussion started by: Neo
8 Replies

15. UNIX for Dummies Questions & Answers

Emailing results of a pl sql procedure from UNIX shell script

Hello All, I am writing the below unix script to email the result of a small pl sql procedure: #!/bin/bash ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME SQLPLUS=$ORACLE_HOME/bin/sqlplus sqlplus -s user/pass@Db_instance<<EOF set echo off set feedback off set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies