Using OneDrive, Folder Rediection, and Group Policy Objects

Joe Vanderstelt

Dec 19, 2023 — 1 min read

The Goal

Use OneDrive for Business for:
- Documents
- Pictures
- Movies
- Music
- Desktop
- Make it transparent to the end user
- Use GPO for easy deployment

This requires OneDrive for Business to be setup the to the same folder in %USERPROFILE% for each user for this example it will be %USERPROFILE%\One Drive for Business

The Issue

When setting the Folder Redirection setting in GPO, if target folder started with %USERPROFILE% GPO assumes it is the default location. e.g. Documents = %USERPROFILE%\Documents.

The Solution

First: Create a GPO that sets an user environment variable, this GPO must be processed BEFORE the next one.

ONEDRIVE = %USERPROFILE%\OneDrive for Business

this in User Configuration\Preferences\Windows Settings\Environment

Second: Create a GPO to set the Folder Redirection policy.

Documents = %ONEDRIVE%\Documents

this is in User Configuration\Windows Settings\Folder Redirection

Third:

Run

gpupdate /force

on each computer and reboot or at lest log out and back in.

The Result

If the users Redirected Folders where not in the OneDrive location they were moved when they first logged in and OneDrive synced them.

MS SQL Server query log

The Problem I need to find the sql query another program was running on the MS SQL Server Database to reverse engineer it. The Solution SELECT t.[text], s.last_execution_time FROM sys.dm_exec_cached_plans AS p INNER JOIN sys.dm_exec_query_stats AS s ON

Share Contacts and Calanders

The Goal Set All Users Contacts and Calander to Default to Reviewer Permissions The Solution First we need to connect to Office 365 using power shell Import-Module MSOnline $cred = Get-Credential Connect-MsolService –Credential $cred Second iterate over the Mailboxes and set permission Get-Mailbox | ForEach-Object { Set-MailboxFolderPermission ${_}:\calander -User default -AccessRights Reviewer Set-MailboxFolderPermission

Add an Alias to all Mailboxes of FirstL

The Goal Add an alias for all users in office 365 of first name + first letter of last name The Solution First we need to connect to Office 365 using power shell Import-Module MSOnline $cred = Get-Credential Connect-MsolService –Credential $cred Second iterate over the Mailboxes and add the aliases Get-Mailbox -resultsize

Find Office 365 Users with a given license

The Goal Find all the Office 365 users with a given license The Solution First we need to connect to Office 365 using power shell Import-Module MSOnline $cred = Get-Credential Connect-MsolService –Credential $cred Use Get-MsolAccountSku to find a specific SKU, in this example we are going to use tenent:O365_BUSINESS_