We developed (formerly for the internal documentation purposes and for MSI internals demonstration as the database) a new tool - called "Windows Installer Query Tool" based on WIX Deployment Tools Foundation. Now freeware.
It allows to run SQL queries to MSI databases from the MS Excel 2007-2010 sheet via Ribbon user interface. Powerful filtering functionality allows to apply regular expressions and basic filters to the output results.
For instance - we used it for MSI validation and documenting - easy to get file lists or list of components with the condition.
Also it helps to collect these SQL queries and regular expressions in the sheet to keep yourself organized.
I need your feedback about this tool usability and improvement suggestions.
Queries examples are also needed - will include them in the next versions.
Direct download: http://files.demo.su/wiqt/wiqt_155
Home and more info: http://www.demo.su
No promotions or commercials - this is pure research!
Edited by Server, 26 May 2011 - 07:32.