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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)