Get-SQLColumnSampleData - Empire Module

This page contains detailed information about how to use the powershell/collection/get_sql_column_sample_data Empire module. For list of all Empire modules, visit the Empire Module Library.

Module Overview

---

Name: Get-SQLColumnSampleData
Module: powershell/collection/get_sql_column_sample_data
Source code [1]: empire/server/modules/powershell/collection/get_sql_column_sample_data.yaml
Source code [2]: empire/server/modules/powershell/collection/get_sql_column_sample_data.py
MITRE ATT&CK: T1046
Language: PowerShell
Needs admin: No
OPSEC safe: Yes
Background: Yes

The get_sql_column_sample_data module returns column information from target SQL Servers. Supports search by keywords, sampling data, and validating credit card numbers.

This module runs in a foreground and is OPSEC unsafe as it writes on the disk and therefore could be detected by AV/EDR running on the target system.

Note that the get_sql_column_sample_data module does not need administrative privileges to work properly which means that a normal user can run this module.

Required Module Options

---

This is a list of options that are required by the get_sql_column_sample_data module:

Agent
Agent to run module on.

Additional Module Options

---

This is a list of additional options that are supported by the get_sql_column_sample_data module:

CheckAll
Check all systems retrieved by Get-SQLInstanceDomain.

Instance
SQL Server instance to connection to.

NoDefaults
Don't select tables from default databases.

OutputFunction
PowerShell's output function to use ("Out-String", "ConvertTo-Json", "ConvertTo-Csv", "ConvertTo-Html", "ConvertTo-Xml").
Default value: Out-String.
Suggested values: Out-String, ConvertTo-Json, ConvertTo-Csv, ConvertTo-Html, ConvertTo-Xml.

Password
SQL Server or domain account password to authenticate with.

Username
SQL Server or domain account to authenticate with.

Get_sql_column_sample_data Example Usage

---

Here's an example of how to use the get_sql_column_sample_data module in the Empire client console:

[+] New agent Y4LHEV83 checked in
[*] Sending agent (stage 2) to Y4LHEV83 at 192.168.204.135
(empire usestager/windows/ducky) > usemodule powershell/collection/get_sql_column_sample_data

 Author       @_nullbind                                                             
              @0xbadjuju                                                             
 Background   True                                                                   
 Comments     https://github.com/NetSPI/PowerUpSQL/blob/master/PowerUpSQL.ps1        
 Description  Returns column information from target SQL Servers. Supports search by 
              keywords, sampling data, and validating credit card numbers.           
 Language     powershell                                                             
 Name         powershell/collection/get_sql_column_sample_data                       
 NeedsAdmin   False                                                                  
 OpsecSafe    True                                                                   
 Techniques   http://attack.mitre.org/techniques/T1046                               


,Record Options--,------------,----------,-------------------------------------,
| Name           | Value      | Required | Description                         |
|----------------|------------|----------|-------------------------------------|
| Agent          |            | True     | Agent to run module on.             |
|----------------|------------|----------|-------------------------------------|
| CheckAll       |            | False    | Check all systems retrieved by Get- |
|                |            |          | SQLInstanceDomain.                  |
|----------------|------------|----------|-------------------------------------|
| Instance       |            | False    | SQL Server instance to connection   |
|                |            |          | to.                                 |
|----------------|------------|----------|-------------------------------------|
| NoDefaults     |            | False    | Don't select tables from default    |
|                |            |          | databases.                          |
|----------------|------------|----------|-------------------------------------|
| OutputFunction | Out-String | False    | PowerShell's output function to use |
|                |            |          | ("Out-String", "ConvertTo-Json",    |
|                |            |          | "ConvertTo-Csv", "ConvertTo-Html",  |
|                |            |          | "ConvertTo-Xml").                   |
|----------------|------------|----------|-------------------------------------|
| Password       |            | False    | SQL Server or domain account        |
|                |            |          | password to authenticate with.      |
|----------------|------------|----------|-------------------------------------|
| Username       |            | False    | SQL Server or domain account to     |
|                |            |          | authenticate with.                  |
'----------------'------------'----------'-------------------------------------'

(Empire: usemodule/powershell/collection/get_sql_column_sample_data) > set Agent Y4LHEV83
[*] Set Agent to Y4LHEV83
(Empire: usemodule/powershell/collection/get_sql_column_sample_data) > execute
[*] Tasked Y4LHEV83 to run Task 1
...

Now wait for the results to come.

Authors

---

• @_nullbind
• @0xbadjuju

References

---

• https://github.com/BC-SECURITY/Empire/tree/master/empire/server/modules/powershell/collection/get_sql_column_sample_data.yaml
• https://github.com/BC-SECURITY/Empire/tree/master/empire/server/modules/powershell/collection/get_sql_column_sample_data.py
• https://github.com/NetSPI/PowerUpSQL/blob/master/PowerUpSQL.ps1
• http://attack.mitre.org/techniques/T1046

See Also

---

Check also the following modules related to this module:

• powershell/collection/get_sql_query
• powershell/collection/get_indexed_item
• powershell/collection/SharpLoginPrompt
• powershell/collection/file_finder
• powershell/collection/ninjacopy
• powershell/collection/clipboard_monitor
• powershell/collection/FoxDump
• powershell/collection/prompt
• powershell/collection/minidump
• powershell/collection/netripper
• powershell/collection/SauronEye
• powershell/collection/toasted
• powershell/collection/screenshot
• powershell/collection/find_interesting_file
• powershell/collection/inveigh
• powershell/collection/browser_data
• powershell/collection/WireTap
• powershell/collection/WebcamRecorder
• powershell/collection/ChromeDump
• powershell/collection/USBKeylogger
• powershell/collection/keylogger
• powershell/collection/get-winupdates
• powershell/collection/packet_capture
• powershell/collection/SharpChromium
• powershell/collection/vaults/remove_keepass_config_trigger
• powershell/collection/vaults/add_keepass_config_trigger
• powershell/collection/vaults/keethief
• powershell/collection/vaults/find_keepass_config
• powershell/collection/vaults/get_keepass_config_trigger
• powershell/lateral_movement/invoke_sqloscmd
• powershell/recon/get_sql_server_login_default_pw
• powershell/situational_awareness/network/get_sql_server_info
• powershell/situational_awareness/network/get_sql_instance_domain
• powershell/exploitation/invoke_spoolsample

Version

---

This page has been created based on Empire version 4.1.3 (BC Security Fork).
Visit Empire Module Library for more modules.