Get-SQLQuery - Empire Module
This page contains detailed information about how to use the powershell/collection/get_sql_query Empire module. For list of all Empire modules, visit the Empire Module Library.
Module Overview
Name: Get-SQLQuery
Module: powershell/collection/get_sql_query
Source code [1]: empire/server/modules/powershell/collection/get_sql_query.yaml
Source code [2]: empire/server/data/module_source/collection/Get-SQLQuery.ps1
MITRE ATT&CK:
T1046
Language: PowerShell
Needs admin: No
OPSEC safe: Yes
Background: Yes
The get_sql_query module executes a query on target SQL servers.
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_query 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_query module:
Agent
Agent to run module on.
Query
Query to be executed on the SQL Server.
Additional Module Options
This is a list of additional options that are supported by the get_sql_query module:
Instance
SQL Server instance to connection to.
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_query Example Usage
Here's an example of how to use the get_sql_query 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_query
Author @_nullbind
@0xbadjuju
Background True
Comments https://github.com/NetSPI/PowerUpSQL/blob/master/PowerUpSQL.ps1
Description Executes a query on target SQL servers.
Language powershell
Name powershell/collection/get_sql_query
NeedsAdmin False
OpsecSafe True
Techniques http://attack.mitre.org/techniques/T1046
,Record Options--,------------,----------,-------------------------------------,
| Name | Value | Required | Description |
|----------------|------------|----------|-------------------------------------|
| Agent | | True | Agent to run module on. |
|----------------|------------|----------|-------------------------------------|
| Instance | | False | SQL Server instance to connection |
| | | | to. |
|----------------|------------|----------|-------------------------------------|
| 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. |
|----------------|------------|----------|-------------------------------------|
| Query | | True | Query to be executed on the SQL |
| | | | Server. |
|----------------|------------|----------|-------------------------------------|
| Username | | False | SQL Server or domain account to |
| | | | authenticate with. |
'----------------'------------'----------'-------------------------------------'
(Empire: usemodule/powershell/collection/get_sql_query) > set Agent Y4LHEV83
[*] Set Agent to Y4LHEV83
(Empire: usemodule/powershell/collection/get_sql_query) > set Query value
[*] Set Query to value
(Empire: usemodule/powershell/collection/get_sql_query) > execute
[*] Tasked Y4LHEV83 to run Task 1
...
Now wait for the results to come.
Authors
References
- https://github.com/BC-SECURITY/Empire/tree/master/empire/server/modules/powershell/collection/get_sql_query.yaml
- https://github.com/BC-SECURITY/Empire/tree/master/empire/server/data/module_source/collection/Get-SQLQuery.ps1
- 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_indexed_item
- powershell/collection/get_sql_column_sample_data
- 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
Version
This page has been created based on Empire version 4.1.3 (BC Security Fork).
Visit Empire Module Library for more modules.