jdmills-edu’s gists

jdmills-edu / EMSAPI-GetRoomsAndBookings.ps1

Created September 21, 2017 13:41

A PowerShell script that uses the Dean Evans EMS API to retrieve a complete list of all buildings, rooms, and bookings in those rooms for the next calendar year.

	#This script queries the EMS API for all bookings in all rooms in all buildings for the next calendar year.
	#It requires the EMS Read-Only API and an authorised user on the EMS database.

	#Date math

	$today = Get-Date
	$lastYear = $today.AddYears(-1)
	$nextYear = $today.AddYears(1)
	$todayString = $today.ToString("MMMM dd, yyyy")
	$lastYearString = $lastYear.ToString("MMMM dd, yyyy")

jdmills-edu / ConnectToComplianceCenter.ps1

Created September 21, 2017 13:29

A PowerShell script that connects to the Office 365 Compliance Center.

	#O365 Global Admin Credentials stored as environmental variables.
	$cred = New-Object -typename System.Management.Automation.PSCredential -argumentlist $env:O365Admin_Username,(ConvertTo-SecureString -AsPlainText -Force -String $env:O365Admin_Password)

	$SCCSession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.compliance.protection.outlook.com/powershell-liveid/ -Credential $cred -Authentication Basic –AllowRedirection

	Write-Host "Connecting to Compliance Center..."

	Import-PSSession $SCCSession

jdmills-edu / ConnectToExchangeOnline.ps1

Created September 21, 2017 13:26

A PowerShell script to connect to Exchange Online, with an optional parameter for RPS (useful for uploading profile photos).

	param(
	[ValidateSet('True','False')][String]$rps
	)

	#O365 Global Admin Credentials stored as environmental variables.
	$cred = New-Object -typename System.Management.Automation.PSCredential -argumentlist $env:O365Admin_Username,(ConvertTo-SecureString -AsPlainText -Force -String $env:O365Admin_Password)

	switch($rps){
	'True' {
	$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/?proxymethod=rps -Credential $cred -Authentication Basic -AllowRedirection

jdmills-edu / ZendeskAPI-UpdateCustomField.ps1

Created September 20, 2017 20:26

This PowerShell script updates a custom field on a given Zendesk ticket.

	param(
	[Parameter(Mandatory=$true)][Int32]$ticketID,
	[Parameter(Mandatory=$true)][Int32]$fieldID,
	[Parameter(Mandatory=$true)][string]$fieldValue
	)

	#Zendesk API Connection Headers Referencing System Environmental Variables for username and API token.
	$headers = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$($env:ZendeskAPI_Username):$($env:ZendeskAPI_Token)"));}

	#Zendesk API: Update Ticket

jdmills-edu / ZendeskAPI-SyncOutOfOffice.ps1

Last active September 20, 2017 20:23

This PowerShell script synchronizes the Out-Of-Office status of your Zendesk agent Exchange mailboxes with the Zendesk Out-Of-Office Extension. This provides a much better user experience to your agents than requiring them to set their statuses separately in Outlook and Zendesk. Run this as a scheduled task.

	#Download all admin and agent user objects from Zendesk.
	$agents = &ZendeskAPI-GetZendeskUsers.ps1 "allagents"

	#Trim agent list.
	$agents = $agents \| where email -like "*@yourdomain.com" \| sort email

	#Connect to Exchange Online. Use your own script here or swap this line out with the connection commands supplied by Microsoft.
	#There's no reason this won't work with Exchange On-Prem AFAIK. We just use Exchange Online, so the comments reference it.
	&ConnectToExchangeOnline.ps1

jdmills-edu / ZendeskAPI-GetZendeskUsers.ps1

Created September 20, 2017 20:14

A PowerShell script that lists all Zendesk users in your tenant. You can use the role parameter to have the script return admins, agents, agents+admins, end-users, or all users. Supports pagination and deduplication.

	param(
	[ValidateSet('admin', 'agents', 'allagents', 'endusers', 'allusers')][String]$role
	)

	#Zendesk API Connection Headers Referencing System Environmental Variables for username and API token.
	$headers = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$($env:ZendeskAPI_Username):$($env:ZendeskAPI_Token)"));}

	#GET ALL ZENDESK USERS

	$allUsers = @()

jdmills-edu / ZendeskAPI-PostComment.ps1

Created September 20, 2017 19:36

A PowerShell script that posts a comment (public or private) to a Zendesk ticket. Supports rich and HTML comments and author impersonation.

	param(
	[Parameter(Mandatory=$true)][Int32]$ticketID,
	[Parameter(Mandatory=$true)][String]$body,
	[Parameter(Mandatory=$true)][ValidateSet('rich', 'html')][String]$body_type,
	[Parameter(Mandatory=$true)][ValidateSet('private', 'public')][string]$scope,
	[String][ValidateSet('assignee', 'apiuser')]$author
	)

	if($body_type -eq "html"){
	$zd_body_type = "html_body"

jdmills-edu / ZendeskAPI-GetUser.ps1

Last active September 20, 2017 19:14

A PowerShell script that returns a Zendesk user.

	param(
	[Parameter(Mandatory=$true)][String]$userID
	)

	#Zendesk API Connection Headers Referencing System Environmental Variables for username and API token.
	$headers = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$($env:ZendeskAPI_Username):$($env:ZendeskAPI_Token)"));}

	$userURI = "https://yourdomain.zendesk.com/api/v2/users/$userID.json"
	$user = Invoke-RestMethod -Uri $userURI -Method Get -Headers $headers -ContentType "application/json"
	$user = $user.user

jdmills-edu / ZendeskAPI-GetTicket.ps1

Last active September 20, 2017 19:15

A PowerShell script that returns a Zendesk ticket of a given ID.

	param(
	[Parameter(Mandatory=$true)][Int32]$ticketID
	)

	#Zendesk API Connection Headers Referencing System Environmental Variables for username and API token.
	$headers = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$($env:ZendeskAPI_Username):$($env:ZendeskAPI_Token)"));}

	$ticketsURI = "https://yourdomain.zendesk.com/api/v2/tickets/$ticketID.json"

	$ticket = Invoke-RestMethod -Uri $ticketsURI -Method Get -Headers $headers -ContentType "application/json"

jdmills-edu / ZendeskAPI-ChangeTicketStatus.ps1

Last active September 20, 2017 19:53

A PowerShell script that changes the status of a Zendesk ticket.

	param(
	[Parameter(Mandatory=$true)][Int32]$ticketID,
	[Parameter(Mandatory=$true)][ValidateSet('open', 'pending', 'on-hold', 'solved')][String]$ticketStatus
	)

	#Zendesk API Connection Headers Referencing System Environmental Variables for username and API token.
	$headers = @{Authorization = 'Basic ' + [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$($ZendeskAPI_Username):$($ZendeskAPI_Token)"));}

	#Zendesk API: Update Ticket
	$uri = "https://yourdomain.zendesk.com/api/v2/tickets/$ticketID.json"

JD Mills jdmills-edu