pvl_winget_audit

Purpose

This document stores the audit data fetched by the Winget App Audit script.

Column	Type	Explanation
computerid	int	Computer ID of the computer.
displayName	varchar	Display name of the application.
packageId	varchar	Package ID of the application.
InstalledVersion	varchar	Installed version of the application.
AvailableVersion	varchar	Latest available version of the application, if any.
Source	varchar	Source of the application (Winget/Msstore).
UptoDate	tinytext	Is the application up to date? (0/1)
Level	varchar	Installation level of the application (System/User).
AutoUpdateEnabled	tinytext	Is Auto Update enabled for the application? (0/1). Refer to the Configure Winget Auto Update script's document for detailed instructions on enabling Auto Update.
DataCollectionTime	datetime	Data collection time.