Does anyone have a query to find applications and packages where installation source management has been enabled? This information is on the Windows Installer tab when looking at the Properties for Package Programs and the Programs tab (Product code field) when looking at the Properties of an Application Deployment Type.

I have been through the database multiple times trying to find the table or view that holds this information so I can create this query but can't seem to locate it.

Thank you.

John

I guess you just have to ask and then it shows up - for packages anyway:

SELECT * FROM PkgPrograms_G WHERE LEN(MSIProductID) > 0

I'll keep looking for applications now...

John