1.0.19/Public/get-AllegisInUseUsername.ps1
function get-AllegisInUseUsername { [cmdletbinding()] param( [Parameter(Mandatory)] [string]$username, [pscredential]$adcred, [string]$adforest, [boolean]$corpAD=$true, [boolean]$ASQL=$false, [string]$sqlserver, [pscredential]$sqlusername, [string]$sqltable, [boolean]$azureAD=$false, [boolean]$snow=$false, [string]$snowEnv, [pscredential]$snowcred, [boolean]$fim=$false, [string]$fimservice, [string]$FIMuri, [PSCredential]$fimcred ) $found=$false if (-not $found -and $corpad){ if ($adcred -eq $null){ $user=get-aduser -filter {samaccountname -eq $username -or mailnickname -eq $username} -server $adforest }else{ $user=get-aduser -filter {samaccountname -eq $username -or mailnickname -eq $username} -server $adforest -Credential $adcred } 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 } } if (-not $found -and $fim) { $user=get-AllegisFIMUser -accountname $username -fimservice $fimservice -FIMuri $FIMuri -fimcred $fimcred if ($user -ne $null){ $found=$true } } return $found } |