README

Reports on macOS mobile configuration profile information

Collects information about installed profiles by querying the /usr/bin/profiles command

Table Schema

• id - Unique ID
• serial_number - varchar(255) - Serial Number
• profile_uuid - varchar(255) - UUID
• profile_name - varchar(255) - Name
• profile_removal_allowed - varchar(255) - Yes or No
• payload_name - varchar(255) - Payload Name
• payload_display - varchar(255) - Payload Display Name
• payload_data - mediumtext - Payload Data
• timestamp - bigint - Unix timestamp when the report was uploaded
• profile_install_date - bigint - Unix timestamp when the profile was installed
• profile_organization - varchar(255) - Organization of the profile
• profile_verification_state - varchar(255) - Profile's verification state
• user - varchar(255) - User that the profile belongs to
• profile_description - mediumtext - Profile's description
• profile_method - varchar(255) - If profile is emulated MCX or native mobile configuration profile