Sage Antivirus Exclusions – Powershell Script for Windows Defender

Sage Antivirus Exclusions – Powershell Script for Windows Defender

What does this Powershell Script do? This is a simple Powershell Script to automate the process of adding Exclusions for Sage Accounts into Windows Defender It will carry out the File and Folder exclusions listed in the following Sage Article: https://my.sage.co.uk/public/help/askarticle.aspx?articleid=12122 It Will NOT add the URL Exclusions. The Script has been tested on the …

Read More Read More

How to completely remove Sage Accounts (V18 to V24) via Powershell

How to completely remove Sage Accounts (V18 to V24) via Powershell

What is this:? This is a Powershell Script to automate the removal of Sage Accounts version 18 to version 24 from a PC. The script accomplishes the steps in Sage Article 31544: https://my.sage.co.uk/public/help/askarticle.aspx?articleid=31544 Steps carried out to remove Sage Accounts: Removes DSN and ODBC data sources Deletes the following shared folders: C:\Program Files\Common Files\Sage SBD …

Read More Read More

How to Disable Office365 Integrated Apps for all Tenants (Powershell)

How to Disable Office365 Integrated Apps for all Tenants (Powershell)

What is it? This very simple Powershell script is aimed at MSPs and Microsoft Partners that manage their clients Office365 environments. It will disable the ‘UsersPermissionToUserConsentToAppEnabled’ option within the clients Tenancy so that they are unable to give permission for third party Apps to access their Office365 Accounts. Why would you want to do this? …

Read More Read More

PowerShell Script to connect to Microsoft Online Services (Office365)

PowerShell Script to connect to Microsoft Online Services (Office365)

Below is a simple PowerShell Script to connect to the following Microsoft Online Services: Office365 Admin Center Exchange Online Sharepoint Online Skype for Business Security and Compliance Center The Script has a simple Menu build in so that you can connect to the services that you need. You’re prompted for your Office365 Credentials prior to …

Read More Read More

Set-MsolUser command returns a ‘Unable to update parameter’ error

Set-MsolUser command returns a ‘Unable to update parameter’ error

You’re trying to change a user parameter in Office365 via the Set-MsolUser PowerShell Cmdlet but it returns the following error: Set-MsolUser : Unable to update parameter. Parameter name: DEPARTMENT. At line:1 char:1 + Set-MsolUser -UserPrincipalName [email protected] -Department … + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (:) [Set-MsolUser], MicrosoftOnlineException + FullyQualifiedErrorId : Microsoft.Online.Administration.Automation.PropertyNotSettableException,Microsoft.Online .Administration.Automation.SetUser You may see …

Read More Read More

Powershell Commands to remember for the Microsoft 70-346 Exam

Powershell Commands to remember for the Microsoft 70-346 Exam

Powershell Cmdlets to remember for the Microsoft 70-346: Managing Office 365 Identities and Requirements Exam I have recently completed the Microsoft 70-346 ‘Managing Office 365 Identities and Requirements’ Exam. The Exam focuses quite a bit around PowerShell. Below is a list of PowerShell cmdlets which may appear in the exam. Also, I’ve created a bunch …

Read More Read More

Powershell Commands to remember for the Microsoft 70-347 Exam

Powershell Commands to remember for the Microsoft 70-347 Exam

Powershell Cmdlets to remember for the Microsoft 70-347: Enabling Office 365 Services Exam I am currently studying for the Microsoft 70-347: Enabling Office 365 Services exam. Below is a list of PowerShell commands and their purpose for reference. More commands will be added to the below as I learn them. Also, some useful flashcards for …

Read More Read More

Collection of useful Powershell commands for Server Administration

Collection of useful Powershell commands for Server Administration

Below is a list of useful Powershell commands that I use day to day – This list will be built upon over time: Windows Server: Get a list of running services: Get-Service | Where-Object {$_.Status -eq “Running”} Microsoft Exchange Server Connect to Office 365 Exchange Online: $UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri …

Read More Read More

How to connect to the WSUS Database

How to connect to the WSUS Database

To connect to the WSUS Database in SBS2011 (Server 2008) follow the below steps: 1) Open the Microsoft SQL Server Management Studio (As Administrator) 2) In the Database field Enter the below: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query 3) Click Connect Done Want to read more of my articles on WSUS: –Resolve the CLR20r3 MoveData.exe Crash –Property Owner is not …

Read More Read More

Microsoft Office Professional 2016 encountered an error during setup

Microsoft Office Professional 2016 encountered an error during setup

Problem: I recently has an issue when trying to install Microsoft Office Professional 2016 (Volume Licence) onto a new Windows 10 machine. The setup.exe would fail with the below error: Microsoft Office Professional 2016 encountered an error during setup Troubleshooting: I checked the Office Setup logs located in the following directory C:\Users\USER\AppData\Local\Temp and found the …

Read More Read More