I need to find the sql query another program was running on the MS SQL Server Database to reverse engineer it.
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 p.plan_handle = s.plan_handle
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t
WHERE t.[text] LIKE N'%something unique about your query%'
ORDER BY s.last_execution_time DESC;
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
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
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_
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