# Give permissions to user doing the export

New-ManagementRoleAssignment –Role "Mailbox Import Export" –User Admin

# Create Network Share and give permissions to Exchange Trusted Subsystem read/write

# Start the Mailbox Export

New-MailboxExportRequest -Mailbox first.surname -FilePath \\comp\share

# Start mailbox export with archive

New-MailboxExportRequest -Mailbox first.surname -FilePath \\comp\share -IsArchive

# Check the status of mailbox export request

Get-MailboxExportRequest 

or

Get-MailboxExportRequest | Get-MailboxExportRequestStatistics

# When Mailbox export request has been finished. Remove it

Get-MailboxExportRequest | Where {$_.status -eq "Completed"} | Remove-MailboxExportRequest

-Eric

• Install the 64-bit version of the Microsoft Online Services Sign-In Assistant – LINK
• Install the 64-bit version of the Windows Azure Active Directory Module for Windows PoweShell – LINK

PowerShell commands

# Import MSOnline Module

Import-Module MSOnline

# Connect to Office 365

$O365Cred = Get-Credential
Connect-MsolService -Credential $O365Cred

# Show Licenses

Get-MsolAccountSku

# View details about the Services that are available in all of your license plans

Get-MsolAccountSku | Select -ExpandProperty ServiceStatus

# Check which users have licenses

Get-MsolUser -All | fl DisplayName, UsageLocation,isLicensed,Licenses

# Check if a user has a license – Single

Get-MsolUser -UserPrincipalName "user.name@domain.com" | ft DisplayName, UsageLocation,isLicensed,Licenses

# Add a license – Single user

Set-MsolUserLicense -UserPrincipalName "user.name@domain.com" -AddLicenses "company:ENTERPRISEPACK"

# Remove a license – Single user

Set-MsolUserLicense -UserPrincipalName "user.name@domain.com" –RemoveLicenses "company:ENTERPRISEPACK"

# Bulk Add licenses

$Users = Import-Csv -Path "C:\Temp\licenses.csv"
foreach ($User in $Users)
{
    $UPN = $User.‘SamAccountName’ + "@zhgplc.com"
    Set-MsolUser -UserPrincipalName "$UPN" -UsageLocation "GB"
    Set-MsolUserLicense -UserPrincipalName "$UPN" -AddLicenses "company:ENTERPRISEPACK"
}

# Bulk check added licenses 

$Users = Import-Csv -Path "C:\Temp\licenses.csv"
foreach ($User in $Users)
{
    $UPN = $User.‘SamAccountName’ + "@zhgplc.com"
    Get-MsolUser -UserPrincipalName "$UPN" | ft DisplayName, UsageLocation, Licenses
}

-Eric

When the SQL Server Instance starts in single-user mode,  you can use the Windows Administrator account to connect to SQL Server using the sqlcmd utility and Windows authentication.

Connect to SQL Server using sqlcmd: sqlcmd –S.\SQLExpress

The following example adds the account “John” in the “EXAMPLE” domain to the SQL Server “sysadmin” role:

EXEC sp_addsrvrolemember ‘EXAMPLE\John, ‘sysadmin’;
GO

Note! Once the sysadmin access has been recovered, remove the “;-mSQLCMD” from the startup parameters using the Configuration Manager and restart the SQL Server Instance

-Eric

Go to Manage > System > Advanced Settings and locate Syslog.global.logHost and edit settings.

Add the following: udp://SERVER.domain.com:514

Step 2 – Configure Firewall rules to allow access to external syslog server.

Go to Host > Networking > Firewall Rules and locate syslog and edit settings:

Select Only allow connections from the following networks and enter the external syslog server.

-Eric