MSPBots WIKI : SyncroMSP Public Datasets
Here are the published or Alpha version SyncroMSP datasets that you can use to create the widgets and dashboards
In total, there are 37 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| Syncromsp Contacts - API | ODS Dataset which generated from Syncromsp Contacts | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "address1", "address2", "city", "state", "zip", "email", "phone", "mobile", "latitude", "longitude", "customer_id", "account_id", "notes", "created_at", "updated_at", "vendor_id", "properties_title", "opt_out", "extension", "processed_phone", "processed_mobile", "ticket_matching_emails"] |
| Syncromsp PortalUsers - API | ODS Dataset which generated from Syncromsp PortalUsers | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "account_id", "portal_group_id", "email", "disabled", "customer_id", "contact_id", "created_at", "updated_at", "second_factor_attempts_count", "encrypted_otp_secret_key", "encrypted_otp_secret_key_iv", "encrypted_otp_secret_key_salt", "direct_otp", "direct_otp_sent_at", "totp_timestamp", "mobile", "confirmed_mobile", "otp_recovery_secret_key", "second_factor_recovery_attempts_count", "require_mfa"] |
| Syncromsp Customers - API | ODS Dataset which generated from Syncromsp Customers | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "firstname", "lastname", "fullname", "business_name", "email", "phone", "mobile", "created_at", "updated_at", "pdf_url", "address", "address2", "city", "state", "zip", "latitude", "longitude", "notes", "get_sms", "opt_out", "disabled", "no_email", "location_name", "location_id", "notification_billing", "notification_reports", "notification_marketing", "online_profile_url", "tax_rate_id", "notification_email", "invoice_cc_emails", "invoice_term_id", "referred_by", "ref_customer_id", "business_and_full_name", "business_then_name", "contacts"] |
| Syncromsp Invoices - API | ODS Dataset which generated from Syncromsp Invoices | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "customer_id", "customer_business_then_name", "number", "created_at", "updated_at", "date", "due_date", "subtotal", "total", "tax", "verified_paid", "tech_marked_paid", "ticket_id", "pdf_url", "is_paid", "location_id", "po_number", "contact_id", "note", "hardwarecost", "user_id"] |
| Syncromsp Products - API | ODS Dataset which generated from Syncromsp Products | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "price_cost", "price_retail", "condition", "description", "maintain_stock", "name", "quantity", "warranty", "sort_order", "reorder_at", "disabled", "taxable", "product_category", "category_path", "upc_code", "discount_percent", "warranty_template_id", "qb_item_id", "desired_stock_level", "price_wholesale", "notes", "tax_rate_id", "physical_location", "serialized", "vendor_ids", "long_description", "location_quantities", "photos"] |
| Syncromsp PurchaseOrders - API | ODS Dataset which generated from Syncromsp PurchaseOrders | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "account_subdomain", "created_at", "updated_at", "expected_date", "number", "other", "shipping", "shipping_notes", "status", "total", "user_id", "vendor_id", "location_id", "due_date", "paid_date", "delivery_tracking", "vendor_name", "vendor_rep_first_name", "vendor_rep_last_name", "vendor_email", "vendor_phone", "vendor_account_number", "vendor_created_at", "vendor_updated_at", "vendor_address", "vendor_city", "vendor_state", "vendor_zip", "vendor_website", "vendor_notes", "location", "line_items"] |
| Syncromsp Schedules - API | ODS Dataset which generated from Syncromsp Schedules | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "account_id", "customer_id", "email_customer", "frequency", "name", "next_run", "snail_mail", "charge_mop", "subtotal", "invoice_unbilled_ticket_charges", "paused", "last_invoice_paid", "lines"] |
| Syncromsp Tickets - API | ODS Dataset which generated from Syncromsp Tickets | Jul 21, 2022 | Jul 21, 2022 | ["id", "tenant_code", "sync_time", "other_id", "number", "subject", "created_at", "customer_id", "customer_business_then_name", "due_date", "resolved_at", "start_at", "end_at", "location_id", "problem_type", "status", "ticket_type_id", "properties", "user_id", "updated_at", "pdf_url", "priority", "comments", "user_email", "user_full_name", "user_created_at", "user_updated_at", "user_group", "user_admin", "user_color"] |
| Syncromsp Timelogs - API | ODS Dataset which generated from Syncromsp Timelogs | Jul 22, 2022 | Jul 22, 2022 | ["id", "tenant_code", "sync_time", "other_id", "in_at", "out_at", "account_id", "user_id", "in_note", "out_note", "created_at", "updated_at", "lunch", "manually_updated"] |
| Syncromsp User - API | ODS Dataset which generated from Syncromsp User | Jul 22, 2022 | Jul 22, 2022 | ["id", "tenant_code", "sync_time", "other_id", "email", "fullname", "created_at", "updated_at", "group_name", "admin", "color"] |
| Syncromsp Vendors - API | ODS Dataset which generated from Syncromsp Vendors | Jul 22, 2022 | Jul 22, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "rep_first_name", "rep_last_name", "email", "phone", "account_number", "created_at", "updated_at", "address", "city", "state", "zip", "website", "notes"] |
| Syncromsp Ticket Timer - API | ODS Dataset which generated from Syncromsp Ticket Timer | Aug 09, 2022 | Aug 09, 2022 | ["id", "tenant_code", "sync_time", "other_id", "ticket_id", "user_id", "start_time", "end_time", "recorded", "created_at", "updated_at", "billable", "notes", "toggl_id", "product_id", "comment_id", "ticket_line_item_id", "active_duration"] |
| Syncromsp Customer Asset - API | ODS Dataset which generated from Syncromsp Customer Asset | Aug 16, 2022 | Aug 18, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "customer_id", "contact_id", "created_at", "updated_at", "generated_kabuto_customer_id", "device_name", "monitoring", "mav", "policy_id", "computer_uuid", "kabuto_live_uuid", "agent_version", "live_agent_version", "profile_folder_size", "ram_gb", "general_name", "general_manufacturer", "general_model", "general_serial_number", "general_ip", "general_form_factor", "general_domain", "general_mac", "general_agent_version", "os_name", "os_last_boot_time", "os_build", "os_architecture", "os_windows_release_version", "os_pending_reboot", "motherboard_name", "motherboard_manufacturer", "kabuto_information_cpu", "kabuto_information_hdd", "kabuto_information_network_adapters", "kabuto_information_ram", "kabuto_information_av", "kabuto_information_video_card", "system_partition_size_gb", "system_partition_free_gb", "system_partition_free_percent", "fixed_disks_total_size_gb", "fixed_disks_total_free_gb", "fixed_disks_total_free_percent", "primary_adapter_gateway", "primary_adapter_ipv4", "primary_adapter_ipv6", "primary_adapter_dns1", "primary_adapter_dns2", "primary_adapter_subnet", "primary_adapter_name", "primary_adapter_type", "primary_adapter_description", "install_dates_os_install", "install_datesbios_release", "install_dates_system_volume", "kabuto_information_profile_folder_size", "kabuto_information_monitoring", "kabuto_information_mav", "kabuto_information_computer_uuid", "kabuto_information_kabuto_live_uuid", "kabuto_information_last_version", "kabuto_information_live_last_version", "kabuto_information_device_name", "kabuto_information_last_synced_at", "form_factor", "bdmav", "bdmav_installed", "webroot_mav", "webroot_cannot_match", "webroot_installed", "last_backup_reinstall_needed_at", "remote_access", "manufacturer", "model", "computer_name", "mac", "ts_debugging_powershell_classic_version", "splashtop_uuid", "os", "last_boot", "cpu_name", "hdd", "ram", "av", "asset_type", "asset_serial", "external_rmm_link", "customer_firstname", "customer_lastname", "customer_fullname", "customer_business_name", "customer_email", "customer_phone", "customer_mobile", "customer_created_at", "customer_updated_at", "customer_pdf_url", "customer_address", "customer_address2", "customer_city", "customer_state", "customer_zip", "customer_latitude", "customer_longitude", "customer_notes", "customer_get_sms", "customer_opt_out", "customer_disabled", "customer_no_email", "customer_location_name", "customer_location_id", "customer_notification_billing", "customer_notification_reports", "customer_notification_marketing", "customer_online_profile_url", "customer_tax_rate_id", "customer_notification_email", "customer_invoice_cc_emails", "customer_invoice_term_id", "customer_referred_by", "customer_ref_customer_id", "customer_business_and_full_name", "customer_business_then_name", "rmm_links", "has_live_chat", "snmp_enabled", "snmp_config_port", "snmp_config_enabled", "snmp_config_version", "snmp_config_community", "rmm_store_id", "rmm_store_asset_id", "rmm_store_account_id", "triggers_bsod_triggered", "triggers_time_triggered", "triggers_no_av_triggered", "triggers_defrag_triggered", "triggers_firewall_triggered", "triggers_app_crash_triggered", "triggers_low_hd_space_triggered", "triggers_agent_offline_triggered", "triggers_smart_failure_triggered", "triggers_device_manager_triggered", "wu_schedule_day", "wu_schedule_hour", "wu_schedule_active_start", "wu_schedule_active_end", "wu_available", "wu_latest", "windows_update", "wu_error", "emsisoft_id", "emsisoft_device_id", "device_mav_state_running", "device_mav_state_anti_phishing", "device_mav_state_install_state", "device_mav_state_engine_version", "device_mav_state_product_version", "device_mav_state_product_directory", "device_mav_state_real_time_protection", "real_time_protection", "emsisoft_scan", "emsisoft_license", "emsisoft_own_license", "emsisoft_own_license_expires_at", "ap_disabled", "rtp_disabled", "last_scan_since", "threats_detected", "emsisoft_scan_schedule", "emsisoft_anti_phishing", "emsisoft_running", "emsisoft_enabled", "emsisoft_eam_settings", "scan_opts_silent", "scan_opts_scan_type", "scan_opts_quarantine", "schedule_opts_silent", "schedule_opts_scan_type", "schedule_opts_quarantine", "emsisoft_installed_at", "info_ram_gb", "info_profile_folder_size", "info_general_name", "info_general_manufacturer", "info_general_model", "info_general_serial_number", "info_general_ip", "info_general_form_factor", "info_general_domain", "info_general_mac", "info_general_agent_version", "info_os", "info_motherboard", "info_cpu", "info_hdd", "info_network_adapters", "info_ram", "info_av", "info_video_card", "info_system_partition", "info_fixed_disks_total", "info_primary_adapter", "info_install_dates", "info_monitoring", "info_mav", "info_computer_uuid", "info_kabuto_live_uuid", "info_live_last_version", "info_device_name", "info_last_synced_at", "extra_windows_version", "rmm_store_created_at", "rmm_store_updated_at", "override_alert_agent_offline_mins", "override_alert_agent_rearm_after_mins", "override_low_hd_threshold", "override_autoresolve_offline_alert", "override_low_hd_thresholds", "address"] |
| SyncroMSP - Ticket Timer | This dataset contain time logs entered for each ticket with their corresponding project and customer name. | Oct 11, 2022 | Dec 10, 2022 | ["id", "tenant_code", "sync_time", "other_id", "ticket_id", "user_id", "start_time", "end_time", "recorded", "created_at", "updated_at", "billable", "notes", "toggl_id", "product_id", "comment_id", "ticket_line_item_id", "active_duration", "link", "notes_length", "time_entry_id", "technician_id", "date_updated", "customer_name", "product_name", "product_category", "technician_name", "technician_group", "technician_email", "actual_time_min", "actual_time_hrs", "title", "ticket_number", "date_entered", "schedule_late_time_entry_mins", "late_time_entry_mins", "late_time_entry_hours", "ticket_schedule", "billing_status", "ticket_closed_date", "ticket_status", "company_and_agreement", "appointment_location", "ticket_type", "ticket_title", "ticket_closed_flag", "invoice_flag", "invoice_date", "charge_type", "ticket_create_date", "day", "hour_time_entry_created", "shift_start", "shift_end", "outside_bh_time_entry_flag", "user_status", "setting_late", "setting_late_flag", "bh_day"] |
| SyncroMSP Appointments - API | ODS Dataset which generated from SyncroMSP Appointments | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "summary", "description", "customer_id", "created_at_utc", "updated_at_utc", "start_at_utc", "end_at_utc", "duration", "location", "ticket_id", "appointment_location_type", "start_at_label", "all_day", "created_at", "updated_at", "start_at", "end_at", "ticket", "customer"] |
| SyncroMSP Product Serials - API | ODS Dataset which generated from SyncroMSP Product Serials | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "product_location_quantity_id", "line_item_id", "serial_number", "status", "instance_price_cost", "instance_price_retail", "location_id", "created_at", "updated_at", "created_at_utc", "updated_at_utc"] |
| SyncroMSP Tickets Settings - API | ODS Dataset which generated from SyncroMSP Tickets Settings | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "ticket_status_list", "ticket_assignment_defaults_to_blank", "default_labor_product_id", "ticket_timer_charge_by_default", "saved_searches", "ticket_types", "ticket_type_fields", "ticket_type_field_answers", "appointment_types", "users", "dashboard_settings", "worksheet_templates", "require_ticket_type", "require_intake_form_with_ticket", "require_outtake_form_with_ticket", "ticket_workflow_default_id"] |
| SyncroMSP Wiki Pages - API | ODS Dataset which generated from SyncroMSP Wiki Pages | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "account_id", "name", "slug", "body", "interpolated_body"] |
| SyncroMSP Payment Methods - API | ODS Dataset which generated from SyncroMSP Payment Methods | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "name", "uses_card_processing", "created_at", "updated_at", "created_at_utc", "updated_at_utc"] |
| SyncroMSP Items - API | ODS Dataset which generated from SyncroMSP Items | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "requestedon", "ticketnum", "parturl", "shipping", "deststore", "orderedby", "orderedon", "trackingnum", "receivedon", "price", "account_id", "description", "destination_location_id", "from_location_id", "from_name", "received_at", "user_id", "created_at", "updated_at", "due_at", "ticket_id", "logistic_state", "product_id", "quantity", "round_trip", "trip_leg", "retail_cents", "taxable", "converted", "notes", "refurb_id", "invoice_id", "created_at_utc", "updated_at_utc", "requestedon_utc"] |
| SyncroMSP Leads - API | ODS Dataset which generated from SyncroMSP Leads | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "first_name", "last_name", "email", "phone", "mobile", "created_at", "updated_at", "address", "city", "state", "zip", "ticket_subject", "ticket_description", "ticket_problem_type", "ticket_id", "customer_id", "contact_id", "mailbox_id", "mailbox_name", "business_then_name", "has_attachments", "message_read", "status", "user_id", "location_id", "created_at_utc", "updated_at_utc"] |
| SyncroMSP Rmm Alerts - API | ODS Dataset which generated from SyncroMSP Rmm Alerts | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "customer_id", "ticket_number", "ticket_status", "computer_name", "resolved", "check_id", "status", "formatted_output", "description", "asset_id", "created_at", "updated_at", "created_at_utc", "updated_at_utc", "properties"] |
| SyncroMSP Payments - API | ODS Dataset which generated from SyncroMSP Payments | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "created_at", "updated_at", "success", "payment_amount", "invoice_ids", "ref_num", "applied_at", "payment_method", "transaction_response", "signature_date", "created_at_utc", "updated_at_utc", "customer"] |
| SyncroMSP Estimates - API | ODS Dataset which generated from SyncroMSP Estimates | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "customer_id", "customer_business_then_name", "number", "status", "created_at", "updated_at", "date", "subtotal", "total", "tax", "ticket_id", "pdf_url", "location_id", "invoice_id", "employee", "created_at_utc", "updated_at_utc", "date_utc"] |
| SyncroMSP New Ticket Forms - API | ODS Dataset which generated from SyncroMSP New Ticket Forms | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "name", "defaults", "disabled", "data_customer_details_title", "data_customer_details_fields", "data_customer_details_defaults", "data_customer_details_position", "data_ticket_details_title", "data_ticket_details_fields", "data_ticket_details_defaults", "data_ticket_details_position"] |
| SyncroMSP Payment Profiles - API | ODS Dataset which generated from SyncroMSP Payment Profiles | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "customer_id", "expiration", "customer_external_id", "used_gateway", "payment_profile_id", "last_four", "created_at", "updated_at", "created_at_utc", "updated_at_utc"] |
| SyncroMSP Appointment Types - API | ODS Dataset which generated from SyncroMSP Appointment Types | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "account_id", "name", "email_instructions", "location_type", "location_hard_code", "created_at_utc", "updated_at_utc", "created_at", "updated_at", "buffer", "appointment_reminders_schedule_id", "product_id"] |
| SyncroMSP Products Categories - API | ODS Dataset which generated from SyncroMSP Products Categories | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "account_id", "ancestry", "name", "description", "device_product_id", "names_depth_cache"] |
| SyncroMSP Phones - API | ODS Dataset which generated from SyncroMSP Phones | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "customer_id", "label", "number", "extension", "created_at", "updated_at", "created_at_utc", "updated_at_utc"] |
| SyncroMSP Line Items - API | ODS Dataset which generated from SyncroMSP Line Items | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "created_at", "updated_at", "invoice_id", "item", "name", "cost", "price", "quantity", "product_id", "taxable", "discount_percent", "position", "invoice_bundle_id", "discount_dollars", "product_category", "created_at_utc", "updated_at_utc"] |
| SyncroMSP Contracts - API | ODS Dataset which generated from SyncroMSP Contracts | Oct 12, 2022 | Oct 12, 2022 | ["id", "tenant_code", "other_id", "sync_time", "account_id", "description", "name", "customer_id", "contract_amount", "start_date", "end_date", "primary_contact", "created_at", "updated_at", "status", "likelihood", "apply_to_all", "sla_id", "created_at_utc", "updated_at_utc"] |
| SyncroMSP Ticket Statistics 210 days | This dataset contain SyncroMSP ticket details for all open tickets and all tickets updated in the last 210 days. | Oct 14, 2022 | Dec 12, 2023 | ["ticket_id", "ticket_number", "title", "created_date", "completed_date", "ticket_age", "last_activity_date", "due_date_time", "first_response_datetime", "resolved_datetime", "issue_type", "ticket_type", "priority", "status", "client", "ticket_link", "territory", "contract_name", "contact_name", "resource_name", "hours_worked", "closed_flag", "time_entry_count", "created_by", "work_role", "client_city", "resource_email", "same_day_completed", "account_owner_full_name", "product_attached", "ticket_location_name", "met_resolution", "internal_customer_flag", "time_to_first_response_mins", "is_split_ticket"] |
| SyncroMSP Ticket Appointment 12 Months | Shows Appointment Data updated in the last 12 months | Oct 18, 2022 | Dec 10, 2022 | ["ticket_id", "ticket_number", "appointment_id", "appointment_summary", "appointment_description", "created_time", "update_time", "appointment_start_date", "appointment_end_date", "all_day_flag", "ticket_resolve_flag", "ticket_status", "ticket_title", "user_id", "user_full_name", "user_email", "customer_name", "company_name", "same_day_time_log_entered_flag"] |
| SyncroMSP Machine Statistics | Shows list of all machines in the assets. | Oct 20, 2022 | Dec 10, 2022 | ["description", "domain", "company", "device_type", "device_category", "device_form_factor", "device_id", "local_ip_ipv4", "hostname", "os_architecture", "model", "computer_name", "device_name", "monitoring", "suspended", "last_user", "last_boot", "general_ip", "asset_serial", "created_date", "updated_date", "last_sync", "last_seen", "agent_offline_triggered", "online_flag", "os_pending_reboot", "operating_system", "manufacturer", "processor", "disk_total_size_gb", "disk_free_gb", "disk_free_percent", "disk_space_used_gb", "disk_used_percent", "disk_space_used_range", "motherboard_manufacturer", "motherboard_name", "ram_gb", "av_name", "install_state", "age_in_years"] |
| SyncroMSP Settings Tabs - API | ODS Dataset which generated from SyncroMSP Settings Tabs | Oct 27, 2022 | Oct 27, 2022 | ["id", "tenant_code", "sync_time", "training", "msp_dashboard", "chat", "customers", "assets", "scripts", "alerts", "tickets", "invoices", "kabuto_policies", "contracts", "reports", "wiki", "field_jobs", "products", "app_center", "leads", "estimates", "marketr", "domo", "customer_purchases", "parts", "sales", "purchase_orders", "refurbs", "recur", "backup", "pax8"] |
| SyncroMSP Settings - API | ODS Dataset which generated from SyncroMSP Settings | Oct 27, 2022 | Oct 27, 2022 | ["id", "tenant_code", "sync_time", "account_name", "account_logo_large", "account_logo_thumb", "required_fields", "customer_fields", "customer_field_answers", "asset_types", "asset_type_fields", "asset_type_field_answers", "iso_code", "currency_symbol", "date_format", "time_format", "time_zones", "time_offset", "ticket_types", "ticket_type_fields", "ticket_type_field_answers", "problem_types", "priorities", "enable_signatures_on_payments", "business_hours_enabled", "business_hours", "default_holiday_calendar", "msp_addon"] |
| SyncroMSP Next Ticket Reject Logs | Shows Next Ticket App Rejected Tickets Details in the Last 30 Days. | Nov 03, 2022 | Dec 10, 2022 | ["tenant_code", "user_id", "full_name", "create_time", "type", "ticket_id", "ticket_number", "subject", "company_name", "reason", "username", "job_title", "manager", "manager_email", "problem_type", "ticket_link"] |