why?
```
osquery> select * from signature where...
# generalt
theopolis
09/01/2016, 1:09 AM
why?
Copy code
osquery> select * from signature where path in (select path from apps where path like '%/Transmission.app' or path = '/Applications/Transmission.app');
+----------------------------------------+--------+----------------------+------------------------------------------+-----------------+------------------------------------------------+
| path | signed | identifier | cdhash | team_identifier | authority |
+----------------------------------------+--------+----------------------+------------------------------------------+-----------------+------------------------------------------------+
| /Users/reed/Downloads/Transmission.app | 1 | org.m0k.transmission | a68d09161742573b09a17b8aef05f918a1cebcac | 5DPYRBHEAR | Developer ID Application: Digital Ignition LLC |
| /Volumes/Transmission/Transmission.app | 1 | org.m0k.transmission | a68d09161742573b09a17b8aef05f918a1cebcac | 5DPYRBHEAR | Developer ID Application: Digital Ignition LLC |
+----------------------------------------+--------+----------------------+------------------------------------------+-----------------+------------------------------------------------+
osquery>2 Views