Skip to content

Instantly share code, notes, and snippets.

@jby
Created November 3, 2021 07:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jby/5edb9e0e4a2d37cae3b0cdf1b5771577 to your computer and use it in GitHub Desktop.
Save jby/5edb9e0e4a2d37cae3b0cdf1b5771577 to your computer and use it in GitHub Desktop.
Using MunkiReport Version of Migrate
Migration table created successfully.
Migrating: 0100_00_00_000001_timemachine_schema_v1
Migrated: 0100_00_00_000001_timemachine_schema_v1 (0 seconds)
Migrating: 0213_00_00_000001_add_columns_for_pmset_data
Migrated: 0213_00_00_000001_add_columns_for_pmset_data (0 seconds)
Migrating: 0213_00_00_000001_add_dsconfigad_data
Migrated: 0213_00_00_000001_add_dsconfigad_data (0 seconds)
Migrating: 0213_00_00_000001_add_filevault_users
Migrated: 0213_00_00_000001_add_filevault_users (0 seconds)
Migrating: 0213_00_00_000001_cleanup_hash_table
Migrated: 0213_00_00_000001_cleanup_hash_table (0 seconds)
Migrating: 0213_00_00_000001_convert_physical_memory
Migrated: 0213_00_00_000001_convert_physical_memory (0 seconds)
Migrating: 0213_00_00_000001_installhistory_fix_indexes
Migrated: 0213_00_00_000001_installhistory_fix_indexes (0 seconds)
Migrating: 0213_00_00_000001_inventoryitem_fix_indexes
Migrated: 0213_00_00_000001_inventoryitem_fix_indexes (0 seconds)
Migrating: 0213_00_00_000001_location_stale_location_columns
Migrated: 0213_00_00_000001_location_stale_location_columns (0 seconds)
Migrating: 0213_00_00_000001_multiple_disks_addition
Migrated: 0213_00_00_000001_multiple_disks_addition (0 seconds)
Migrating: 0213_00_00_000001_munkireport_add_unique_index
Migrated: 0213_00_00_000001_munkireport_add_unique_index (0 seconds)
Migrating: 0213_00_00_000001_network_model_fix_ipv4router
Migrated: 0213_00_00_000001_network_model_fix_ipv4router (0 seconds)
Migrating: 0213_00_00_000001_printer_fix_indexes
Migrated: 0213_00_00_000001_printer_fix_indexes (0 seconds)
Migrating: 0213_00_00_000001_reportdata_fix_indexes
Migrated: 0213_00_00_000001_reportdata_fix_indexes (0 seconds)
Migrating: 0213_00_00_000001_security_add_ssh
Migrated: 0213_00_00_000001_security_add_ssh (0 seconds)
Migrating: 0213_00_00_000002_directory_service_fix_indexes
Migrated: 0213_00_00_000002_directory_service_fix_indexes (0 seconds)
Migrating: 0213_00_00_000002_disk_report_fix_indexes
Migrated: 0213_00_00_000002_disk_report_fix_indexes (0 seconds)
Migrating: 0213_00_00_000002_filevault_status_fix_indexes
Migrated: 0213_00_00_000002_filevault_status_fix_indexes (0 seconds)
Migrating: 0213_00_00_000002_inventoryitem_rename_serialcolumn
Migrated: 0213_00_00_000002_inventoryitem_rename_serialcolumn (0 seconds)
Migrating: 0213_00_00_000002_machine_add_indexes
Migrated: 0213_00_00_000002_machine_add_indexes (0 seconds)
Migrating: 0213_00_00_000002_munkireport_fix_indexes
Migrated: 0213_00_00_000002_munkireport_fix_indexes (0 seconds)
Migrating: 0213_00_00_000002_network_fix_indexes
Migrated: 0213_00_00_000002_network_fix_indexes (0 seconds)
Migrating: 0213_00_00_000002_reportdata_add_uptime
Migrated: 0213_00_00_000002_reportdata_add_uptime (0 seconds)
Migrating: 0213_00_00_000002_security_add_ard
Migrated: 0213_00_00_000002_security_add_ard (0 seconds)
Migrating: 0213_00_00_000003_inventoryitem_max_pathlength
Migrated: 0213_00_00_000003_inventoryitem_max_pathlength (0 seconds)
Migrating: 0213_00_00_000003_machine_add_cpu
Migrated: 0213_00_00_000003_machine_add_cpu (0 seconds)
Migrating: 0213_00_00_000003_munkireport_bigger_blob
Migrated: 0213_00_00_000003_munkireport_bigger_blob (0 seconds)
Migrating: 0213_00_00_000003_reportdata_add_group
Migrated: 0213_00_00_000003_reportdata_add_group (0 seconds)
Migrating: 0213_00_00_000003_security_add_firmwarepw
Migrated: 0213_00_00_000003_security_add_firmwarepw (0 seconds)
Migrating: 0213_00_00_000004_machine_osversion_integer
Migrated: 0213_00_00_000004_machine_osversion_integer (0 seconds)
Migrating: 0213_00_00_000004_munkireport_new
Migrated: 0213_00_00_000004_munkireport_new (0 seconds)
Migrating: 0213_00_00_000004_security_add_indexes
Migrated: 0213_00_00_000004_security_add_indexes (0 seconds)
Migrating: 0213_00_00_000005_machine_add_buildversion
Migrated: 0213_00_00_000005_machine_add_buildversion (0 seconds)
Migrating: 0215_00_00_000001_certificate_add_columns
Migrated: 0215_00_00_000001_certificate_add_columns (0 seconds)
Migrating: 0215_00_00_000002_certificate_bigint_cert_exp_time
Migrated: 0215_00_00_000002_certificate_bigint_cert_exp_time (0 seconds)
Migrating: 0215_00_00_000002_power_fix_indexes
Migrated: 0215_00_00_000002_power_fix_indexes (0 seconds)
Migrating: 0215_00_00_000002_timemachine_remove_fake_null
Migrated: 0215_00_00_000002_timemachine_remove_fake_null (0 seconds)
Migrating: 0215_00_00_000003_disk_report_add_media_type
Migrated: 0215_00_00_000003_disk_report_add_media_type (0 seconds)
Migrating: 0215_00_00_000003_power_remove_fake_null
Migrated: 0215_00_00_000003_power_remove_fake_null (0 seconds)
Migrating: 0215_00_00_000004_power_schedule_text
Migrated: 0215_00_00_000004_power_schedule_text (0 seconds)
Migrating: 0215_00_00_000005_security_add_firewall_state
Migrated: 0215_00_00_000005_security_add_firewall_state (0 seconds)
Migrating: 1000_00_00_000001_extensions_php_migrations
Migrated: 1000_00_00_000001_extensions_php_migrations (0 seconds)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated: 2014_10_12_100000_create_password_resets_table (0 seconds)
Migrating: 2017_02_09_234100_ard
Migrated: 2017_02_09_234100_ard (0 seconds)
Migrating: 2017_02_09_234110_backup2go
Migrated: 2017_02_09_234110_backup2go (0 seconds)
Migrating: 2017_02_09_234136_certificate
Migrated: 2017_02_09_234136_certificate (0 seconds)
Migrating: 2017_02_09_234207_crashplan
Migrated: 2017_02_09_234207_crashplan (0 seconds)
Migrating: 2017_02_09_234232_directoryservice
Migrated: 2017_02_09_234232_directoryservice (0 seconds)
Migrating: 2017_02_09_234243_diskreport
Migrated: 2017_02_09_234243_diskreport (0 seconds)
Migrating: 2017_02_09_234251_displays
Migrated: 2017_02_09_234251_displays (0.01 seconds)
Migrating: 2017_02_09_234311_filevault_status
Migrated: 2017_02_09_234311_filevault_status (0 seconds)
Migrating: 2017_02_09_234321_findmymac
Migrated: 2017_02_09_234321_findmymac (0.01 seconds)
Migrating: 2017_02_09_234335_inventoryitem
Migrated: 2017_02_09_234335_inventoryitem (0 seconds)
Migrating: 2017_02_09_234352_location
Migrated: 2017_02_09_234352_location (0 seconds)
Migrating: 2017_02_09_234358_machine
Migrated: 2017_02_09_234358_machine (0.02 seconds)
Migrating: 2017_02_09_234433_managedinstalls
Migrated: 2017_02_09_234433_managedinstalls (0.01 seconds)
Migrating: 2017_02_09_234611_munkiinfo
Migrated: 2017_02_09_234611_munkiinfo (0 seconds)
Migrating: 2017_02_09_234619_munkireport
Migrated: 2017_02_09_234619_munkireport (0.01 seconds)
Migrating: 2017_02_09_234656_network
Migrated: 2017_02_09_234656_network (0.01 seconds)
Migrating: 2017_02_09_234916_profile
Migrated: 2017_02_09_234916_profile (0 seconds)
Migrating: 2017_02_09_234923_reportdata
Migrated: 2017_02_09_234923_reportdata (0.01 seconds)
Migrating: 2017_02_09_234931_sccm_status
Migrated: 2017_02_09_234931_sccm_status (0.01 seconds)
Migrating: 2017_02_09_234938_security
Migrated: 2017_02_09_234938_security (0.01 seconds)
Migrating: 2017_02_09_234959_warranty
Migrated: 2017_02_09_234959_warranty (0 seconds)
Migrating: 2017_02_09_235003_wifi
Migrated: 2017_02_09_235003_wifi (0 seconds)
Migrating: 2017_02_11_074454_event
Migrated: 2017_02_11_074454_event (0 seconds)
Migrating: 2017_02_12_012330_comment
Migrated: 2017_02_12_012330_comment (0 seconds)
Migrating: 2017_02_12_235252_hash
Migrated: 2017_02_12_235252_hash (0 seconds)
Migrating: 2017_02_14_091413_installhistory
Migrated: 2017_02_14_091413_installhistory (0 seconds)
Migrating: 2017_02_20_085316_machine_group
Migrated: 2017_02_20_085316_machine_group (0 seconds)
Migrating: 2017_11_29_000001_extensions
Migrated: 2017_11_29_000001_extensions (0.01 seconds)
Migrating: 2017_12_17_0000001_devtools
Migrated: 2017_12_17_0000001_devtools (0.01 seconds)
Migrating: 2017_12_17_0000001_supported_os
Migrated: 2017_12_17_0000001_supported_os (0 seconds)
Migrating: 2017_12_18_132621_user_sessions
Migrated: 2017_12_18_132621_user_sessions (0 seconds)
Migrating: 2017_12_18_173230_business_unit
Migrated: 2017_12_18_173230_business_unit (0 seconds)
Migrating: 2017_12_18_211801_appusage
Migrated: 2017_12_18_211801_appusage (0.01 seconds)
Migrating: 2017_12_18_211802_caching
Migrated: 2017_12_18_211802_caching (0.01 seconds)
Migrating: 2017_12_18_211803_fan_temps
Migrated: 2017_12_18_211803_fan_temps (0.05 seconds)
Migrating: 2017_12_18_220830_tag
Migrated: 2017_12_18_220830_tag (0 seconds)
Migrating: 2017_12_19_172407_munki_facts
Migrated: 2017_12_19_172407_munki_facts (0 seconds)
Migrating: 2017_12_19_193501_usb
Migrated: 2017_12_19_193501_usb (0.01 seconds)
Migrating: 2017_12_19_193803_filevault_escrow
Migrated: 2017_12_19_193803_filevault_escrow (0.01 seconds)
Migrating: 2017_12_19_193901_homebrew_info
Migrated: 2017_12_19_193901_homebrew_info (0.02 seconds)
Migrating: 2017_12_19_194601_firmware_escrow
Migrated: 2017_12_19_194601_firmware_escrow (0 seconds)
Migrating: 2017_12_19_195001_fonts
Migrated: 2017_12_19_195001_fonts (0.01 seconds)
Migrating: 2017_12_19_195401_network_shares
Migrated: 2017_12_19_195401_network_shares (0 seconds)
Migrating: 2017_12_19_195801_smart_stats
Migrated: 2017_12_19_195801_smart_stats (0.02 seconds)
Migrating: 2017_12_19_200401_softwareupdate
Migrated: 2017_12_19_200401_softwareupdate (0.01 seconds)
Migrating: 2017_12_19_201201_gpu
Migrated: 2017_12_19_201201_gpu (0.01 seconds)
Migrating: 2017_12_19_201501_mbbr_status
Migrated: 2017_12_19_201501_mbbr_status (0 seconds)
Migrating: 2017_12_19_201801_munkireportinfo
Migrated: 2017_12_19_201801_munkireportinfo (0 seconds)
Migrating: 2017_12_19_234707_printer
Migrated: 2017_12_19_234707_printer (0.01 seconds)
Migrating: 2017_12_20_142858_detectx
Migrated: 2017_12_20_142858_detectx (0 seconds)
Migrating: 2017_12_22_143049_usage_stats
Migrated: 2017_12_22_143049_usage_stats (0.03 seconds)
Migrating: 2017_12_23_223838_homebrew
Migrated: 2017_12_23_223838_homebrew (0.01 seconds)
Migrating: 2017_12_23_230338_power
Migrated: 2017_12_23_230338_power (0.05 seconds)
Migrating: 2017_12_24_085405_applications
Migrated: 2017_12_24_085405_applications (0.01 seconds)
Migrating: 2018_01_01_234951_timemachine
Migrated: 2018_01_01_234951_timemachine (0.02 seconds)
Migrating: 2018_02_06_000001_mdm_status_initialize
Migrated: 2018_02_06_000001_mdm_status_initialize (0 seconds)
Migrating: 2018_02_08_000001_caching_high_sierria
Migrated: 2018_02_08_000001_caching_high_sierria (0.1 seconds)
Migrating: 2018_02_08_000001_fan_temps_add_smc_columns
Migrated: 2018_02_08_000001_fan_temps_add_smc_columns (0.8 seconds)
Migrating: 2018_02_08_000001_smart_stats_drop_extra_nvme_columns
Migrated: 2018_02_08_000001_smart_stats_drop_extra_nvme_columns (0.11 seconds)
Migrating: 2018_02_08_000001_timemachine_apfs_snapshots
Migrated: 2018_02_08_000001_timemachine_apfs_snapshots (0 seconds)
Migrating: 2018_02_08_000001_usage_stats_fix_column_types
Migrated: 2018_02_08_000001_usage_stats_fix_column_types (0.04 seconds)
Migrating: 2018_02_09_165033_wifi_fix_nullable_columns
Migrated: 2018_02_09_165033_wifi_fix_nullable_columns (0.01 seconds)
Migrating: 2018_02_09_165342_power_fix_nullable_columns
Migrated: 2018_02_09_165342_power_fix_nullable_columns (0.09 seconds)
Migrating: 2018_02_12_162424_security_add_ssh_groups
Migrated: 2018_02_12_162424_security_add_ssh_groups (0 seconds)
Migrating: 2018_02_12_164431_extensions_add_teamid
Migrated: 2018_02_12_164431_extensions_add_teamid (0.02 seconds)
Migrating: 2018_02_14_215000_tag_add_index
Migrated: 2018_02_14_215000_tag_add_index (0 seconds)
Migrating: 2018_02_14_215734_usb_add_index
Migrated: 2018_02_14_215734_usb_add_index (0 seconds)
Migrating: 2018_02_14_220729_fonts_add_index
Migrated: 2018_02_14_220729_fonts_add_index (0 seconds)
Migrating: 2018_02_14_221501_network_shares_add_index
Migrated: 2018_02_14_221501_network_shares_add_index (0 seconds)
Migrating: 2018_02_14_222918_homebrew_add_index
Migrated: 2018_02_14_222918_homebrew_add_index (0 seconds)
Migrating: 2018_02_20_000001_network_add_dns
Migrated: 2018_02_20_000001_network_add_dns (0.03 seconds)
Migrating: 2018_03_12_000001_certificate_null_columns
Migrated: 2018_03_12_000001_certificate_null_columns (0.01 seconds)
Migrating: 2018_03_12_165507_filevault_escrow_encrypt_plaintext_keys
Migrated: 2018_03_12_165507_filevault_escrow_encrypt_plaintext_keys (0 seconds)
Migrating: 2018_04_11_000001_gpu_add_metal
Migrated: 2018_04_11_000001_gpu_add_metal (0 seconds)
Migrating: 2018_04_12_000001_displays_info_add_extended_columns
Migrated: 2018_04_12_000001_displays_info_add_extended_columns (0.11 seconds)
Migrating: 2018_04_12_055955_user_sessions_add_user_uid
Migrated: 2018_04_12_055955_user_sessions_add_user_uid (0 seconds)
Migrating: 2018_04_12_064804_reportdata_add_uid
Migrated: 2018_04_12_064804_reportdata_add_uid (0 seconds)
Migrating: 2018_04_15_042618_directory_service_add_bound_column
Migrated: 2018_04_15_042618_directory_service_add_bound_column (0 seconds)
Migrating: 2018_04_28_162424_sentinelone
Migrated: 2018_04_28_162424_sentinelone (0.01 seconds)
Migrating: 2018_05_03_152424_sentinelone_add_quarantine_files
Migrated: 2018_05_03_152424_sentinelone_add_quarantine_files (0 seconds)
Migrating: 2018_06_09_115534_Sophos
Migrated: 2018_06_09_115534_Sophos (0.01 seconds)
Migrating: 2018_07_03_162424_security_add_ard_groups
Migrated: 2018_07_03_162424_security_add_ard_groups (0 seconds)
Migrating: 2018_07_27_0000001_ibridge
Migrated: 2018_07_27_0000001_ibridge (0.01 seconds)
Migrating: 2018_07_31_000001_laps
Migrated: 2018_07_31_000001_laps (0.01 seconds)
Migrating: 2018_08_17_094300_detectx_add_statuscolumns
Migrated: 2018_08_17_094300_detectx_add_statuscolumns (0.01 seconds)
Migrating: 2018_11_14_000001_laps_audits
Migrated: 2018_11_14_000001_laps_audits (0 seconds)
Migrating: 2019_01_09_165546_security_root_user
Migrated: 2019_01_09_165546_security_root_user (0 seconds)
Migrating: 2019_02_07_000001_filevault_status_add_more_columns
Migrated: 2019_02_07_000001_filevault_status_add_more_columns (0.11 seconds)
Migrating: 2019_02_11_144341_ibridge_add_version_column
Migrated: 2019_02_11_144341_ibridge_add_version_column (0 seconds)
Migrating: 2019_02_22_000001_softwareupdate_rewrite_columns
Migrated: 2019_02_22_000001_softwareupdate_rewrite_columns (0.08 seconds)
Migrating: 2019_02_28_000001_printer_add_rewrite_columns
Migrated: 2019_02_28_000001_printer_add_rewrite_columns (0.11 seconds)
Migrating: 2019_03_04_000001_ard_rewrite_columns
Migrated: 2019_03_04_000001_ard_rewrite_columns (0.05 seconds)
Migrating: 2019_03_05_000001_wifi_rewrite_columns
Migrated: 2019_03_05_000001_wifi_rewrite_columns (0.02 seconds)
Migrating: 2019_03_11_000003_fan_temps_json_rewrite
Migrated: 2019_03_11_000003_fan_temps_json_rewrite (0.06 seconds)
Migrating: 2019_03_18_000001_network_rewrite
Migrated: 2019_03_18_000001_network_rewrite (0.12 seconds)
Migrating: 2019_05_01_000004_fan_temps_fix_column
Migrated: 2019_05_01_000004_fan_temps_fix_column (0.07 seconds)
Migrating: 2019_06_14_0000001_firewall
Migrated: 2019_06_14_0000001_firewall (0.01 seconds)
Migrating: 2019_08_19_000000_create_failed_jobs_table
Migrated: 2019_08_19_000000_create_failed_jobs_table (0 seconds)
Migrating: 2019_12_14_000001_create_personal_access_tokens_table
Migrated: 2019_12_14_000001_create_personal_access_tokens_table (0 seconds)
Migrating: 2020_01_31_000001_security_add_secureboot_externalboot
Migrated: 2020_01_31_000001_security_add_secureboot_externalboot (0.01 seconds)
Migrating: 2020_03_12_000001_bluetooth_rewrite
Migrated: 2020_03_12_000001_bluetooth_rewrite (0.02 seconds)
Migrating: 2020_03_18_000001_add_mdm_server_url
Migrated: 2020_03_18_000001_add_mdm_server_url (0 seconds)
Migrating: 2020_04_07_165557_reportdata_add_status_column
Migrated: 2020_04_07_165557_reportdata_add_status_column (0 seconds)
Migrating: 2020_05_09_194246_cache_init
Migrated: 2020_05_09_194246_cache_init (0 seconds)
Migrating: 2020_05_10_000001_supported_os_cache
Migrated: 2020_05_10_000001_supported_os_cache (0 seconds)
Migrating: 2020_05_15_000001_munkireportinfo_logs
Migrated: 2020_05_15_000001_munkireportinfo_logs (0.03 seconds)
Migrating: 2020_06_26_000001_munkireportinfo_log_sizes
Migrated: 2020_06_26_000001_munkireportinfo_log_sizes (0.01 seconds)
Migrating: 2020_06_28_000000_create_users_table
Migrated: 2020_06_28_000000_create_users_table (0 seconds)
Migrating: 2020_07_14_000001_ibridge_more_data
Migrated: 2020_07_14_000001_ibridge_more_data (0.02 seconds)
Migrating: 2020_08_14_101052_create_business_units
Migrated: 2020_08_14_101052_create_business_units (0 seconds)
Migrating: 2020_08_14_101102_create_machine_groups
Migrated: 2020_08_14_101102_create_machine_groups (0 seconds)
Migrating: 2020_08_14_101634_create_business_unit_users
Migrated: 2020_08_14_101634_create_business_unit_users (0 seconds)
Migrating: 2020_10_21_000001_filevault_status_add_bootstrap_columns
Migrated: 2020_10_21_000001_filevault_status_add_bootstrap_columns (0.01 seconds)
Migrating: 2021_02_11_080139_gpu_add_num_cores
Migrated: 2021_02_11_080139_gpu_add_num_cores (0 seconds)
Migrating: 2021_02_26_000001_applications_add_bundle_version
Migrated: 2021_02_26_000001_applications_add_bundle_version (0 seconds)
Migrating: 2021_02_27_000001_devtools_add_ipados
Migrated: 2021_02_27_000001_devtools_add_ipados (0.01 seconds)
Migrating: 2021_03_30_095959_create_users_contact_methods
Migrated: 2021_03_30_095959_create_users_contact_methods (0 seconds)
Migrating: 2021_03_30_105249_create_notifications_table
Migrated: 2021_03_30_105249_create_notifications_table (0 seconds)
Migrating: 2021_03_30_114237_add_users_locale_column
Migrated: 2021_03_30_114237_add_users_locale_column (0 seconds)
Migrating: 2021_03_31_000001_power_big_sur_columns
Migrated: 2021_03_31_000001_power_big_sur_columns (0.02 seconds)
Migrating: 2021_04_19_000001_power_adapter_details
Migrated: 2021_04_19_000001_power_adapter_details (0.01 seconds)
Migrating: 2021_04_2_000001_findmymac_more_columns
Migrated: 2021_04_2_000001_findmymac_more_columns (0 seconds)
Migrating: 2021_10_29_092810_profile_update_profile_data
Doctrine\DBAL\Schema\SchemaException
There is no column with name 'profile_data' on table 'profile'.
at vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86
82| * @return SchemaException
83| */
84| public static function columnDoesNotExist($columnName, $table)
85| {
> 86| return new self(
87| sprintf("There is no column with name '%s' on table '%s'.", $columnName, $table),
88| self::COLUMN_DOESNT_EXIST
89| );
90| }
+20 vendor frames 
21 app/Console/Commands/MigrateCommand.php:23
Illuminate\Database\Console\Migrations\MigrateCommand::handle()
+13 vendor frames 
35 please:37
Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment