Ioan Popovici Ioan-Popovici
Ioan-Popovici
/ Reset-WindowsUpdate.ps1
Last active
December 4, 2020 23:48
Detects and resets a corrupted windows update component.
Detection is done by testing the eventlog with the specified parameters.
Reset is performed by reseting the windows update component to its initial state.
The specified eventlog is backed up an
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| .SYNOPSIS | |
| Resets the windows update component. | |
| .DESCRIPTION | |
| Detects and resets a corrupted windows update component. | |
| Detection is done by testing the eventlog with the specified parameters. | |
| Reset is performed by resetting the windows update component to its initial state. | |
| The specified eventlog is backed up and cleared in order not to trigger the detection again before the reset step. | |
| The backup of the specified eventlog is stored in 'SystemRoot\Temp' folder. | |
| Defaults are configured for the ESENT '623' error. |
Ioan-Popovici
/ DE Application Deployments by Device or User.sql
Last active
July 15, 2019 13:52
Lists the Application Deployments for a Device or User Collection.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .SYNOPSIS | |
| Lists the Application Deployments for a Collection. | |
| .DESCRIPTION | |
| Lists the Application Deployments for a Device or User Collection. | |
| .NOTES | |
| Created by Ioan Popovici | |
| Part of a report should not be run separately. | |
| .LINK | |
| https://SCCM.Zone/DE-Deployments-by-Device-or-User |
Ioan-Popovici
/ DE Package Deployments by Device or User.sql
Last active
February 21, 2019 16:01
Lists the Package Deployments for a Device or User Collection.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .SYNOPSIS | |
| Lists the Package Deployments for a Collection. | |
| .DESCRIPTION | |
| Lists the Package Deployments for a Device or User Collection. | |
| .NOTES | |
| Created by Ioan Popovici | |
| Part of a report should not be run separately. | |
| .LINK | |
| https://SCCM.Zone/DE-Deployments-by-Device-or-User |
Ioan-Popovici
/ Export-CMStatusMessageStrings.ps1
Last active
July 15, 2019 13:53
Exports SCCM status message localization strings from specified dlls and saves them to a csv file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| .SYNOPSIS | |
| Exports SCCM status message localization strings from dlls. | |
| .DESCRIPTION | |
| Exports SCCM status message localization strings from specified dlls and saves them to a csv file. | |
| .PARAMETER DllList | |
| Specifies the dlls to be processed. | |
| Valid dll names are: 'srvmsgs.dll','provmsgs.dll' and 'climsgs.dll'. | |
| Default is: @('srvmsgs.dll','provmsgs.dll','climsgs.dll'). | |
| .PARAMETER DllPath |
Ioan-Popovici
/ SM Audit Status Messages.sql
Last active
June 8, 2018 21:45
This SQL Query is used to get Audit Status Messages by User or Status Mesage substring.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| ********************************************************************************************************* | |
| * Requires | SQL, Cofiguration Manager DB, Custom Table containig message strings from CM DLL * | |
| * ===================================================================================================== * | |
| * Modified by | Date | Revision | Comments * | |
| * _____________________________________________________________________________________________________ * | |
| * Ioan Popovici | 2018-05-30 | v1.0 | First version * | |
| * ===================================================================================================== * | |
| * * | |
| ********************************************************************************************************* |
Ioan-Popovici
/ CB Configuration Baseline Compliance by Configuration Item with Values.sql
Last active
July 15, 2019 13:52
Gets the Compliance and Actual Values of a Configuration Baseline setting result.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .SYNOPSIS | |
| Gets the Compliance of a Configuration Baseline. | |
| .DESCRIPTION | |
| Gets the Compliance and Actual Values of a Configuration Baseline setting result. | |
| .NOTES | |
| Created by Ioan Popovici | |
| Requires SSRS/SQL, SCCM Configuration Baseline | |
| .LINK | |
| https://SCCM.Zone/CB-Configuration-Baseline-Compliance |
Ioan-Popovici
/ HW BIOS by Manufacturer and Model for Collection.sql
Last active
January 22, 2020 12:58
Gets the Hardware info of a Computer Collection including BIOS version and Computer model.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .SYNOPSIS | |
| Gets the Hardware info of a Computer Collection. | |
| .DESCRIPTION | |
| Gets the Hardware info of a Computer Collection including BIOS version and Computer model. | |
| .NOTES | |
| Created by Ioan Popovici | |
| This query is part of a report should not be run separately. | |
| .LINK | |
| https://SCCM.Zone/HW-BIOS-Manufacturer |
Ioan-Popovici
/ SD Maintenance Windows by Collection and Type.sql
Last active
January 6, 2022 01:41
Lists all SCCM maintenance windows with Start Time and Duration
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .SYNOPSIS | |
| Lists all maintenance windows. | |
| .DESCRIPTION | |
| Lists all SCCM maintenance windows with Start Time and Duration. | |
| .NOTES | |
| Created by Ioan Popovici | |
| Part of a report should not be run separately. | |
| .LINK | |
| https://SCCM.Zone/SIT-Maintenance-Windows |
Ioan-Popovici
/ SU Compliance by Computer Classification and Severity.sql
Last active
September 27, 2019 13:31
Gets the software update compliance in SCCM by computer, classification and severity.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| .SYNOPSIS | |
| Gets the software update compliance in SCCM. | |
| .DESCRIPTION | |
| Gets the software update compliance in SCCM by computer, classification and severity. | |
| .NOTES | |
| Created by Ioan Popovici | |
| Requires ufn_csv_String_Parser custom function. | |
| Part of a report should not be run separately. | |
| .LINK |
Ioan-Popovici
/ Get-RegistryKeyValue.ps1
Created
October 23, 2018 15:46
Gets registry key values for use in a CI as remediation script.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| .SYNOPSIS | |
| Gets registry key values. | |
| .DESCRIPTION | |
| Gets registry key values for use in a CI as remediation script. | |
| .NOTES | |
| Created by | |
| Ioan Popovici 2018-10-23 | |
| #> |