search

Search in column names

This module is useful for searching in column names quickly.

• To get column names which contains password like (ex: passwd, password, motdepasse, clave):

./odat.py search -s $SERVER -d $SID -U $USER -P $PASSWORD --pwd-column-names

Columns which do not contain data are not output by default. To see columns which do not contain data, you should use the --show-empty-columns option:

./odat.py search -s $SERVER -d $SID -U $USER -P $PASSWORD --pwd-column-names --show-empty-columns

• You can search patterns in column names manually (--columns option). To search column names which contain the pattern '%PASSWORD%':

./odat.py search -s $SERVER -d $SID -U $USER -P $PASSWORD --columns '%password%'

• To search column names which contain password like patterns:

./odat.py search -s $SERVER -d $SID -U $USER -P $PASSWORD --columns '%password%'