Ioan-Popovici

<#
.SYNOPSIS
    Disables SCCM push install for a specified collection.
.DESCRIPTION
    Disables SCCM push install for a specified collection using the ExcludeServers registry key.
.PARAMETER CMSiteServer
    Specifies the NetBIOS name of the SCCM Site Server.
.PARAMETER CMCollection
    Specifies the Collection Name to exclude from Push Install.
.PARAMETER DeleteAllCollectionMembers

Ioan-Popovici

<#
.SYNOPSIS
    Sets maintenance windows using a CSV file.
.DESCRIPTION
    Sets maintenance windows using a CSV file and is triggered when the settings CSV file is saved. using file watcher.
.EXAMPLE
    Set-ClientMaintenanceWindows.ps1
.NOTES
    Created by Ioan Popovici
    Uses FileSystemWatcher to see when the CSV file is changed.

Ioan-Popovici

<#
.SYNOPSIS
    Adds devices from a txt file to a SCCM device collection.
.DESCRIPTION
    Adds devices from a txt file to a SCCM device collection, triggered when the txt file is saved.
.EXAMPLE
    Add-CMDeviceDirectMemebershipRules.ps1
.INPUTS
    System.String
.OUTPUTS

Ioan-Popovici

<#
*********************************************************************************************************
*                                                                                                       *
*** This PowerShell script is Get the SCEP Logs from SCCM DB and export them to a CSV file            ***
*                                                                                                       *
*********************************************************************************************************
* Created by Octavian Cordos, 2017-03-28   | Requirements: PowerShell 3.0, SQL PS commandlets           *
* ======================================================================================================*
* Modified by                   | Date       | Version  | Comments                                      *
*_______________________________________________________________________________________________________*

Ioan-Popovici

Define ROOT C:\Program Files (x86)\nxlog
 
Moduledir %ROOT%\modules
CacheDir %ROOT%\data
Pidfile %ROOT%\data\nxlog.pid
SpoolDir %ROOT%\data
LogFile %ROOT%\data\nxlog.log
 
<Extension gelf>
    Module xm_gelf

Ioan-Popovici

DECLARE @AuthListLocalID AS int
SELECT @AuthListLocalID=CI_ID
FROM v_AuthListInfo
WHERE v_AuthListInfo.Ci_UniqueID=@AuthListID;


SELECT DISTINCT rs.NetBios_Name0 AS Name,
                CASE
                    WHEN os.Caption0 LIKE '%2003%' THEN 'Windows 2003'
                    WHEN os.Caption0 LIKE '%2008R2%' THEN 'Windows 2008 R2'

Ioan-Popovici

DECLARE @AuthListLocalID AS int
SELECT @AuthListLocalID=CI_ID
FROM v_AuthListInfo
WHERE CI_UniqueID=@AuthListID
    SELECT DISTINCT ui.BulletinID,
                    ui.ArticleID,
                    ui.Title,
                    a ui.Description,
                    ui.DateRevised,
                    CASE ui.Severity

Ioan-Popovici

<#
.SYNOPSIS
    Performs a windows cleanup.
.DESCRIPTION
    Performs a windows cleanup by removing volume caches, update backups, update and CCM caches.
.PARAMETER CleanupOptions
    Supported options:
        "comCacheRepair"   # Component Cache Repair
        "comCacheCleanup"  # Component Cache Cleanup
        "volCacheCleanup"  # Volume Cache Cleanup

Ioan-Popovici

/*
*********************************************************************************************************
* Created by Ioan Popovici, 2015-08-18       | Requirements: HWI - Win32_QuickfixEngineering WMI Class. *
* ======================================================================================================*
* Modified by                   |    Date    | Revision | Comments                                      *
*_______________________________________________________________________________________________________*
* Ioan Popovici/Octavian Cordos | 2015-08-18 | v1.0     | First version                                 *
*-------------------------------------------------------------------------------------------------------*
*                                                                                                       *
*********************************************************************************************************

Ioan-Popovici

/*
.SYNOPSIS
    Parses a CSV string.
.DESCRIPTION
    Parses a CSV string and returns individual substrings.
.PARAMETER pInputString
    Specifies the input string.
.PARAMETER pDelimiter
    Specifies the delimiter.
.EXAMPLE