Winget App Audit
Summary
The script conducts an audit of the computer for applications supported by Winget and stores the information in a custom table called pvl_winget_audit. It retrieves data for both system-level and user-level applications. However, user-level application data will not be retrieved if there are no logged-in users on the computer.
File Hash
File Path: C:\ProgramData\_automation\Script\Get-WingetReport\Get-WingetReport.ps1
File Hash (Sha256): 0ECF004A270D0EABCB0D89FC9C05CF027709AE541E9D53DC894E309041344B12
File Hash (MD5): 26D327FAD52EB73F7AD28A2B72E24ECB
File Path: C:\ProgramData\_automation\Script\Get-WingetReport\Manage-OverFlowedVariable.ps1
File Hash (Sha256): 79B76E6780B61ED657C7FC07C5C0D9A0662165066D5BAD95D9D672513BADD674
File Hash (MD5): 12B41CDBC04010E638D3FFB8A4BDB1D6
Update Notice: 02-April-2025
A new column has been introduced to pvl_winget_audit table. To update the table's structure, run the script with the Set_Environment parameter set to 1 after importing it.
Sample Run
First Run: Run the script with the Set_Environment parameter set to 1 for the first run to create the pvl_winget_audit table used by the solution.
Regular Execution:
Dependencies
- Internal Monitor - Execute Script - Winget App Audit
- Script - OverFlowedVariable - SQL Insert - Execute
- Solution - Winget Auto Update
Global Variables
| Name | Value | Accepted Values | Description |
|---|---|---|---|
| Debug | False | False, True | When True, enables informational logging; when False (default), informational logs are suppressed to avoid adding entries to the h_scripts table. Set to True to assist with troubleshooting. |
| ScriptEngineEnableLogger | False | False, True | When True, enables final (success/failure) logging; when False (default), these logs are suppressed to avoid adding entries to the h_scripts table. Set to True to assist with troubleshooting. |
Variables
| Name | Description |
|---|---|
| projectName | Get-WingetReport |
| workingDirectory | C:\ProgramData_automation\script\Get-WingetReport |
| scriptPath | C:\ProgramData_automation\script\Get-WingetReport\Get-WingetReport.ps1 |
| jsonPath | C:\ProgramData_automation\script\Get-WingetReport\Get-WingetReport.json |
| tableName | pvl_winget_audit |
User Parameters
| Name | Example | Required | Description |
|---|---|---|---|
| Set_Environment | 1 | True (for first execution) | Run the script with the Set_Environment parameter set to 1 for the first run to create the pvl_winget_audit table used by the solution. |
Output
- Script log
- Custom table
- Dataview