MSSQL Schema Dump
Description
This module attempts to extract the schema from a MSSQL Server Instance. It will disregard builtin and example DBs such as master, model, msdb, and tempdb. The module will create a note for each DB found, and store a YAML formatted output as loot for easy reading.
Author(s)
- theLightCosine <theLightCosine@metasploit.com>
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/scanner/mssql/mssql_schemadump
msf auxiliary(mssql_schemadump) > show actions
...actions...
msf auxiliary(mssql_schemadump) > set ACTION < action-name >
msf auxiliary(mssql_schemadump) > show options
...show and set options...
msf auxiliary(mssql_schemadump) > run 
- Collect and share all the information you need to conduct a successful and efficient penetration test
- Simulate complex attacks against your systems and users
- Test your defenses to make sure they’re ready
- Automate Every Step of Your Penetration Test
Time is precious, so I don’t want to do something manually that I can automate. Leveraging the Metasploit Framework when automating any task keeps us from having to re-create the wheel as we can use the existing libraries and focus our efforts where it matters.
– Jim O’Gorman | President, Offensive Security