Office 365 | Alex Ø. T. Hansen

Alex Ø. T. Hansen

12/12/2018

Exam AZ-102: Microsoft Azure Administrator Certification Transition

Recently passed the 70-533 exam and earned a MCSE. Now I’m studying for the transition exam AZ-102 (expiring March 31, 2019), which would give me the Azure Administrator Associate badge. In this post I will give a short description on which methods I used to pass AZ-102.

The resources I used were:

Sharon Bennett’s LinkedIn course (30 days free trial)
Saw the videos on the Microsoft Learn portal
Tested my self through the official practice tests on mindhub
Used the official Azure documentation.
Hands-on labs in a Azure subscription (30 days free trial).

The exam is broken into 8 sections:

1. Manage Azure Subscriptions and Resources (5-10%)
  - May include but not limited to: Configure diagnostic settings on resources; create baseline for resources; create and rest alerts; analyze alerts across subscription; analyze metrics across subscription; create action groups; monitor for unused resources; monitor spend; report on spend; utilize Log Search query functions; view alerts in Log Analytics
2. Implement and Manage Storage (5-10%)
  - May include but not limited to: Create Azure file share; create Azure File Sync service; create Azure sync group; troubleshoot Azure File Sync
3. Configure and manage virtual networks (15-20%)
  - May include but not limited to: Create and configure VNET peering; create and configure VNET to VNET; verify virtual network connectivity; create virtual network gateway
  - May include but not limited to: Configure Azure DNS; configure custom DNS settings; configure DNS zones
4. Manage identities (15-20%)
  - May include but not limited to: Add custom domains; configure Azure AD Identity Protection, Azure AD Join, and Enterprise State Roaming; configure self-service password reset; implement conditional access policies; manage multiple directories; perform an access review
  - May include but not limited to: Install and configure Azure AD Connect; configure federation and single sign-on; manage Azure AD Connect; manage password sync and writeback
5. Evaluate and perform server migration to Azure (15-20%)
  - May include but not limited to: Discover and assess environment; identify workloads that can and cannot be deployed; identify ports to open; identify changes to network; identify if target environment is supported; setup domain accounts and credentials
  - May include but not limited to: Migrate by using Azure Site Recovery (ASR); migrate using P2V; configure storage; create a backup vault; prepare source and target environments; backup and restore data; deploy Azure Site Recovery (ASR) agent; prepare virtual network
6. Implement and manage application services (5-10%)
  - May include but not limited to: Create and manage objects; manage a Logic App resource; manage Azure Function app settings; manage Event Grid; manage Service Bus
7. Implement advanced virtual networking (5-10%)
  - May include but not limited to: Monitor on-premises connectivity; use network resource monitoring and Network Watcher; manage external networking and virtual network connectivity
8. Secure identities (5-10%)
  - May include but not limited to: Enable MFA for an Azure tenant; configure user accounts for MFA; configure fraud alerts; configure bypass options; configure trusted IPs; configure verification methods; manage role-based access control (RBAC); implement RBAC policies; assign RBAC Roles; create a custom role; configure access to Azure resources by assigning roles; configure management access to Azure

If you can answer (and know the reason behind the answer) the following questions regarding Azure, you should be ready to take the AZ-102 exam. For each question I will provide a link to the answer. There might be more than one correct answer to a question, but the questions link points to which tool or technology you should know about in order to pass.

Alex Ø. T. Hansen

04/12/2018

PowerShell – Get all SharePoint pages in a site collection

If you need to get all pages (.aspx) within a site collection, I have created a small script. The script enumerates through a site collection (sub-sites included) and retrieves all .aspx pages.
Before executing the script there are some requirements:

You need to be administrator on the site collection.
Install the PnP PowerShell module for SharePoint (the script was tested with SharePoint Online).

There are 3 variables you need to modify on line 32 (site collection URL), 33 (SharePoint root URL), 34 (username) and 35 (password).
The script will generate a report (when finished) on the desktop of the user running the script containing the URL, author and last modified date of the page.

