Ioan-Popovici

/*
.SYNOPSIS
    Gets the BitLocker compliance in SCCM.
.DESCRIPTION
    Gets the BitLocker compliance and policy with SCCM custom HWI extensions.
.NOTES
    Created by Ioan Popovici
    Requires SCCM with SSRS/SQL, HWI Extension
.LINK
    BlogPost: https://SCCM.Zone/SEC-BitLocker-Compliance-And-Policy

Ioan-Popovici

//——————————————— // BitLocker Policy //———————————————

//-- Set default Namespace and delete the Win32Reg_BitLockerPolicy if it already exists
#PRAGMA Namespace   ("\\\\.\\Root\\CIMv2")
#PRAGMA DeleteClass ("Win32Reg_BitLockerPolicy", NOFAIL)

//-- Create custom class
//-  Class properties
[DYNPROPS]
Class Win32Reg_BitLockerPolicy

Ioan-Popovici

//——————————————— // BitLocker Status //———————————————

//-- Set default Namespace and delete the Win32_EncryptableVolume_Ext if it already exists
#PRAGMA Namespace   ("\\\\.\\Root\\CIMv2")
#PRAGMA DeleteClass ("Win32_EncryptableVolume_Ext", NOFAIL)

//-- Create custom class
//-  Class Qualifiers
[
    Description ("The Win32_EncryptableVolume_Ext class contains information about the BitLocker status. You can use this information for BitLocker reporting."): ToInstance,

Ioan-Popovici

<#
.SYNOPSIS
    Exports data from the SCCM database.
.DESCRIPTION
    Exports data from the SCCM database and formats it for telegraf.
.PARAMETER Server
    Specifies the server name.
.PARAMETER Database
    Specifies the database name.
.PARAMETER ServerCollectionID

Ioan-Popovici

[[inputs.exec]]
  commands = ["powershell C:/Telegraf_Scripts/Export-CMDBToTelegraf.ps1 -Server 'SomeSCCMDBServer' -Database 'CM_SomeSiteCode' -ServerCollectionID 'SomeServerCollectionID' -WorkstationCollectionID 'SomeWorkstationCollectionID'"]
  interval = "20s"
  timeout = "30s"
  data_format = "influx"

Ioan-Popovici

/*
.SYNOPSIS
    Lists the installed software.
.DESCRIPTION
    Lists the installed software by user selection (Device, Publisher or Name).
    Supports filtering and exclusions by multiple software names using comma separated values and sql wildcards.
.NOTES
    Created by Ioan Popovici.
    Requires ufn_csv_String_Parser custom function.
    Part of a report should not be run separately.

Ioan-Popovici

Ioan-Popovici

Ioan-Popovici

Ioan-Popovici