Attention

Zercurity has been acquired by JumpCloud.

This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.

https://jumpcloud.com/press/jumpcloud-acquires-zercurity

mdls

Query file metadata in the Spotlight database.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: mdls

• Mac OSX

Table schema

Name	Type	Description
path	TEXT	Path of the file
key	TEXT	Name of the metadata key
value	TEXT	Value stored in the metadata key
valuetype	TEXT	CoreFoundation type of data stored in value

Query examples

select * from mdls where path = '/Users/testuser/Desktop/testfile';