Skip to content

Instantly share code, notes, and snippets.

WorkerID WorkerStatus WorkerType UserID Title FirstName Initial LastName Pronouns ManagerID HireDate LeaveDate TempLeave Department Division CostCenter JobTitle StreetAddress City State ZipCode Country CountryCode OfficePhone MobilePhone
3090 Active Employee natálie.mastná Ms. Natálie C Mastná SHE/HER 20646 11/09/2017 07/23/2030 FALSE Product Marketing Electronics CC3035 Licensed clinical social worker Vakthem 6 BJÄRTRÅ 870 26 Sweden SE 0612-3686526 +51 7249890429
{
"schemas": [
"urn:ietf:params:scim:api:messages:2.0:BulkRequest"
],
"Operations": [
{
"method": "POST",
"bulkId": "4a4639e0-698e-4d78-b531-ff1fa12b3e91",
"path": "/Users",
"data": {
@{
externalId = 'WorkerID'
name = @{
familyName = 'LastName'
givenName = 'FirstName'
}
active = { $_.'WorkerStatus' -eq 'Active' }
userName = 'UserID'
nickName = 'UserID'
userType = 'WorkerType'
@jkbryan
jkbryan / CreateCustomRole.ps1
Last active February 23, 2024 15:51
CreateCustomRole
Connect-MgGraph -TenantId <YourTenantID> -Scopes "RoleManagement.ReadWrite.Directory"
# Basic role information
$displayName = "Clone of Exchange Administrator"
$description = "Can manage all aspects of the Exchange product."
$templateId = (New-Guid).Guid
# Set of permissions to grant
$allowedResourceAction =
@(
#"microsoft.directory/groups/hiddenMembers/read",
"microsoft.directory/groups.unified/create",
@jkbryan
jkbryan / Get-AzureRoutes.ps1
Created February 8, 2019 20:57
A script to present Azure Route Tables into a csv file
Connect-AzureRmAccount
$Subscription = "<Subscription-GUID>"
$LogFile = "C:\<PATH>\RouteTables.csv"
If (Test-Path $Logfile) {
Clear-Content -Path $Logfile
}
Add-Content $Logfile "Name,ResourceGroupName,Location,RouteName,Id,Etag,ProvisioningState,AddressPrefix,NextHopType,NextHopIpAddress"
Set-AzureRmContext -Subscription $Subscription
$RTs = Get-AzureRmRouteTable
ForEach ($RT in $RTs) {
@jkbryan
jkbryan / full-wbadmin-backup-script.vbs
Created October 2, 2018 22:47
full-wbadmin-backup-script.vbs
ForceScriptEngine("cscript")
Const ForReading = 1
strComputer = "."
strDate = Replace(FormatDateTime(Date(),2),"/","-")
set objShell = CreateObject("WScript.Shell")
strComputer = objShell.ExpandEnvironmentStrings("%COMPUTERNAME%")
strUserDomain = objShell.ExpandEnvironmentStrings( "%USERDOMAIN%")
'Build the structure of file locations, recipients, log files etc....
strSharePath = "\\server\share\Backups"
strDomainPath = strSharePath & "\" & strUserDomain
@jkbryan
jkbryan / LegalText.vbs
Created October 2, 2018 22:26
LegalText.vbs
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
'~ SCRIPT NAME: LEGALNOTICE.VBS
'~ WRITTEN BY: JON BRYAN - March 2010
'~
'~ This script should be applied as a machine startup script that applies to all machines in a Domain.
'~
'~ It applies the Legal Text to all machines except those in the "AUTO_BOOT_PC" security group. This is a Security Group in your own Domain.
'~
'~ Before applying this script, remember to remove the 'normal' GPO settings found in:
'~ Computer Configuration/Windows Settings/Local Policies/Security Options -
# Login first
Login-AzAccount
# Note that you can optionally assign an Azure role on creation,
# define the context prior to SP creation, using Set-AzContext
#
# Create Service Principle
$sp = New-AzADServicePrincipal -Role Reader -DisplayName "MyServicePrinciple"
$BSTR = [System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($sp.Secret)
$UnsecureSecret = [System.Runtime.InteropServices.Marshal]::PtrToStringAuto($BSTR)
# Write out the password for the SP. Make sure you keep a secure copy of this output!
@jkbryan
jkbryan / Correct-UL-Label-Priority.ps1
Last active March 6, 2020 19:35
O365 Unified Labelling - Label Priority Fixing
# Define credentials
$AdminCredentials = Get-Credential "myadmin@oholics.net"
# Create the session
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.compliance.protection.outlook.com/powershell-liveid/ -Credential $AdminCredentials -Authentication Basic -AllowRedirection
# Import the session
Import-PSSession $Session -DisableNameChecking
# Define the tenant
$MyTenant = "CN=Configuration,CN=<TenantID>.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=FFO,DC=extest,DC=microsoft,DC=com"
# Get the priorities of all labels
$a=Get-Label
@jkbryan
jkbryan / Create-UL-Policy.ps1
Last active March 6, 2020 18:47
O365 Unified Labelling - Policy Creation
# Define credentials
$AdminCredentials = Get-Credential "myadmin@oholics.net"
# Create the session
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.compliance.protection.outlook.com/powershell-liveid/ -Credential $AdminCredentials -Authentication Basic -AllowRedirection
# Import the session
Import-PSSession $Session -DisableNameChecking
# Define the tenant
$MyTenant = "CN=Configuration,CN=<TenantID>.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=FFO,DC=extest,DC=microsoft,DC=com"
# Get the labels to add to the policy
$Label1=Get-Label -Identity "CN=My Label,$MyTenant"