Get-SQLServerInfo - Empire Module


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

Module Overview

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

The get_sql_server_info module returns basic server and user information from 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_server_info 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_server_info module:

Agent
Agent to run module on.

Additional Module Options

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

CheckAll
Check all systems retrieved by Get-SQLInstanceDomain.

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_server_info Example Usage

Here's an example of how to use the get_sql_server_info 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/situational_awareness/network/get_sql_server_info

 Author       @_nullbind                                                         
              @0xbadjuju                                                         
 Background   True                                                               
 Comments     https://github.com/NetSPI/PowerUpSQL/blob/master/PowerUpSQL.ps1    
 Description  Returns basic server and user information from target SQL Servers. 
 Language     powershell                                                         
 Name         powershell/situational_awareness/network/get_sql_server_info       
 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.                                 |
|----------------|------------|----------|-------------------------------------|
| 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/situational_awareness/network/get_sql_server_info) > set Agent Y4LHEV83
[*] Set Agent to Y4LHEV83
(Empire: usemodule/powershell/situational_awareness/network/get_sql_server_info) > execute
[*] Tasked Y4LHEV83 to run Task 1
...

Now wait for the results to come.

Authors

References

See Also

Check also the following modules related to this module:

Version

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