My-PowerShell

EHLO test.com
MAIL FROM: monadresse@gmail.com
RCPT TO: monadresse@yahoo.com
DATA
Hello Christophe.
.
QUIT

$Server = "server30"
$Database = "EVaultStoreArchive1"
$AttachmentPath = ".Export_EVEV_1_Stats.csv"
$SqlQuery = "SELECT [ArchiveName], ArchivedItems, CAST(ArchivedItemsSize AS decimal(20, 0)) AS ArchivedItemsSize From view_ListVaults INNER JOIN [EnterpriseVaultDirectory].[dbo].[ArchiveView] ON view_ListVaults.ArchivePointId = [EnterpriseVaultDirectory].[dbo].[ArchiveView].[VaultEntryId]"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Data Source=$Server;Initial Catalog=$Database;Integrated Security = True"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = $SqlQuery
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$nRecs = $SqlAdapter.Fill($DataSet)
$nRecs | Out-Null
$objTable = $DataSet.Tables[0]
$objTable | Export-CSV $AttachmentPath
Write-Host "Export terminé."
$resfile = New-Item -ItemType file -Path ".Export_EVEV_1_Stats_Result.csv" -Force
Add-Content -Path $resfile -Value "FirstOU,Name,ArchivedItems,ArchivedItemsSize,VaultCache,OrganizationalUnit"
$evnom = "CN=EV_NOMADES,CN=Users,DC=domain,DC=local"
$InputFile = import-csv -Path $AttachmentPath
foreach ($Mailbox in $InputFile)
{
$user = Get-QADUser -Identity $Mailbox.ArchiveName
$user.Name
if ($user.NestedMemberOf -contains $evnom )
{$vaultchache = "True"}
Else
{$vaultchache = $null}
$FirstOU = $User.ParentContainer -split("/")
$FirstOU = $FirstOU[1]
Add-Content -Path $resfile -Value "$($FirstOU),$($Mailbox.ArchiveName),$($Mailbox.ArchivedItems),$($Mailbox.ArchivedItemsSize),$($vaultchache),$($user.ParentContainer)"

$Svc = Get-WmiObject -Computer SRV001 win32_service  -Filter "name='MSExchangeRepl'"
$Result = $Svc.StopService()
$Result.ReturnValue

$Svc = Get-WmiObject -Computer SRV001 win32_service  -Filter "name='MSExchangeRepl'"
$Result = $Svc.StartService()
$Result.ReturnValue

$SqlServer = "SRV00026"
$SqlCatalog = "BESMgmt"
$SqlQuery = "select userconfig.DisplayName,userconfig.MailboxSMTPAddr FROM UserConfig"
 
 
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server = $SqlServer; Database = $SqlCatalog; Integrated Security = True"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = $SqlQuery
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$SqlConnection.Close()
$DataSet.Tables[0]

$mbserver = Get-MailboxServer
Foreach ($server in $mbserver) {
	"___________"
	""
	$server.name
	"___________"
	""
	"System                   Volume                             FreeSpace (GB)             PourcentFree"
	"------                   ------                             --------------             ------------"
 
	Get-WmiObject win32_volume -ComputerName $server.name | Sort-Object -Property Name |
	Format-Table -HideTableHeaders 	@{e={$_.systemname};n="" },
					@{e={$_.name};n="" },
					@{ e={[math]::round($_.FreeSpace/1GB,2)};n="" },
					@{ e={[math]::round(($_.FreeSpace*100)/$_.Capacity) };n="" }
	}

#	Liste des comptes sans héritage et replace l'heritage si l'utilisateur n'est pas dans le groupe "no_quota".
 
Get-Mailbox -ResultSize Unlimited |
Where-Object { $_.UseDatabaseQuotaDefaults -eq $false } |
	ForEach-Object {
		$User = get-qaduser -samaccountname $_.Alias
		if ($User.memberof -match "no_quota")
		{}
		else
			{
			$User.samaccountname
			Set-Mailbox $User.samaccountname -UseDatabaseQuotaDefaults $true
			}
	}
#	Recherche des groupes "no_quota" et enlève l'héritage si l'utilisateur est dans ce groupe.
 
Get-Group -Identity no_quota |
	ForEach-Object {
		$groupdn=("LDAP://"+$_.DistinguishedName)
		$group = ([ADSI]$groupdn)
 
		ForEach ($member in $group.member){
			Set-Mailbox -Identity $member -IssueWarningQuota Unlimited -ProhibitSendQuota Unlimited -ProhibitSendReceiveQuota Unlimited -UseDatabaseQuotaDefaults $false
		}
	}

$InputFile = import-csv -Path ".\recipientssi.csv"
$i=0
$password = ConvertTo-SecureString "P@ssW0rd" -AsPlainText -Force
$ou = "domain.local/OU01_Compta"
foreach ($NewMailbox in $InputFile)
{
	$upn = $NewMailbox.alias + "@domain.local"
	New-Mailbox -Alias $NewMailbox.Alias -Name $NewMailbox.DisplayName -FirstName $NewMailbox.FirstName -LastName $NewMailbox.LastName -UserPrincipalName $upn -Password $password -OrganizationalUnit $ou -Database EXCHSRV001\DB001
	$i=$i+1
  	if ($InputFile.Count -ge 0)
    {
    	Write-Progress -activity " *  * Creating Mailboxes" -Status $upn -percentcomplete ($i/$InputFile.Count*100) 
    }
}

Import-Csv -Path .\users_compta.csv | foreach { Add-DistributionGroupMember -Identity Groupe_Compta -Member $_.identity }