Advanced Search
Search Results
16 total results found
Redirect Email
In the case email should be redirected from the original recipient to another mailbox, you can use redirect rules. This is useful if email should be delivered to multiple recipients or, for offboarding, a departed employee's email should be redirected to their...
Find Data in Cell
This document is in development SEARCH finds "text value" in cell A1. IF result of SEARCH is that the data is found, result returns TRUE. Else, FALSE. =IF(SEARCH("text value",A1,1),TRUE,FALSE)
Count Unique Values in Spreadsheet
This document is in development UNIQUE finds the unique values in a spreadsheet row or column. COUNTA counts the results of UNIQUE, result returns a numeric value. =COUNTA(UNIQUE(A1:B100))
Reset IE to Defaults
Symptoms: OneDrive stuck at Signing in. OneDrive sign-in gives Proxy Authentication Error [2606] Outlook continually asks for password. Solution: RunDll32.exe InetCpl.cpl,ResetIEtoDefaults Source
Create .pkg to deploy files and apps
Create a directory named Contents and another named Scripts. Put the app contents in the Contents directory. Put the script in the Scripts directory and name it postinstall, with no extension and give it executable rights. Run this command to create the ...
Manually Sync macOS Device with Intune
In Company Portal, click the ellipses and Check Status or press command+option+S. To trigger a sync form the CLI, force close the Intune Agent process. Use ps to list running processes; the -A flag specifies all running processes. Pipe the output to the g...
Forcefully Remove MDM from Mac
Reboot into Recovery Mode Open Terminal and run csrutil disable then reboot. This disables System Integrity Protection. After reboot, move the configuration profiles directory: mv /var/db/ConfigurationProfiles /var/db/ConfigurationProfiles.old Or destroy...
Install SSL Certificate on IIS hosted site
Copied from https://www.thesslstore.com How to Generate a CSR for Microsoft IIS 7 The following instructions will guide you through the CSR generation process on Microsoft IIS 7. To learn more about CSRs and the importance of your private key, reference o...
Check For Running Process
Check for a running process. If the process is not running, start it. #CHECK RUNNING PROCESS $Check = (Get-Service -Name <ServiceName> -ErrorAction SilentlyContinue -ErrorVariable ProcessError) Invoke-Command -ScriptBlock{ if($Check -eq $null) { W...
Create a Scheduled Task
To create a scheduled task in Windows Powershell that executes a Powershell Script. CREATE SCHEDULED TASK $action = New-ScheduledTaskAction -Execute "cd C:\path\to\script\location; ./script.ps1" $trigger = New-ScheduledTaskTrigger -At "8:15 pm" -Daily $pri...
Change Drive Letter in Powershell
Sourceshttps://devblogs.microsoft.com/powershell-community/changing-drive-letters-and-labels-via-powershell/https://chindara.medium.com/windows-10-powershell-to-assign-drive-letters-2dcb840191bb List all the disks. Get-Disk List all partitions for a specifi...
Lock Windows Workstation
In command prompt, run: Rundll32.exe user32.dll,LockWorkStation
Find and Replace with Regex
Regex to find date and time. Option 1: ([\d]{1,2})/([\d]{1,2})/([\d]{4}) in format mm/dd/yyyy Option 2: [0-9]{4}-[0-9]{2}-[0-9]{2}T in format yyyy-mm-dd Option 3: ([0-1]?[0-9]|2[0-3]):[0-5][0-9] in format HH:mm In Sublime Text Find and Replace (CMD+OPT+F) ...
Change Intune macOS Personal Ownership to Company
Get-MgDeviceManagementManagedDevice -All | Where-Object {$_.ManagedDeviceOwnerType -eq "unknown" -and $_.OperatingSystem -like "macOS"} | % { Update-MgDeviceManagementManagedDevice -ManagedDeviceId $_.Id -ManagedDeviceOwnerType company }
macOS Login Window - show username and password box
Press the following keys simultaneously. CONTROL+OPTION+COMMAND+SHIFT+DOWN ARROW+ENTER
Prevent Spoofing of Executives
To add a disclaimer for incoming emails that bear the name of an executive, go to the Exchange Transport Rules and create a rule. https://admin.exchange.microsoft.com/#/transportrules Rule Conditions: The Message Header From Contains executive names AND T...