Vulnerability & Exploit Database

Back to search

Microsoft SQL Server Find and Sample Data

This script will search through all of the non-default databases on the SQL Server for columns that match the keywords defined in the TSQL KEYWORDS option. If column names are found that match the defined keywords and data is present in the associated tables, the script will select a sample of the records from each of the affected tables. The sample size is determined by the SAMPLE_SIZE option, and results output in a CSV format.

Free Metasploit Download

Get your copy of the world's leading penetration testing tool

 Download Now

Module Name

auxiliary/admin/mssql/mssql_findandsampledata

Authors

  • Scott Sutherland <scott.sutherland [at] netspi.com>
  • Robin Wood <robin [at] digininja.org>
  • humble-desser <humble.desser [at] gmail.com>
  • Carlos Perez <carlos_perez [at] darkoperator.com>
  • hdm <x [at] hdm.io>
  • todb <todb [at] metasploit.com>

References

Reliability

Development

Module Options

To display the available options, load the module within the Metasploit console and run the commands 'show options' or 'show advanced':

msf > use auxiliary/admin/mssql/mssql_findandsampledata msf auxiliary(mssql_findandsampledata) > show actions ...actions... msf auxiliary(mssql_findandsampledata) > set ACTION <action-name> msf auxiliary(mssql_findandsampledata) > show options ...show and set options... msf auxiliary(mssql_findandsampledata) > run