Ioan Popovici Ioan-Popovici
Ioan-Popovici
/ ufn_GetCompany_by_ResourceID.sql
Last active
September 27, 2019 14:55
Gets the Machine Company by ResourceID using Machine FQDN or OU.
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
| /* | |
| ********************************************************************************************************* | |
| * Created by Ioan Popovici, 2015-08-18 | Requirements: CM_Tools Database * | |
| * ======================================================================================================* | |
| * Modified by | Date | Revision | Comments * | |
| *_______________________________________________________________________________________________________* | |
| * Ioan Popovici | 2015-08-18 | v1.0 | First version * | |
| *-------------------------------------------------------------------------------------------------------* | |
| * Credit to: Michelle Ufford http://sqlfool.com. * | |
| ********************************************************************************************************* |
Ioan-Popovici
/ Update-OfflineWindowsImage.ps1
Last active
January 4, 2019 20:52
Injects packages into a Windows Image image using PowerShell DISM CommandLets.
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 | |
| Injects packages into a WIM. | |
| .DESCRIPTION | |
| Injects packages into a Windows Image image using PowerShell DISM CommandLets. | |
| .EXAMPLE | |
| Update-OfflineWindowsImage.ps1 | |
| .NOTES | |
| Created by Ioan Popovici | |
| Requirements |
Ioan-Popovici
/ Repair-ServicingError_800f082f.ps1
Last active
May 31, 2025 15:52
Repairs error 0x800f082f~ encountered during offline servicing by setting the
HKLM:\Microsoft\Windows\CurrentVersion\Component Based Servicing\SessionsPending\Exclusive value to 0.
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 | |
| Repairs error 0x800f082f~ encountered during offline servicing. | |
| .DESCRIPTION | |
| Repairs error 0x800f082f~ encountered during offline servicing by setting the | |
| HKLM:\Microsoft\Windows\CurrentVersion\Component Based Servicing\SessionsPending\Exclusive value to 0. | |
| .INPUTS | |
| None. | |
| .OUTPUTS | |
| None. |
Ioan-Popovici
/ Test-TCPPorts.ps1
Last active
January 4, 2019 20:03
Tests network conectivity on TCP ports on specific domains.
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 | |
| Tests network conectivity on TCP ports. | |
| .DESCRIPTION | |
| Tests network conectivity on TCP ports on specific domains. | |
| .EXAMPLE | |
| Test-TCPPorts.ps1 | |
| .INPUTS | |
| System.String. | |
| .OUTPUTS |
Ioan-Popovici
/ Get-BitlockerStatus.ps1
Last active
February 22, 2019 10:43
Gets the BitLocker protection status for a specific drive, or all drives.
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 BitLocker protection status. | |
| .DESCRIPTION | |
| Gets the BitLocker protection status for a specific drive, or all drives. | |
| .PARAMETER DriveType | |
| Specifies the drive type(s) for which to get the bitlocker status. Default is: '3'. | |
| Available values | |
| 0 DRIVE_UNKNOWN | |
| 1 DRIVE_NO_ROOT_DIR |
Ioan-Popovici
/ Select-Certificate.ps1
Last active
January 4, 2019 17:27
Selects a certificate in a specified certificate store using the certificate Serial Number.
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 | |
| Selects a certificate in the certificate store. | |
| .DESCRIPTION | |
| Selects a certificate in a specified certificate store using the certificate Serial Number. | |
| .EXAMPLE | |
| Select-Certificate.ps1 | |
| .NOTES | |
| Created by Ioan Popovici | |
| .LINK |
Ioan-Popovici
/ Add-Certificate.ps1
Last active
July 27, 2021 17:29
Adds a certificate to the certificate store using the certificate key in base64 format.
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 | |
| Adds a certificate to the certificate store. | |
| .DESCRIPTION | |
| Adds a certificate to the certificate store using the certificate key in base64 format. | |
| .EXAMPLE | |
| Add-Certificate.ps1 | |
| .INPUTS | |
| None. | |
| .OUTPUTS |
Ioan-Popovici
/ SQL_Classes.mof
Last active
July 14, 2023 10:28
HWI DEF SQL Classes for SQL Product Reporting
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
| //====================================================== | |
| //---------------| SQL definition start |--------------- | |
| //====================================================== | |
| /* | |
| .SYNOPSIS | |
| Extends Configuration Manager HWI for SQL Products. | |
| .DESCRIPTION | |
| Extends Configuration Manager HWI for SQL Products, by adding already created classes to Hardware Inventory. | |
| .NOTES |
Ioan-Popovici
/ SQ-SQL_Server_Products.sql
Last active
July 14, 2023 10:33
Gets SQL Service Pack and Cumulative Update version information.
Requires SCCM HWI Extension
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 SQL product info. | |
| .DESCRIPTION | |
| Gets SQL product info, id and product key. | |
| .NOTES | |
| Created by Ioan Popovici. | |
| Requires the usp_PivotWithDynamicColumns stored procedure (SQL Support Functions). | |
| Requires SQL Property and ProductID HWI extensions. | |
| Part of a report should not be run separately. |
Ioan-Popovici
/ HW BIOS by Company and Manufacturer for Collection.sql
Last active
January 17, 2023 06:41
This SQL Query is used to get 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
| /* | |
| ********************************************************************************************************* | |
| * Requires | SQL, company AD attribute, Wi32_Computer_System_Product WMI class gathering * | |
| * ===================================================================================================== * | |
| * Modified by | Date | Revision | Comments * | |
| * _____________________________________________________________________________________________________ * | |
| * Octavian Cordos | 2018-01-18 | v1.0 | First version * | |
| * Ioan Popovici | 2018-08-08 | v1.1 | Added localizations, sorting, template, element naming * | |
| * Ioan Popovici | 2018-08-21 | v1.2 | Fixed duplicates minor formating fixes * | |
| * Ioan Popovici | 2018-08-23 | v1.3 | Removed company query * |