#requires -version 3
<#
.SYNOPSIS
  .

.DESCRIPTION
  .

.NOTES
  Version:        1.0
  Author:         Alex Ø. T. Hansen (ath@tofte-it.dk)
  Creation Date:  03-12-2018
  Purpose/Change: Initial script development
#>

#region begin boostrap
############### Bootstrap - Start ###############

#Clear the screen.
Clear-Host;

#Import module.
Import-Module SharePointPnPPowerShellOnline;

############### Bootstrap - End ###############
#endregion

#region begin input
############### Input - Start ###############

#SharePoint Online.
$SPOServiceUrl = "https://contoso.sharepoint.com/sites/somesite";
$SPOServiceRootUrl = "https://contoso.sharepoint.com";
$SPOServiceUsername = "myuser@contoso.com";
$SPOServicePassword = "<Password goes here>";

#Files.
$Files = @{
    "Report" = "C:\Users\$($env:USERNAME)\Desktop\Pages.csv";
};

############### Input - End ###############
#endregion

#region begin functions
############### Functions - Start ###############

#Creates a PS credential object.
Function Create-PSCredential
{
    [cmdletbinding()]	
		
    Param
    (
        [Parameter(Mandatory=$true, HelpMessage="Please provide a valid username, example 'Domain\Username'.")]$Username,
        [Parameter(Mandatory=$true, HelpMessage="Please provide a valid password, example 'MyPassw0rd!'.")]$Password
    )
 
    #Convert the password to a secure string.
    $SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force;
 
    #Convert $Username and $SecurePassword to a credential object.
    $Credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $Username,$SecurePassword;
 
    #Return the credential object.
    Return $Credential;
}

#Get all .ASPX pages.
Function Get-SPSitePages
{
    [cmdletbinding()]	
		
    Param
    (
        [Parameter(Mandatory=$true)]$Session,
        [Parameter(Mandatory=$true)]$RootURL,
        [Parameter(Mandatory=$true)][ValidateSet("Yes","No")]$Subsite
    )

    #Object array.
    $Pages = @();

    #Get all lists.
    $Lists = Get-PnPList -Connection $Session;

    #Foreach lists.
    Foreach($List in $Lists)
    {
        #Get all list items.
        $ListItems = Get-PnPListItem -Connection $Session -List $List.Title;

        #If there is any list items.
        If($ListItems)
        {
            #Foreach list item.
            Foreach($ListItem in $ListItems)
            {
                #If the site is a .ASPX site.
                If($ListItem.FieldValues.File_x0020_Type -eq "aspx")
                {
                    #Create new object.
                    $Page = New-Object -TypeName PSObject;

                    #Add data to the object.
                    Add-Member -InputObject $Page -MemberType NoteProperty -Name Url -Value ($RootURL + $ListItem.FieldValues.FileRef);
                    Add-Member -InputObject $Page -MemberType NoteProperty -Name Author -Value ($ListItem.FieldValues.Author.LookupValue);
                    Add-Member -InputObject $Page -MemberType NoteProperty -Name LastModified -Value (($ListItem.FieldValues.Modified).ToString());
                    Add-Member -InputObject $Page -MemberType NoteProperty -Name Subsite -Value ($Subsite);

                    #Add object to array.
                    $Pages += $Page;
                }
            }
        }
    }

    #Return pages.
    Return $Pages;
}

#Write to the console.
Function Write-Console
{
    [cmdletbinding()]	
		
    Param
    (
        [Parameter(Mandatory=$false)][string]$Category,
        [Parameter(Mandatory=$false)][string]$Text
    )
 
    #If the input is empty.
    If([string]::IsNullOrEmpty($Text))
    {
        $Text = " ";
    }
 
    #If category is not present.
    If([string]::IsNullOrEmpty($Category))
    {
        #Write to the console.
        Write-Output("[" + (Get-Date).ToString("dd/MM-yyyy HH:mm:ss") + "]: " + $Text + ".");
    }
    Else
    {
        #Write to the console.
        Write-Output("[" + (Get-Date).ToString("dd/MM-yyyy HH:mm:ss") + "][" + $Category + "]: " + $Text + ".");
    }
}

