rt-validator man page
Takes two (table name, column(s)) pairs. First pair is reference we check and second is destination that must exist. Array reference can be used for multiple columns.
Returns 0 if a record is missing or 1 otherwise.
rt-validator — check and correct validity of records in RT's database
rt-validator --check rt-validator --check --verbose rt-validator --check --verbose --resolve rt-validator --check --verbose --resolve --force
This script checks integrity of records in RT's DB. May delete some invalid records or ressurect accidentally deleted.
mandatory. it's equal to -c
print additional info to STDOUT it's equal to -v
enable resolver that can delete or create some records
resolve without asking questions
only run the Link validation routines, useful if you changed your Organization