alexverboon

# connect to EXO with MFA
$CreateEXOPSSession = (Get-ChildItem -Path $env:userprofile -Filter CreateExoPSSession.ps1 -Recurse -ErrorAction SilentlyContinue -Force | Select -Last 1).DirectoryName
. "$CreateEXOPSSession\CreateExoPSSession.ps1"

alexverboon

function Verify-MScoreHostedOutboundSpamFilterPolicy
{
<#
.Synopsis
   Verify-MScoreHostedOutboundSpamFilterPolicy

.DESCRIPTION
   
   The Verify-MScoreHostedOutboundSpamFilterPolicy cmdlet verifies the configuation
   of the outbound spam policy

alexverboon

function Start-OfficeReadinessCollection
{
<#
.Synopsis
   Start-OfficeReadinessCollection
.DESCRIPTION
   Start-OfficeReadinessCollection is a wrapper script for the Readiness Toolkit for Office add-ins and VBA

.PARAMETER OutPutPath
 Specifies the path where the Office Readiness Assessment results are stored.

alexverboon

Function Export-CMScriptResults
{
<#
.Synopsis
   Export-CMScriptResults
.DESCRIPTION
   Export-CMScriptResults exports the return values from scripts that are executed
   through the ConfigMgr Run Script feature. 
.PARAMETER ScriptName
   The name of the Script as it is displayed within the ConfigMgr Console. 

alexverboon

<#
.Synopsis
   Get-UserProfileSize
.DESCRIPTION
   Get-UserProfileSize retrieves the profile size information of each locally stored profile. The command retrieves the 
   size of the profile Document and Desktop folder and the full profile size but excluding the AppData\local folder

.EXAMPLE
  Get-UserProfileSize -OutPutLocation C:\Temp -Verbose

alexverboon

function Import-SecurityBaselineGPO
<#
.Synopsis
   Import-SecurityBaselineGPO
.DESCRIPTION
   Import-SecurityBaselineGPO
.PARAMETER GPOBackupPath
  The path that constains the Security baselines GPO backup
 
.EXAMPLE

alexverboon

function Test-EnvPathHealth
{
<#
.Synopsis
   Test-EnvPathHealth
.DESCRIPTION
   Test-EnvPathHealth tests if the paths defined within the %PATH% environment variable
   exist.  
.PARAMETER Writable

alexverboon

// code used in https://www.verboon.info/2019/11/how-to-generate-a-monthly-defender-atp-threat-and-vulnerability-report/
DeviceTvmSoftwareInventoryVulnerabilities  
| project  DeviceName, SoftwareName, CveId, SoftwareVersion, VulnerabilitySeverityLevel 
| join (DeviceTvmSoftwareVulnerabilitiesKB
| project AffectedSoftware, VulnerabilityDescription , CveId , CvssScore , IsExploitAvailable 
)
on CveId 
| project CveId , SoftwareName , SoftwareVersion , VulnerabilityDescription , VulnerabilitySeverityLevel, IsExploitAvailable , CvssScore 
| distinct SoftwareName , SoftwareVersion, CveId, VulnerabilityDescription , VulnerabilitySeverityLevel, IsExploitAvailable  
| sort by SoftwareName asc , SoftwareVersion

alexverboon

function Get-ADSysVolPolicyFolders
{
<#
.Synopsis
   Verify-ADSysVolPolicyFolders
.DESCRIPTION
   Get-ADSysVolPolicyFolders retrieves all the folders within the SYSVOL\Policies folder and checks
   whether it belongs to an existing Group Policy object. 

   Use this script to identify orphan group policy content folders that can be removed.

alexverboon

# Prepare Folder Structure"
If (-not (Test-Path -Path "C:\TEMP\GPO" -PathType Container ))
{
    New-Item -Path "C:\TEMP\GPO" -ItemType "Directory"
    New-Item -Path "C:\TEMP\GPO\Backup" -ItemType "Directory"
    New-Item -Path "C:\TEMP\GPO\Reports" -ItemType "Directory"
}
Else
{