############### Functions - End ###############
#endregion

#region begin main
############### Main - Start ###############

#Connect to the SharePoint environment.
Write-Console -Text ("Connecting to the SharePoint site '" + $SPOServiceUrl + "'");
$PNPSession = Connect-PNPOnline -Url $SPOServiceUrl -Credentials (Create-PSCredential -Username $SPOServiceUsername -Password $SPOServicePassword) -ReturnConnection;

#Object array.
$Pages = @();

#Get all pages.
Write-Console -Text ("Getting pages (.aspx) from '" + $SPOServiceUrl + "', please wait");
$Pages += Get-SPSitePages -Session $PNPSession -Subsite No -RootURL $RootURL;

#Get all subsites.
$Subsites = Get-PnPSubWebs -Recurse -Connection $PNPSession;

#Foreach subsite.
Foreach($Subsite in $Subsites)
{
    #Connect to the SharePoint subsite.
    Write-Console -Text ("Connecting to the SharePoint subsite '" + $RootURL + $Subsite.ServerRelativeUrl + "'");
    $PNPSessionSubsite = Connect-PNPOnline -Url ($RootURL + $Subsite.ServerRelativeUrl) -Credentials (Create-PSCredential -Username $SPOServiceUsername -Password $SPOServicePassword) -ReturnConnection;

    #Get all pages.
    Write-Console -Text ("Getting pages (.aspx) from '" + ($RootURL + $Subsite.ServerRelativeUrl) + "', please wait");
    $Pages += Get-SPSitePages -Session $PNPSessionSubsite -Subsite Yes -RootURL $RootURL;
}

#Export to the .CSV file.
$Pages | Export-Csv -Path $Files.Report -Encoding UTF8 -Delimiter ";" -NoTypeInformation;

############### Main - End ###############
#endregion

#region begin finalize
############### Finalize - Start ###############

#Disconnect the PowerShell session.
Disconnect-PnPOnline -Connection $PNPSession;
Disconnect-PnPOnline -Connection $PNPSessionSubsite;

############### Finalize - End ###############
#endregion

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

#requires -version 3

.SYNOPSIS

.DESCRIPTION

.NOTES

Version: 1.0

Author: Alex Ø. T. Hansen (ath@tofte-it.dk)

Creation Date: 03-12-2018

Purpose/Change: Initial script development

#region begin boostrap

############### Bootstrap - Start ###############

#Clear the screen.

Clear-Host;

#Import module.

Import-Module SharePointPnPPowerShellOnline;

############### Bootstrap - End ###############

#endregion

#region begin input

############### Input - Start ###############

#SharePoint Online.

$SPOServiceUrl = "https://contoso.sharepoint.com/sites/somesite";

$SPOServiceRootUrl = "https://contoso.sharepoint.com";

$SPOServiceUsername = "myuser@contoso.com";

$SPOServicePassword = "<Password goes here>";

#Files.

$Files = @{

"Report" = "C:\Users\$($env:USERNAME)\Desktop\Pages.csv";

};

############### Input - End ###############

#endregion

#region begin functions

############### Functions - Start ###############

#Creates a PS credential object.

Function Create-PSCredential

{

[cmdletbinding()]

Param

(

[Parameter(Mandatory=$true, HelpMessage="Please provide a valid username, example 'Domain\Username'.")]$Username,

[Parameter(Mandatory=$true, HelpMessage="Please provide a valid password, example 'MyPassw0rd!'.")]$Password

)

#Convert the password to a secure string.

$SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force;

#Convert $Username and $SecurePassword to a credential object.

$Credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $Username,$SecurePassword;

#Return the credential object.

Return $Credential;

}

#Get all .ASPX pages.

Function Get-SPSitePages

