private void _SQLQuery(SqlInstances sqlInstances)
{
SQLQuery sQ = new SQLQuery(credentials);
sQ.SetInstance(sqlInstances.ServerInstance);
sQ.Query(query);
}
private void _SQLAgentJob(SqlInstances sqlInstances)
{
SQLAgentJob sAJ = new SQLAgentJob(credentials);
sAJ.SetComputerName(sqlInstances.Server);
sAJ.SetInstance(sqlInstances.ServerInstance);
if (!string.IsNullOrEmpty(subsystemFilter))
{
sAJ.SetSubsystemFilter(subsystemFilter);
}
;
if (!string.IsNullOrEmpty(keywordFilter))
{
sAJ.SetKeywordFilter(keywordFilter);
}
;
if (usingProxyCredentials)
{
sAJ.SetUsingProxyCredFilter();
}
;
if (!string.IsNullOrEmpty(proxyCredentials))
{
sAJ.SetProxyCredentialFilter(proxyCredentials);
}
;
sAJ.Query();
_PrintOutput(sAJ.GetResults());
}
private void _SQLAuditSQLiSpSigned(SqlInstances sqlInstances)
{
SQLAuditSQLiSpSigned sASSS = new SQLAuditSQLiSpSigned(credentials);
sASSS.SetComputerName(sqlInstances.Server);
sASSS.SetInstance(sqlInstances.ServerInstance);
sASSS.Query();
_PrintOutput(sASSS.GetResults());
}
private void _SQLAuditSQLiSpExecuteAs(SqlInstances sqlInstances)
{
SQLAuditSQLiSpExecuteAs sAPX = new SQLAuditSQLiSpExecuteAs(credentials);
sAPX.SetComputerName(sqlInstances.Server);
sAPX.SetInstance(sqlInstances.ServerInstance);
sAPX.Query();
_PrintOutput(sAPX.GetResults());
}
private void _SQLAuditPrivTrustworthy(SqlInstances sqlInstances)
{
SQLAuditPrivTrustworthy sAPT = new SQLAuditPrivTrustworthy(credentials);
sAPT.SetComputerName(sqlInstances.Server);
sAPT.SetInstance(sqlInstances.ServerInstance);
sAPT.Query();
_PrintOutput(sAPT.GetResults());
}
private void _SQLAuditPrivServerLink(SqlInstances sqlInstances)
{
SQLAuditPrivServerLink sAPSL = new SQLAuditPrivServerLink(credentials);
sAPSL.SetComputerName(sqlInstances.Server);
sAPSL.SetInstance(sqlInstances.ServerInstance);
sAPSL.Query();
_PrintOutput(sAPSL.GetResults());
}
private void _SQLAuditPrivImpersonateLogin(SqlInstances sqlInstances)
{
SQLAuditPrivImpersonateLogin sAPDC = new SQLAuditPrivImpersonateLogin(credentials);
sAPDC.SetComputerName(sqlInstances.Server);
sAPDC.SetInstance(sqlInstances.ServerInstance);
sAPDC.Query();
_PrintOutput(sAPDC.GetResults());
}
private void _SQLAuditPrivDbChaining(SqlInstances sqlInstances)
{
SQLAuditPrivDbChaining sAPDC = new SQLAuditPrivDbChaining(credentials);
sAPDC.SetComputerName(sqlInstances.Server);
sAPDC.SetInstance(sqlInstances.ServerInstance);
sAPDC.Query();
_PrintOutput(sAPDC.GetResults());
}
private void _SQLConnection(SqlInstances sqlInstances)
{
using (SQLConnection sql = new SQLConnection(sqlInstances.ServerInstance))
{
sql.BuildConnectionString(credentials);
sql.Connect();
connections.Add(sql.GetConnectionResult());
}
}
private void _SQLOSCmdOle(SqlInstances sqlInstances)
{
SQLOSCmdOle sOCO = new SQLOSCmdOle(credentials);
sOCO.RestoreState();
sOCO.SetComputerName(sqlInstances.Server);
sOCO.SetInstance(sqlInstances.ServerInstance);
sOCO.Query(query);
}
private void _SQLAuditPrivCreateProcedure(SqlInstances sqlInstances)
{
SQLAuditPrivCreateProcedure sAPCP = new SQLAuditPrivCreateProcedure(credentials);
sAPCP.SetComputerName(sqlInstances.Server);
sAPCP.SetInstance(sqlInstances.ServerInstance);
sAPCP.Query();
_PrintOutput(sAPCP.GetResults());
}
private void _SQLServerPasswordHash(SqlInstances sqlInstances)
{
SQLServerPasswordHash sPH = new SQLServerPasswordHash(credentials);
sPH.SetComputerName(sqlInstances.Server);
sPH.SetInstance(sqlInstances.ServerInstance);
sPH.Query();
_PrintOutput(sPH.GetResults());
}
private void _SQLServiceAccount(SqlInstances sqlInstances)
{
SQLServiceAccount sSA = new SQLServiceAccount(credentials);
sSA.SetComputerName(sqlInstances.Server);
sSA.SetInstance(sqlInstances.ServerInstance);
sSA.Query();
_PrintOutput(sSA.GetResults());
}
private void _SQLServerLoginDefaultPw(SqlInstances sqlInstances)
{
SQLServerLoginDefaultPw sSLDP = new SQLServerLoginDefaultPw(credentials);
sSLDP.SetComputerName(sqlInstances.Server);
sSLDP.SetInstance(sqlInstances.ServerInstance);
sSLDP.InjestConfig();
sSLDP.Query();
}
private void _SQLOleDbProvider(SqlInstances sqlInstances)
{
SQLOleDbProvider sODP = new SQLOleDbProvider(credentials);
sODP.SetComputerName(sqlInstances.Server);
sODP.SetInstance(sqlInstances.ServerInstance);
sODP.Query();
_PrintOutput(sODP.GetResults());
}
private void _SQLServerInfo(SqlInstances sqlInstances)
{
SQLServerInfo sSI = new SQLServerInfo(credentials);
sSI.SetComputerName(sqlInstances.Server);
sSI.SetInstance(sqlInstances.ServerInstance);
sSI.Query();
_PrintOutput(sSI.GetResults());
}
private void _SQLOSCmdPython(SqlInstances sqlInstances)
{
SQLOSCmdPython sOCP = new SQLOSCmdPython(credentials);
sOCP.RestoreState();
sOCP.SetComputerName(sqlInstances.Server);
sOCP.SetInstance(sqlInstances.ServerInstance);
sOCP.Query(query);
}
private void _SQLServerConfiguration(SqlInstances sqlInstances)
{
SQLServerConfiguration sSC = new SQLServerConfiguration(credentials);
sSC.SetComputerName(sqlInstances.Server);
sSC.SetInstance(sqlInstances.ServerInstance);
sSC.Query();
_PrintOutput(sSC.GetResults());
}
private void _SQLOSCmdR(SqlInstances sqlInstances)
{
SQLOSCmdR sOCR = new SQLOSCmdR(credentials);
sOCR.RestoreState();
sOCR.SetComputerName(sqlInstances.Server);
sOCR.SetInstance(sqlInstances.ServerInstance);
sOCR.Query(query);
}
private void _SQLUncPathInjection(SqlInstances sqlInstances)
{
SQLUncPathInjection sUPI = new SQLUncPathInjection(credentials);
sUPI.SetComputerName(sqlInstances.Server);
sUPI.SetInstance(sqlInstances.ServerInstance);
sUPI.SetUNCPath(UNCPath);
sUPI.Query();
}
private void _SQLOSCmdAgentJob(SqlInstances sqlInstances)
{
SQLOSCmdAgentJob sOC = new SQLOSCmdAgentJob(credentials);
sOC.SetComputerName(sqlInstances.Server);
sOC.SetInstance(sqlInstances.ServerInstance);
sOC.SetSubSystem("jscript");
sOC.Query(query);
}
private void _SQLAuditRoleDBDDLADMIN(SqlInstances sqlInstances)
{
SQLAuditRole sARD = new SQLAuditRole(credentials);
sARD.SetComputerName(sqlInstances.Server);
sARD.SetInstance(sqlInstances.ServerInstance);
sARD.SetRole("DB_DDLADMIN");
sARD.Query();
_PrintOutput(sARD.GetResults());
}
private void _SQLAuditPrivXpFileExists(SqlInstances sqlInstances)
{
SQLAuditPrivXp sAPX = new SQLAuditPrivXp(credentials);
sAPX.SetComputerName(sqlInstances.Server);
sAPX.SetInstance(sqlInstances.ServerInstance);
sAPX.SetExtendedProcedure("xp_fileexists");
sAPX.Query();
_PrintOutput(sAPX.GetResults());
}
private void _SQLOSCmd(SqlInstances sqlInstances)
{
SQLOSCmd sOC = new SQLOSCmd(credentials);
if (restoreState)
{
sOC.RestoreState();
}
sOC.SetComputerName(sqlInstances.Server);
sOC.SetInstance(sqlInstances.ServerInstance);
sOC.Query(query);
}
private void _SQLSession(SqlInstances sqlInstances)
{
SQLSession sS = new SQLSession(credentials);
sS.SetInstance(sqlInstances.ServerInstance);
if (!string.IsNullOrEmpty(PrincipalNameFilter))
{
sS.SetPrincipalNameFilter(PrincipalNameFilter);
}
sS.Query();
_PrintOutput(sS.GetResults());
}
private void _SQLDatabasePriv(SqlInstances sqlInstances)
{
if (0 == databases.Count)
{
sD = new SQLDatabase(credentials);
sD.SetComputerName(sqlInstances.Server);
sD.SetInstance(sqlInstances.ServerInstance);
if (nodefaults)
{
sD.EnableNoDefaultsFilter();
}
if (hasAccess)
{
sD.EnableHasAccessFilter();
}
if (sysadmin)
{
sD.EnableSysAdminFilter();
}
sD.Query();
databases = sD.GetResults();
}
SQLDatabasePriv sDP = new SQLDatabasePriv(credentials);
sDP.SetComputerName(sqlInstances.Server);
sDP.SetInstance(sqlInstances.ServerInstance);
if (!string.IsNullOrEmpty(PermissionNameFilter))
{
sDP.SetPermissionNameFilter(PermissionNameFilter);
}
;
if (!string.IsNullOrEmpty(PrincipalNameFilter))
{
sDP.SetPrincipalNameFilter(PrincipalNameFilter);
}
;
if (!string.IsNullOrEmpty(PermissionTypeFilter))
{
sDP.SetPermissionTypeFilter(PermissionTypeFilter);
}
;
sDP.SetComputerName(sqlInstances.Server);
sDP.SetInstance(sqlInstances.ServerInstance);
var results = new List <SQLDatabasePriv.DatabasePrivilege>();
foreach (var d in databases)
{
sDP.SetDatabase(d.DatabaseName);
sDP.Query();
results.AddRange(sDP.GetResults());
}
_PrintOutput(results);
}
private void _SQLServerCredential(SqlInstances sqlInstances)
{
SQLServerCredential sSC = new SQLServerCredential(credentials);
sSC.SetComputerName(sqlInstances.Server);
sSC.SetInstance(sqlInstances.ServerInstance);
if (!string.IsNullOrEmpty(CredentialNameFilter))
{
sSC.SetCredentialNameFilter(CredentialNameFilter);
}
sSC.Query();
_PrintOutput(sSC.GetResults());
}
private void _SQLServerRoleMember(SqlInstances sqlInstances)
{
SQLServerRoleMember sSRM = new SQLServerRoleMember(credentials);
sSRM.SetComputerName(sqlInstances.Server);
sSRM.SetInstance(sqlInstances.ServerInstance);
if (!string.IsNullOrEmpty(PrincipalNameFilter))
{
sSRM.SetPrincipalNameFilter(PrincipalNameFilter);
}
sSRM.Query();
_PrintOutput(sSRM.GetResults());
}
private void _SQLServerLink(SqlInstances sqlInstances)
{
SQLServerLink sSL = new SQLServerLink(credentials);
sSL.SetComputerName(sqlInstances.Server);
sSL.SetInstance(sqlInstances.ServerInstance);
if (!string.IsNullOrEmpty(DatabaseLinkName))
{
sSL.SetDatabaseLinkName(DatabaseLinkName);
}
sSL.Query();
_PrintOutput(sSL.GetResults());
}
private void _SQLServerPriv(SqlInstances sqlInstances)
{
SQLServerPriv sSP = new SQLServerPriv(credentials);
sSP.SetComputerName(sqlInstances.Server);
sSP.SetInstance(sqlInstances.ServerInstance);
if (!string.IsNullOrEmpty(PermissionNameFilter))
{
sSP.SetPermissionNameFilter(PermissionNameFilter);
}
sSP.Query();
_PrintOutput(sSP.GetResults());
}
