If you need info about MRT you can get it by discr...
# macos
f
If you need info about MRT you can get it by discretely calling the plist table with a query like:
Copy code
WITH MRT_info AS (
SELECT * FROM plist WHERE path = '/Library/Apple/System/Library/CoreServices/MRT.app/Contents/Info.plist'
)
SELECT 
MAX(CASE WHEN path = '/Library/Apple/System/Library/CoreServices/MRT.app/Contents/Info.plist' THEN '<http://MRT.app|MRT.app>' END) AS name,
MAX(CASE WHEN path = '/Library/Apple/System/Library/CoreServices/MRT.app/Contents/Info.plist' THEN '/Library/Apple/System/Library/CoreServices/MRT.app' END) AS path,
MAX(CASE WHEN key = 'CFBundleExecutable' THEN value END) AS bundle_executable,
MAX(CASE WHEN key = 'CFBundleIdentifier' THEN value END) AS bundle_identifier,
MAX(CASE WHEN key = 'CFBundleName' THEN value END) AS bundle_name,
MAX(CASE WHEN key = 'CFBundleShortVersionString' THEN value END) AS bundle_short_version,
MAX(CASE WHEN key = 'CFBundleVersion' THEN value END) AS bundle_version,
MAX(CASE WHEN key = 'CFBundlePackageType' THEN value END) AS bundle_package_type,
MAX(CASE WHEN key = 'LSEnvironment' THEN value END) AS environment,
MAX(CASE WHEN key = 'LSUIElement' THEN value END) AS element,
MAX(CASE WHEN key = 'DTCompiler' THEN value END) AS compiler,
MAX(CASE WHEN key = 'CFBundleDevelopmentRegion' THEN value END) AS development_region,
MAX(CASE WHEN key = 'CFBundleDisplayName' THEN value END) AS display_name,
MAX(CASE WHEN key = 'CFBundleGetInfoString' THEN value END) AS info_string,
MAX(CASE WHEN key = 'LSMinimumSystemVersion' THEN value END) AS minimum_system_version,
MAX(CASE WHEN key = 'LSApplicationCategoryType' THEN value END) AS category,
MAX(CASE WHEN key = 'NSAppleScriptEnabled' THEN value END) AS applescript_enabled,
MAX(CASE WHEN key = 'NSHumanReadableCopyright' THEN value END) AS copyright,
MAX(CASE WHEN key = '-- not_available' THEN value END) AS last_opened_time
FROM MRT_info GROUP BY path;

                  name = <http://MRT.app|MRT.app>
                  path = /Library/Apple/System/Library/CoreServices/MRT.app
     bundle_executable = MRT
     bundle_identifier = com.apple.MRT
           bundle_name = MRT
  bundle_short_version = 1.52
        bundle_version = 1
   bundle_package_type = APPL
           environment = 
               element = 1
              compiler = com.apple.compilers.llvm.clang.1_0
    development_region = en
          display_name = 
           info_string = 
minimum_system_version = 10.10
              category = 
   applescript_enabled = 
             copyright = Copyright © 2018 Apple, Inc. All rights reserved.
      last_opened_time =