{

[cmdletbinding()]

Param

(

[Parameter(Mandatory=$true)]$Session,

[Parameter(Mandatory=$true)]$RootURL,

[Parameter(Mandatory=$true)][ValidateSet("Yes","No")]$Subsite

)

#Object array.

$Pages = @();

#Get all lists.

$Lists = Get-PnPList -Connection $Session;

#Foreach lists.

Foreach($List in $Lists)

{

#Get all list items.

$ListItems = Get-PnPListItem -Connection $Session -List $List.Title;

#If there is any list items.

If($ListItems)

{

#Foreach list item.

Foreach($ListItem in $ListItems)

{

#If the site is a .ASPX site.

If($ListItem.FieldValues.File_x0020_Type -eq "aspx")

{

#Create new object.

$Page = New-Object -TypeName PSObject;

#Add data to the object.

Add-Member -InputObject $Page -MemberType NoteProperty -Name Url -Value ($RootURL + $ListItem.FieldValues.FileRef);

Add-Member -InputObject $Page -MemberType NoteProperty -Name Author -Value ($ListItem.FieldValues.Author.LookupValue);

Add-Member -InputObject $Page -MemberType NoteProperty -Name LastModified -Value (($ListItem.FieldValues.Modified).ToString());

Add-Member -InputObject $Page -MemberType NoteProperty -Name Subsite -Value ($Subsite);

#Add object to array.

$Pages += $Page;

}

#Return pages.

Return $Pages;

}

#Write to the console.

Function Write-Console

{

[cmdletbinding()]

Param

(

[Parameter(Mandatory=$false)][string]$Category,

[Parameter(Mandatory=$false)][string]$Text

)

#If the input is empty.

If([string]::IsNullOrEmpty($Text))

{

$Text = " ";

}

#If category is not present.

If([string]::IsNullOrEmpty($Category))

{

#Write to the console.

Write-Output("[" + (Get-Date).ToString("dd/MM-yyyy HH:mm:ss") + "]: " + $Text + ".");

}

Else

{

#Write to the console.

Write-Output("[" + (Get-Date).ToString("dd/MM-yyyy HH:mm:ss") + "][" + $Category + "]: " + $Text + ".");

}

############### Functions - End ###############

#endregion

#region begin main

############### Main - Start ###############

#Connect to the SharePoint environment.

Write-Console -Text ("Connecting to the SharePoint site '" + $SPOServiceUrl + "'");

$PNPSession = Connect-PNPOnline -Url $SPOServiceUrl -Credentials (Create-PSCredential -Username $SPOServiceUsername -Password $SPOServicePassword) -ReturnConnection;

#Object array.

$Pages = @();

#Get all pages.

Write-Console -Text ("Getting pages (.aspx) from '" + $SPOServiceUrl + "', please wait");

$Pages += Get-SPSitePages -Session $PNPSession -Subsite No -RootURL $RootURL;

#Get all subsites.

$Subsites = Get-PnPSubWebs -Recurse -Connection $PNPSession;

#Foreach subsite.

Foreach($Subsite in $Subsites)

{

#Connect to the SharePoint subsite.

Write-Console -Text ("Connecting to the SharePoint subsite '" + $RootURL + $Subsite.ServerRelativeUrl + "'");

$PNPSessionSubsite = Connect-PNPOnline -Url ($RootURL + $Subsite.ServerRelativeUrl) -Credentials (Create-PSCredential -Username $SPOServiceUsername -Password $SPOServicePassword) -ReturnConnection;

#Get all pages.

Write-Console -Text ("Getting pages (.aspx) from '" + ($RootURL + $Subsite.ServerRelativeUrl) + "', please wait");

$Pages += Get-SPSitePages -Session $PNPSessionSubsite -Subsite Yes -RootURL $RootURL;

}

#Export to the .CSV file.

$Pages | Export-Csv -Path $Files.Report -Encoding UTF8 -Delimiter ";" -NoTypeInformation;

############### Main - End ###############

#endregion

#region begin finalize

############### Finalize - Start ###############

#Disconnect the PowerShell session.

Disconnect-PnPOnline -Connection $PNPSession;

Disconnect-PnPOnline -Connection $PNPSessionSubsite;

############### Finalize - End ###############

#endregion

Alex Ø. T. Hansen

08/11/2018

SharePoint – Get all terms/keywords from the taxonomy store

Yesterday I publish an article how to replace/add keywords on documents. But one of the requirements was that you needed the ID of the term you want to find and add/replace. So yet again I created a small function that allows you to return all terms from the store.

You still need the PnP SharePoint cmdlets, which you can download here.

Function Get-SPTaxKeyword
{
    #Object array.
    $TermsCollection = @();

    #Get all term groups.
    $TermGroups = Get-PnPTermGroup;

    #Foreach term group.
    Foreach($TermGroup in $TermGroups)
    {
        #Get all term sets.
        $TermSets = $TermGroup | Get-PnPTermSet;

        #Foreach term set.
        Foreach($TermSet in $TermSets)
        {
            #Get all terms.
            $Terms = Get-PnPTerm -TermGroup $TermGroup.Name -TermSet $TermSet.Name;

            #Foreach term.
            Foreach($Term in $Terms)
            {
                #If a term is present.
                If($Term)
                {
                    #Create a new object.
                    $TermCollection = New-Object -TypeName PSObject;

                    #Add value to the object.
                    Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupName" -Value ($TermGroup.Name);
                    Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupId" -Value ($TermGroup.Id);
                    Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupSetName" -Value ($TermSet.Name);
                    Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupSetId" -Value ($TermSet.Id);
                    Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermName" -Value ($Term.Name);
                    Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermId" -Value ($Term.Id);

                    #Add to the object array.
                    $TermsCollection += $TermCollection;
                }
            }
        }
    }

    #Return terms.
    Return $TermsCollection;
}

#Get all keywords.
$Keywords = Get-SPTaxKeyword;

Function Get-SPTaxKeyword

{

#Object array.

$TermsCollection = @();

#Get all term groups.

$TermGroups = Get-PnPTermGroup;

#Foreach term group.

Foreach($TermGroup in $TermGroups)

{

#Get all term sets.

$TermSets = $TermGroup | Get-PnPTermSet;

#Foreach term set.

Foreach($TermSet in $TermSets)

{

#Get all terms.

$Terms = Get-PnPTerm -TermGroup $TermGroup.Name -TermSet $TermSet.Name;

#Foreach term.

Foreach($Term in $Terms)

{

#If a term is present.

If($Term)

{

#Create a new object.

$TermCollection = New-Object -TypeName PSObject;

#Add value to the object.

Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupName" -Value ($TermGroup.Name);

Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupId" -Value ($TermGroup.Id);

Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupSetName" -Value ($TermSet.Name);

Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermGroupSetId" -Value ($TermSet.Id);

Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermName" -Value ($Term.Name);

Add-Member -InputObject $TermCollection -Membertype NoteProperty -Name "TermId" -Value ($Term.Id);

#Add to the object array.

$TermsCollection += $TermCollection;

}

#Return terms.

Return $TermsCollection;

}

#Get all keywords.

$Keywords = Get-SPTaxKeyword;

Alex Ø. T. Hansen

19/09/2018

Exchange – Add nested group recipients to parent resources

Do you have nested groups within Exchange resources such as distribution groups, shared mailboxes, rooms or equipment?

If you have, you have come to the right place. I have created a script that extracts all nested group members of a resource, and add it directly to the resource instead.

The script works in both on-premise and Exchange Online.

Before you can run the script, you need to have access to the following:

Access to on-premise and/or Office 365 environment as a administrator.
Have the AzureAD and Active Directory PowerShell module installed.

Alex Ø. T. Hansen

01/09/2016

OneDrive – Replace ownership with PowerShell

If you need take ownership of an employees OneDrive, run the following PowerShell code.
Some requirements before running the script.

Azure Active Directory PowerShell Module: https://msdn.microsoft.com/en-us/library/azure/jj151815(v=azure.98).aspx
SharePoint Online Management Shell: https://www.microsoft.com/en-us/download/details.aspx?id=35588