garrytrinder

Param(    
    [Parameter(Mandatory=$true)]
    [string]$SiteUrl   
)
# ensure that any error stops the job
$ErrorActionPreference = "Stop"

# create connection to SharePoint site
Connect-PnPOnline -Url $SiteUrl -Credentials (Get-AutomationPSCredential -Name "Lundhill")

garrytrinder

# Requires Azure Powershell
# https://docs.microsoft.com/en-us/powershell/azure/install-azurerm-ps?view=azurermps-6.1.0

# Requires PowerShell support for PowerApps (preview)
# https://docs.microsoft.com/en-us/powerapps/administrator/powerapps-powershell

# Step 1 - Setup PowerShell support for PowerApps
Import-Module .\Microsoft.PowerApps.Administration.PowerShell.psm1 -Force
Import-Module .\Microsoft.PowerApps.PowerShell.psm1 -Force
Get-ChildItem . | Unblock-File

garrytrinder

Get-SPOSite | Select-Object Url,Title,Template, @{Expression={($_.Template -like "STS#3") -or ($_.Tem
plate -like "GROUP#0") -or ($_.Template -like "SITEPAGEPUBLISHING#0")};label="Modern"} | Sort-Object @{Expression={$_.Mo
dern};Descending=$True}, @{Expression={$_.Url};Descending=$False}

garrytrinder

Param(
    [Parameter(Mandatory=$true)]
    [string]$CredentialName,
    [Parameter(Mandatory=$true)]
    [string]$SiteUrl,
    [Parameter(Mandatory=$true)]
    [xml]$Template
)

# Store XML Template as local file

garrytrinder

Param(
    [Parameter(Mandatory=$true)]
    [string]$CredentialName,
    [Parameter(Mandatory=$true)]
    [string]$TenantAdminUrl,
    [Parameter(Mandatory=$true)]
    [string]$SiteTitle,
    [Parameter(Mandatory=$true)]
    [string]$SiteDescription,
    [Parameter(Mandatory=$true)]

garrytrinder

Param(
    [Parameter(Mandatory=$true)]
    [string]$ListName
)

Get-PnPListItem -List $ListName | ForEach-Object { Remove-PnPListItem -List $ListName -Identity $_ -Force; Write-Host "Removed item $($_.Id)" }

garrytrinder

Param(
    [Parameter(Mandatory=$true)]
    [string]$CredentialName,
    [Parameter(Mandatory=$true)]
    [string]$TenantAdminUrl,
    [Parameter(Mandatory=$true)]
    [string]$SiteTitle,
    [Parameter(Mandatory=$true)]
    [string]$SiteDescription,
    [Parameter(Mandatory=$true)]

garrytrinder

Set(
    gblFont,
    Font.'Open Sans'
);
Set(
    gblColor,
    {
        Primary: {
            _700: RGBA(
                29,

garrytrinder

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      Garry Trinder
-- Create Date: 17/02/2019
-- Description: Truncates TimeEntry table and imports data from Azure Storage
-- =============================================
CREATE PROCEDURE ImportTimeEntries @Run bit

garrytrinder

CREATE MASTER KEY ENCRYPTION BY PASSWORD='<insert strong password>';

CREATE DATABASE SCOPED CREDENTIAL harvestdata001credential  
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = '<insert shared access signature>';

CREATE EXTERNAL DATA SOURCE harvestdata001
 WITH ( TYPE = BLOB_STORAGE,
        LOCATION = 'https://harvestdata001.blob.core.windows.net',
        CREDENTIAL= harvestdata001credential);