package_receipts

OS X package receipt details.

Table schema

Name Type Description
package_id TEXT Package domain identifier
package_filename TEXT Filename of original .pkg file
version TEXT Installed package version
location TEXT Optional relative install path on volume
install_time DOUBLE Timestamp of install time
installer_name TEXT Name of installer process
path TEXT Path of receipt plist

Query examples

select * from package_bom where path = '/var/db/receipts/com.apple.pkg.MobileDevice.bom'