Public/get-AllegisInUseUsername.ps1
function get-AllegisInUseUsername { [cmdletbinding()] param( [Parameter(Mandatory)] [string]$username, [boolean]$corpAD=$true, [boolean]$ASQL=$false, [string]$sqlserver, [pscredential]$sqlusername, [string]$sqltable, [boolean]$azureAD=$false, [boolean]$snow=$false, [string]$snowEnv, [pscredential]$snowcred) $found=$false if (-not $found -and $corpad){ $user=get-aduser -filter {samaccountname -eq $username -or mailnickname -eq $username} if ($user -ne $null){ $found=$true } } if (-not $found -and $ASQL) { $params = @{ 'Database' = $sqltable 'ServerInstance' = $sqlserver 'Username' = $sqlUsername.UserName 'Password' = $sqlusername.GetNetworkCredential().Password 'Query' = "select * [dbo].[$sqltable] where mailnickname='$username'" } $user=Invoke-Sqlcmd @params if ($user -ne $null){ $found=$true } } if (-not $found -and $azureAD) { $user=$null if ($user -ne $null){ $found=$true } } if (-not $found -and $snow) { $user=get-AllegisSnowUser -snowenv $snowEnv -snowcred $snowcred -uid $username if ($user -ne $null){ $found=$true } } return $found } |