macOS .apps directory name leak into software titles

[lucasmrod]

Fleet version: v4.59.1 (probably previous versions too)

---

If a user (or the system, e.g. downloading an .app twice on the ~/Downloads folder) has renamed an application .app folder, this new name of the folder can end up as the "Software Title" for the corresponding bundle identifier.

See below for steps to reproduce.

💥  Actual behavior

A user or the system renaming an .app folder should not end up in the software title.

🧑‍💻  Steps to reproduce

0. Have macOS host A rename its /Applications/Google Chrome.app to /Applications/Google Chrome 2.app
1. Enroll a macOS host A to Fleet.
2. Software title for host A's Google Chrome will be Google Chrome 2.app.
3. Enroll a macOS host B to Fleet with Chrome installed (but no renaming).
4. Host B software tab will show Google Chrome 2.app as the software title for the installed Google Chrome version (which is not correct).

Data from customer

• ~450 titles are reported with the 2.app suffix (out of 50k titles).
• We are not sure how the devices end up with the 2.app suffixes but it's happening and causing software titles to be invalid.

🕯️ More info (optional)

• osquery's apps.name uses the directory name and Fleet uses such field to populate the Fleet software "name". Consider using bundle_name, bundle_executable and display_name.
• Software title should also include the software name in its unique index, not just bundle_identifier.

Related issue: #22994