MSPBots WIKI : Kaseya BMS Public Datasets
Here are the published or Alpha version Kaseya BMS datasets that you can use to create the widgets and dashboards
In total, there are 42 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
Kaseya BMS Ticket RelatedTasks - API | ODS Dataset which generated from Kaseya BMS Ticket RelatedTasks | Apr 12, 2022 | Apr 12, 2022 | ["id", "tenant_code", "sync_time", "other_id", "ticket_id", "task_name", "project_name", "start_date"] |
Kaseya BMS SoftwareAssets - API | ODS Dataset which generated from Kaseya BMS SoftwareAssets | Apr 12, 2022 | Apr 12, 2022 | ["id", "tenant_code", "sync_time", "other_id", "software_name", "category_name", "category_id", "version", "model_number"] |
Kaseya BMS Accounts - API | ODS Dataset which generated from Kaseya BMS Accounts | Apr 12, 2022 | Apr 12, 2022 | ["id", "tenant_code", "sync_time", "other_id", "class_id", "net_days", "website", "is_active", "parent_id", "class_name", "created_by", "created_on", "is_billing", "locations", "currency_id", "modified_by", "modified_on", "tenant_name", "account_code", "account_name", "account_type", "credit_limit", "description", "service_type", "acquired_date", "business_type", "currency_name", "account_type_id", "service_type_id", "business_type_id", "sales_tax_item_id", "account_manager_id", "sales_tax_item_name", "account_manager_user_name"] |
Kaseya BMS Tickets - API | ODS Dataset which generated from Kaseya BMS Tickets | Apr 12, 2022 | Apr 12, 2022 | ["id", "tenant_code", "sync_time", "other_id", "sla_id", "title", "type_id", "details", "due_date", "queue_id", "sla_name", "open_date", "source_id", "status_id", "type_name", "account_id", "contact_id", "created_by", "created_on", "has_met_sla", "queue_name", "recurring", "assignee_id", "contract_id", "location_id", "modified_by", "modified_on", "priority_id", "status_name", "tenant_name", "work_type_id", "account_code", "account_name", "contact_name", "is_sla_paused", "is_scheduled", "issue_type_id", "status_color", "status_order", "assignee_name", "contract_name", "custom_fields", "priority_name", "re_opened_date", "ticket_number", "work_type_name", "completed_date", "created_by_name", "issue_type_name", "priority_color", "sla_status_enum", "contract_number", "sla_objective_id", "sub_issue_type_id", "hardware_asset_id", "last_queue_update", "status_fore_color", "last_status_update", "sla_status_event_id", "sub_issue_type_name", "hardware_asset_name", "sla_last_paused_time", "actual_pause_minutes", "last_activity_update", "last_priority_update", "sla_last_resumed_time", "resolution_actual_time", "resolution_target_time", "actual_resolution_minutes", "first_response_actual_time", "first_response_target_time", "ticket_recurring_master_id", "actual_first_response_minutes"] |
Kaseya BMS Ticket TimeLogs - API | ODS Dataset which generated from Kaseya BMS Ticket TimeLogs | Apr 12, 2022 | Apr 12, 2022 | ["id", "tenant_code", "sync_time", "other_id", "ticket_id", "notes", "billed", "posted", "role_id", "user_id", "end_time", "week_end", "approved", "role_name", "created_by", "created_on", "start_date", "start_time", "timespent", "week_start", "modified_by", "modified_on", "work_type_id", "time_spent_by", "custom_fields", "employee_name", "work_type_name", "internal_notes"] |
Kaseya BMS Contacts - API | ODS Dataset which generated from Kaseya BMS Contacts | Apr 12, 2022 | Apr 12, 2022 | ["id", "tenant_code", "sync_time", "other_id", "account_id", "account_name", "location_id", "location_name", "first_name", "last_name", "job_title", "is_poc", "is_active", "is_billable", "can_recieve_invoices", "created_by", "created_on"] |
Kaseya BMS Projects - API | ODS Dataset which generated from Kaseya BMS Projects | Apr 12, 2022 | Apr 12, 2022 | ["id", "tenant_code", "sync_time", "other_id", "project_number", "name", "description", "manager_id", "manager_name", "status_id", "status_name", "priority_id", "priority_name", "start_date", "due_date", "planned_hours", "used_hours", "planned_budget", "actual_budget"] |
Kaseya BMS Roles Lookup - API | ODS Dataset which generated from Kaseya BMS Roles Lookup | Apr 14, 2022 | Apr 14, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "is_default"] |
Kaseya BMS Invoices - API | ODS Dataset which generated from Kaseya BMS Invoices | Apr 14, 2022 | Apr 14, 2022 | ["id", "tenant_code", "sync_time", "other_id", "invoice_number", "status_id", "status_name", "notes", "account_id", "account_name", "account_location_id", "account_location_name", "project_id", "project_name", "po_number", "sales_tax_item_id", "sales_tax_item_name", "sales_rep_id", "sales_rep_name", "class_id", "class_name", "discount", "sales_tax_rate", "total_price", "total_tax", "grand_total", "payment_due", "paid_amount", "invoice_date", "due_date", "invoice_from", "invoice_to", "sent_on", "contact_first_name", "contact_last_name", "address1", "address2", "state", "city", "country_name", "zip_code", "email_address", "phone_number", "extension", "mobile_number", "fax_number", "sent_by_user_name", "created_by_id", "created_by_user_name", "modified_by_id", "modified_by_user_name", "modified_on", "created_on", "posted_to_accounting", "posted_to_accounting_on", "accounting_app_reference", "generated_on"] |
Kaseya BMS Ticket Stats Lite - Legacy | This is a legacy dataset. Please use the Kaseya BMS Ticket Statistics - Layered dataset instead. A dataset that shows tickets currently open (no completed date) or modified in the last 14 days. | Apr 18, 2022 | Dec 10, 2023 | ["ticket_number", "timeentry_count", "queue_name", "queue", "account", "status", "date_opened", "date_completed", "last_updated", "date_due", "same_day_close", "same_day_resolve", "title", "ticket_type", "issue_type", "subissue_type", "source", "priority", "primary_assignee", "primary_assignee_name", "sla", "status_sla_event", "sla_paused_flag", "met_sla", "sla_last_paused_at", "first_response_minutes_to_breach", "met_first_response_goal", "first_response_target", "first_response_date", "first_response_minutes", "first_response_hours", "resolution_minutes_to_breach", "met_resolution_goal", "resolution_target", "resolution_date", "resolution_minutes", "resolution_hours", "sla_last_resumed_at", "paused_minutes", "contact", "sender_name", "modified_by", "modified_by_name", "created_by", "contract", "id", "ticket_id", "contract_id", "account_id", "primary_technician", "account_type", "affected_software_asset", "affected_hardware_asset", "hardware_asset_id", "software_asset_id", "last_activity_update", "account_location", "age", "primary_assignee_teams_email", "is_scheduled"] |
Kaseya BMS Time Entry | Dataset for Kaseya BMS Time Entry with start date for the last 365 days | Apr 19, 2022 | Nov 08, 2023 | ["id", "tech", "title", "created_on", "over_time_rate", "overtime_multiplier_rate", "pay_rate", "role", "billable_flag", "posted_flag", "date", "date_end", "date_start", "modified_on", "billing_rate", "vendor_billed_due", "vendor_billed_amount", "billed_flag", "approved_flag", "over_time_spent", "notes", "ticket_number", "account_name", "project", "modified_by", "week_finish", "role_rate", "custom_rate", "cost_rate", "week_start", "created_by", "actual_hours", "work_type", "contract", "ticket_type", "ticket_issue_type", "ticket_subissue_type", "ticket_source", "ticket_priority", "ticket_current_queue", "ticket_current_status", "ticket_title", "ticket_id", "contract_id", "project_id", "total_ticket_time", "project_status", "planned_budget", "manager_name", "over_two_hours", "tech_email", "date_end_utc", "date_start_utc", "notes_length"] |
Kaseya BMS Projects v1 - API | ODS Dataset which generated from Kaseya BMS Projects v1 | Apr 24, 2022 | Apr 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "project_number", "name", "description", "project_manager_id", "project_manager", "department_id", "department", "account_id", "account_name", "site_id", "site", "cost_center", "cost_type_id", "cost_type", "project_code", "assesment_id", "project_assessment", "project_type_id", "project_type", "project_status_id", "status", "client_contract_id", "contract_name", "total_billed_amount", "planned_hours", "planned_budget", "po_amount", "is_internal", "is_archived", "is_template", "planned_end_date", "start_date", "actual_end_date", "created_by_id", "created_by", "modified_by_id", "modified_by", "modified_on", "created_on"] |
Kaseya BMS Users - API | ODS Dataset which generated from Kaseya BMS Users | Apr 24, 2022 | Apr 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "first_name", "middle_name", "last_name", "user_name", "employee_id", "email", "gender_id", "gender", "description", "job_title_id", "job_title", "branch_id", "branch_name", "ssn", "is_active", "user_type_id", "marital_status_id", "marital_status", "pay_period_id", "pay_period", "currency_id", "currency_name", "department_id", "department", "overtime_pay", "allow_overtime", "employee_type_id", "employee_type", "manager_id", "manager_user_name", "security_user", "vendor_equivalent_record", "created_on", "created_by", "modifiedby", "modified_on", "hire_date", "termination_date", "birth_date", "hourly_pay", "hourly_cost", "employee_address", "employee_shift"] |
Kaseya BMS Opportunities - API | ODS Dataset which generated from Kaseya BMS Opportunities | Apr 24, 2022 | Apr 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "subject", "status_id", "status", "account_id", "account_name", "account_location_id", "account_location", "contact_id", "contact_first_name", "contact_last_name", "type_id", "type", "probability", "rating", "rating_id", "lead_source", "lead_source_id", "sales_representative_username", "sales_representative_user_id", "amount", "in_pipeline", "description", "customer_po", "created_on", "created_by", "codified_by", "modified_on", "close_date"] |
Kaseya BMS Task Data | Information on tasks created in the last 365 days | Apr 25, 2022 | Jan 18, 2023 | ["id", "row_number", "estimated_hours", "used_hours", "remaining_hours", "percent_used", "percent_done", "start_date", "end_date", "duration", "status", "open_age_days", "past_due_status", "parent_task_id", "parent_task", "task_number", "description", "type", "cost_type", "work_type", "name", "created_by", "created_on", "modified_by", "modified_on", "field_order", "project_number", "project_name", "project_id", "project_number_and_name"] |
Kaseya BMS Project Data | The dataset contains all projects updated in the last 120 days and where the actual end date is null (open project). | Apr 25, 2022 | Dec 27, 2022 | ["id", "cost_type", "created_on", "total_billed_amount", "department", "project_assessment", "planned_budget", "project_manager_email", "status", "modified_on", "project", "description", "actual_start_date", "actual_end_date", "planed_end_date", "account_name", "end_date_check", "modified_by", "cost_center", "project_code", "project_type", "site", "project_number", "po_amount", "created_by", "planned_hours", "contract", "arhicved_flag", "internal_flag", "template_flag", "account_id", "project_id"] |
Kaseya BMS Contract Data | Kaseya BMS Contract Data | Jun 13, 2022 | Dec 10, 2022 | ["id", "created_on", "contract_type", "status", "start_date", "end_date", "reference_number", "con", "contract_hours", "contract_price", "average_rate", "contract_number", "account_name", "modified_by", "modified_on", "sla", "allow_carry_over_to_next_cycle", "billing_cycle", "created_by", "contract", "contract_id"] |
Kaseya BMS Recurring Services - API | ODS Dataset which generated from Kaseya BMS Recurring Services | Jun 14, 2022 | Jun 14, 2022 | ["id", "tenant_code", "sync_time", "other_id", "service_id", "service_name", "description", "contract_id", "contract_name", "total_cost", "total_price", "units", "unit_cost", "unit_price", "effective_date", "sort_order", "created_by_id", "created_by", "modified_by_id", "modified_by", "modified_on", "created_on"] |
Kaseya BMS Opportunity Data | Opportunities opened or updated in the last 120 days | Jun 15, 2022 | Dec 10, 2022 | ["id", "created", "close_date", "type", "status", "last_updated", "description", "inpipeline", "contact", "account_location", "account", "amount", "probability_adjusted_revenue", "lead_source", "updated_by", "customer_po", "rating", "probability", "sales_rep", "created_by", "subject", "next_step_start", "next_step", "next_step_assignee", "opportunity_id", "account_id"] |
Kaseya BMS Recurring Services Contracts | Kaseya BMS Recurring Services Contracts | Jun 15, 2022 | Dec 10, 2022 | ["contract_id", "id", "total_cost", "total_price", "modified_on", "effective_date", "created_on", "service_name", "unit_cost", "modified_by", "created_by", "units", "unit_price", "contract_name", "contract_start_date", "contract_end_date", "contract_number", "account_name", "contract_billing_price", "sla", "reference_number"] |
Kaseya BMS Hardware Assets | Kaseya BMS Hardware Assets | Jun 16, 2022 | Dec 10, 2022 | ["category", "created_on", "bar_code", "serial_number", "business_impact", "memory_slots", "state", "login_name", "product_name", "ip_address", "name", "mac_address", "modified_on", "minor_version", "last_login_name", "brand", "id", "expiration_date", "last_checkin", "first_checkin", "os_type", "maximum_memory", "os_info", "last_reboot", "contact_first_name", "contact_last_name", "contact_name", "account_location", "asset_tag", "physical_location_info", "machine_version", "modified_by", "vendor", "account_name", "description", "major_version", "acquisition_date", "warranty_expiration_date", "warranty_status", "purchase_cost", "model_number", "created_by", "manufacturer", "current_machine_user", "machine_group", "hardware_asset_id", "account_id"] |
Kaseya BMS V1 HardWareAssets - API | ODS Dataset which generated from Kaseya BMS V1 HardWareAssets | Jul 05, 2022 | Jul 05, 2022 | ["id", "tenant_code", "sync_time", "other_id", "asset_id", "name", "account_id", "account_name", "account_location_id", "account_location", "contact_id", "contact_first_name", "contact_last_name", "category_id", "category", "brand_id", "brand", "serial_number", "business_impact_id", "business_impact", "state_id", "state", "location_info", "description", "bar_code", "asset_tag", "vendor_id", "vendor", "is_active", "model_number", "machine_group_id", "ip_address", "subnet_mask", "default_gateway", "dns_servers", "dhcp_enabled", "dhcp_server", "wins_enabled", "secondary_wins_server", "connection_gateway_ip", "os_type", "os_info", "major_version", "minor_version", "mac_address", "login_name", "last_loginname", "current_user_name", "product_name", "machine_version", "motherboard_manufacturer_id", "motherboard_manufacturer", "motherboard_product_code", "motherboard_serial_number", "motherboard_version", "chassis_asset_tag", "chassis_manufacturer_id", "chassis_manufacturer", "chassis_serial_number", "chassis_type", "chassis_version", "bus_speed", "manufacturer_id", "manufacturer", "max_memory_size", "max_memory_slots", "primary_wins_server", "purchase_cost", "warranty_expiration_date", "expiration_date", "acquisition_date", "first_check_in", "last_check_in", "last_reboot", "created_by_id", "created_by", "modified_by_id", "modified_by", "created_on", "modified_on"] |
Kaseya BMS Ticket Stat - Legacy | This is a legacy dataset. Please use the Kaseya BMS Ticket Statistics - Layered dataset instead. A dataset that shows tickets opened in the last 2 years. | Sep 08, 2022 | Dec 10, 2023 | ["ticket_number", "timeentry_count", "queue_name", "account", "status", "date_opened", "date_completed", "last_updated", "modified_by_name", "date_due", "same_day_close", "same_day_resolve", "title", "ticket_type", "issue_type", "subissue_type", "source", "priority", "primary_assignee", "assignee_id", "primary_assignee_name", "sla", "status_sla_event", "sla_paused_flag", "met_sla", "sla_last_paused_at", "first_response_minutes_to_breach", "met_first_response_goal", "first_response_target", "first_response_date", "first_response_minutes", "first_response_hours", "resolution_minutes_to_breach", "met_resolution_goal", "resolution_target", "resolution_date", "resolution_minutes", "resolution_hours", "sla_last_resumed_at", "paused_minutes", "contact", "sender_name", "modified_by", "created_by", "contract", "id", "ticket_id", "contract_id", "account_id", "primary_technician", "department", "account_type", "affected_software_asset", "affected_hardware_asset", "hardware_asset_id", "software_asset_id", "last_activity_update", "account_location", "age", "created_range", "updated_range", "hours_actual", "create_age", "update_age", "email"] |
Kaseya BMS Ticket V1 - API | ODS Dataset which generated from Kaseya BMS Ticket V1 | Jan 09, 2023 | Jan 09, 2023 | ["id", "tenant_code", "sync_time", "other_id", "ticket_number", "title", "details", "account_id", "account_name", "account_location_id", "account_location", "contact_id", "contact_first_name", "contact_last_name", "status_id", "status", "status_sla_event_id", "status_sla_event", "priority_id", "priority", "queue_id", "queue", "ticket_type_id", "ticket_type", "ticket_source_id", "ticket_source", "issue_type_id", "issue_type", "sub_issue_type_id", "sub_issue_type", "primary_assignee_id", "primary_assignee", "secondary_assignees", "sla_id", "sla_name", "contract_id", "contract_name", "affected_hardware_asset_id", "affected_hardware_asset", "affected_software_asset_id", "affected_software_asset", "due_date", "completed_date", "created_by_id", "created_by", "modified_by_id", "modified_by", "modified_on", "open_date", "sender_name", "sender_email", "survey_score_id", "survey_score_name", "total_interactions", "actual_first_response_minutes", "actual_pause_minutes", "actual_resolution_minutes", "first_response_target_time", "first_response_actual_time", "resolution_target_time", "resolution_actual_time", "sla_last_paused_time", "sla_last_resumed_time", "has_met_sla", "is_sla_paused", "tenant_name", "last_activity_update"] |
Kaseya BMS Work Types - API | ODS Dataset which generated from Kaseya BMS Work Types | Jan 10, 2023 | Jan 10, 2023 | ["id", "tenant_code", "sync_time", "other_id", "name", "is_default", "is_active"] |
Kaseya BMS V1 Tasks Members | ODS Dataset which generated from Kaseya BMS V1 Tasks Members | Jan 31, 2023 | Jan 31, 2023 | ["id", "tenant_code", "sync_time", "other_id", "employee_id", "employee_name", "task_id", "task_name", "hours", "cost_rate", "pay_rate", "role_rate", "created_by_id", "created_by", "modified_by_id", "modified_by", "modified_on", "created_on"] |
Kaseya BMS V1 Ticket Status Change - API | ODS Dataset which generated from Kaseya BMS V1 Ticket Status Change | Feb 28, 2023 | Feb 28, 2023 | ["id", "tenant_code", "other_id", "ticket_id", "old_status_sla_event_id", "old_sla_event", "new_status_sla_event_id", "new_sla_event", "old_status_id", "old_status", "new_status_id", "new_status", "created_by_id", "created_by", "created_on", "sync_time"] |
Kaseya BMS V1 Accounts Types - API | ODS Dataset which generated from Kaseya BMS V1 Accounts Types | Feb 28, 2023 | Feb 28, 2023 | ["id", "tenant_code", "other_id", "name", "is_active", "is_client", "is_vendor", "created_by_id", "created_on", "modified_by_id", "modified_on", "sync_time"] |
Kaseya BMS V1 Locations - API | ODS Dataset which generated from Kaseya BMS V1 Locations | Feb 28, 2023 | Feb 28, 2023 | ["id", "tenant_code", "other_id", "account_id", "location_name", "is_main", "is_active", "created_by", "created_on", "modified_by", "modified_on", "addresses", "sync_time"] |
Kaseya BMS Ticket Slainfo - API | ODS Dataset which generated from Kaseya BMS Ticket Slainfo | Mar 24, 2023 | Mar 24, 2023 | ["id", "tenant_code", "ticket_id", "sla_stage", "sla_name", "ticket_priority_name", "ticket_priority_color", "respond_goal", "respond_actual", "respond_remaining", "resolve_goal", "resolve_actual", "resolve_remaining", "waiting_actual", "reopen_actual", "time_total_goal", "time_total_actual", "time_total_remaining", "sync_time"] |
Team GPS Kaseya BMS Member KPI | This dataset showcases daily data per member from the PSA Kaseya BMS, featuring key performance indicators such as Billable Hours, and Actual Hours divided by the daily capacity set to 8 as Productive Time. Shows Last 6 months of data. | Apr 04, 2023 | Oct 04, 2023 | ["dataset_name", "date", "last_update_time", "user_id", "user_name", "name", "email", "daily_capacity", "actual_hours", "billable_hours", "ticket_touches_kpi", "ticket_touches_format", "unscheduled_leave_kpi", "unscheduled_leave_format", "productive_time_kpi", "productive_time_format", "true_productive_time_kpi", "true_productive_time_format", "billable_utilization_rate_kpi", "billable_utilization_rate_format", "resoved_tickets_kpi", "resoved_tickets_format", "response_met_p1", "response_unmet_p1", "p1_sla_response_kpi", "p1_sla_response_format", "response_met_p2", "response_unmet_p2", "p2_sla_response_kpi", "p2_sla_response_format", "response_met_p3", "response_unmet_p3", "p3_sla_response_kpi", "p3_sla_response_format", "resolved_met_p1", "resolved_unmet_p1", "p1_sla_resolved_kpi", "p1_sla_resolved_format", "resolved_met_p2", "resolved_unmet_p2", "p2_sla_resolved_kpi", "p2_sla_resolved_format", "resolved_met_p3", "resolved_unmet_p3", "p3_sla_resolved_kpi", "p3_sla_resolved_format", "first_call_resolution_kpi", "first_call_resolution_format", "ticket_same_day_close_kpi", "ticket_same_day_close_format", "late_time_log_kpi", "late_time_log_format"] |
Kaseya BMS Current Logged in Technician | Dataset for slicer use that automatically selects current user from the slicer select | Apr 05, 2023 | Oct 09, 2023 | ["identifier", "kaseya_user_id", "sys_user_id", "full_name", "sys_name", "user_status", "kaseya_username", "kaseya_employee_id"] |
Kaseya BMS V1 Ticket Notes - API | ODS Dataset which generated from Kaseya BMS V1 Ticket Notes | Apr 06, 2023 | Apr 06, 2023 | ["id", "tenant_code", "other_id", "ticket_id", "note_type_id", "note_type", "note_summary", "is_internal", "note_date", "ticket_number", "created_by_id", "created_by_user_name", "sender_email", "modified_by_id", "modified_by_user_name", "modified_on", "created_on", "sync_time"] |
Kaseya BMS Ticket Servicecalls - API | ODS Dataset which generated from Kaseya BMS Ticket Servicecalls | Apr 11, 2023 | Apr 11, 2023 | ["id", "tenant_code", "other_id", "ticket_id", "task_id", "account_id", "account_name", "description", "complete", "start_date", "end_date", "user_id", "resource", "created_by_id", "created_by_name", "created_on", "modified_by", "modified_on", "sync_time"] |
Team GPS Kaseya Ticket Details | Shows Ticket Details of Team GPS KPI. | May 12, 2023 | Jun 14, 2023 | ["ticket_number", "ticket_id", "open_date", "open_date_date", "priority_id", "priority", "queue", "queue_id", "title", "details", "account_name", "ticket_type", "ticket_source", "primary_assignee", "primary_assignee_name", "secondary_assignees", "secondary_assignees_name", "first_response_actual_time", "first_response_target_time", "first_response_date", "metresponsesla", "resolution_actual_time", "resolution_target_time", "resolution_date", "metresolvesla", "completed_date", "completed_date_date", "same_day_completed", "same_day_resolution", "sla_id", "has_met_sla", "last_activity_update", "timeentry_count", "sla_kpi", "ticket_touched_kpi", "first_call_resolution_kpi", "same_day_close_kpi", "priority_1_kpi", "priority_2_kpi", "priority_3_kpi"] |
Team GPS Kaseya Time Logs Details | This dataset presents the details of time logs , as well as the names of associated tickets and boards, all of which are connected to the team's GPS settings within the past month. | May 16, 2023 | Oct 04, 2023 | ["ticket_id", "timeentry_id", "ticket_number", "queue_id", "queue", "timespent", "user_id", "created_by", "member_name", "work_type_id", "work_type", "notes", "client_id", "account_name", "time_entry_source_id", "title", "billable", "start_date", "start_time", "created_on", "end_time", "entered_duration", "unsched_leave", "modified_on", "daily_capacity", "actual_hours_kpi", "billable_hours_kpi", "unsched_leave_kpi", "late_timeentry_kpi", "productive_time_kpi"] |
Kaseya BMS Contacts Emails - API | ODS Dataset which generated from Kaseya BMS Contacts Emails | Jun 21, 2023 | Jun 21, 2023 | ["id", "tenant_code", "contact_id", "other_id", "account_name", "created_by", "email_type", "is_default", "modified_by", "email_type_id", "email_address", "modified_on", "created_on", "sync_time", "first_name", "last_name"] |
Kaseya BMS Next Ticket Reject Logs | Shows List of Ticket Rejected on the Next Ticket in the last 30 days. | Jun 23, 2023 | Jul 26, 2023 | ["tenant_code", "user_id", "full_name", "create_time", "type", "ticket_id", "ticket_number", "title", "account_name", "reason", "username", "job_title", "manager", "manager_email", "link", "ticket_link"] |
Kaseya BMS Ticket RelatedTickets - API | ODS Dataset which generated from Kaseya BMS Ticket RelatedTickets | Jul 17, 2023 | Jul 17, 2023 | ["id", "tenant_code", "sync_time", "input_ticket_id", "other_id", "ticket_id", "related_ticket_id", "ticket_number", "title", "status_name", "status_color", "status_fore_color"] |
Kaseya BMS Ticket Servicecallstodos - API | ODS Dataset which generated from Kaseya BMS Ticket Servicecallstodos | Jul 17, 2023 | Jul 17, 2023 | ["id", "tenant_code", "sync_time", "input_ticket_id", "other_id", "item_type", "description", "assigned_to", "complete", "start_date", "end_date", "created_by", "created_on", "modified_by", "modified_on"] |
Kaseya BMS Company List for Currently Logged In User | This dataset contains Kaseya BMS data for currently logged in user. It will return the currently logged in user's company. If the user is an admin then it will return all of their company names. | Oct 03, 2023 | Nov 03, 2023 | ["id", "email", "first_name", "last_name", "full_name", "company_name"] |
Kaseya BMS Ticket Statistics - Layered | This is a layered dataset. The main layer pulls in tickets modified in the last 14 days while the second layer covers the last 240 days. Both layers include currently open (no completed date) tickets. | Nov 10, 2023 | Nov 10, 2023 | ["ticket_number", "queue", "account", "account_location", "status", "date_opened", "date_completed", "last_updated", "date_due", "same_day_close", "same_day_resolve", "title", "ticket_type", "issue_type", "subissue_type", "source", "priority", "primary_assignee_name", "sla", "status_sla_event", "sla_paused_flag", "met_sla", "sla_last_paused_at", "first_response_minutes_to_breach", "met_first_response_goal", "first_response_target", "first_response_date", "first_response_minutes", "first_response_hours", "resolution_minutes_to_breach", "met_resolution_goal", "resolution_target", "resolution_date", "resolution_minutes", "resolution_hours", "sla_last_resumed_at", "paused_minutes", "contact", "sender_name", "sender_email", "total_number_of_interactions", "modified_by", "created_by", "contract", "id", "survey_score_name", "ticket_id", "contract_id", "account_id", "primary_technician", "account_type", "affected_software_asset", "affected_hardware_asset", "hardware_asset_id", "software_asset_id"] |