SMSAgentSoftware

<#
.Synopsis
   Exports all scripts (discovery and remediation) used in all SCCM Compliance Setting Configuration Items
.DESCRIPTION
   This script connects to the SCCM database to retrieve all Compliance Setting Configuration Items. It then processes each item looking for
   discovery and remediation scripts for the current (latest) version. It will export any script found into a directory structure.
.NOTES
    Requirements - 'db_datareader' permission to the SCCM SQL database with the account running this script.
    Parameters - set the parameters below as required
#>

SMSAgentSoftware

## Saves ConfigMgr Site Maintenance Task settings from WMI to json files ##
## Should be run on the Primary Site Server ##
## Should be run as administrator ##

[cmdletbinding()]
Param(
    [Parameter(Position=0,Mandatory=$True)]
    [ValidateNotNullorEmpty()]
    [string]$SiteCode,
    [Parameter(Position=1,Mandatory=$True)]

SMSAgentSoftware

# Get the TS variables
$tsenv = New-Object -COMObject Microsoft.SMS.TSEnvironment 
$ScriptRoot = $tsenv.Value("ScriptRoot")
$OSDTargetSystemRoot =  $tsenv.Value("OSDTargetSystemRoot")

# Rename default wallpaper
Rename-Item $OSDTargetSystemRoot\Web\Wallpaper\Windows\img0.jpg img1.jpg -Force

# Copy new default wallpaper
Copy-Item $ScriptRoot\img0.jpg $OSDTargetSystemRoot\Web\Wallpaper\Windows -Force

SMSAgentSoftware

Function Get-CMClientVersions {
    
    # Requires the "New-WPFMessageBox" function available at https://gist.github.com/SMSAgentSoftware/0c0eee98a673b6ac34f5215ea6841beb
    # Requires minimum "db_datareader" SQL role in the ConfigMgr database
    # Usage: Get-CMClientVersions -SQLServer "SQLServer" -Database "Database"
    
    [CmdletBinding()]
    Param
    (
        [Parameter(Mandatory=$True,Position=0)]

SMSAgentSoftware

## Restores ConfigMgr Site Maintenance Task settings from json files (backed up using the 'Backup-CMSiteMaintenanceTaskSettings' script ##
## Should be run on the Primary Site Server ##
## Should be run as administrator ##

[cmdletbinding()]
Param(
    [Parameter(Position=0,Mandatory=$True)]
    [ValidateNotNullorEmpty()]
    [string]$SiteCode,
    [Parameter(Position=1,Mandatory=$True)]

SMSAgentSoftware

Function Get-IntuneDataWarehouseData {

    # Function to query the Intune Data Warehouse for data
    # Requires an access token to be created first via the New-IntuneDataWarehouseAccessToken function
    
    [CmdletBinding()]
    Param(
        [Parameter()] # this is the custom feed URL for your for your tenant for the InTune Data Warehouse
        $WarehouseUrl = "https://fef.msun02.manage.microsoft.com/ReportingService/DataWarehouseFEService?api-version=beta",
        [Parameter()] 

SMSAgentSoftware

Function New-IntuneDataWarehouseAccessToken {
    
    # Function to get an access token for the Intune Data Warehouse
    # To be used in conjunction with the function Get-IntuneDataWarehouseData
    # Will download NuGet if required to install the latest Active Directory Authentication Library package

    [CmdletBinding()]
    Param(
        [Parameter()]
        $NuGetDirectory = "$Env:USERPROFILE\NuGet",

SMSAgentSoftware

Function New-SingleSeriesSplineChart {
    
    [CmdletBinding()]
    Param(
        [Parameter(Mandatory=$true)]
        $Title,
        [Parameter(Mandatory=$true)]
        $Data,
        [Parameter(Mandatory=$true)]
        $AxisX,

SMSAgentSoftware

######################################################################################
##                                                                                  ##
## This script compares the current list of AD sites and subnets with a cached list ##
## If anything has changed, the cached list will be updated and the changes emailed ##
##                                                                                  ##
######################################################################################


################
## PARAMETERS ##

SMSAgentSoftware

<#
.Synopsis
   Retrieves O365/C2R info from a local or remote registry
.DESCRIPTION
   Retrieves some basic info on the Office 365 / Click-to-run installation on the local or remote computer/s, such as products installed, version number, activation account, bitness etc. 
   Requires PS remoting to be enabled for remote computer access.
.PARAMETER ComputerName
   [Optional] the name or names of remote computers
.EXAMPLE
   Get-OfficeC2RInfo