MSPBots WIKI : Teams Public Datasets
Here are the published or Alpha version Teams datasets that you can use to create the widgets and dashboards
In total, there are 84 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| Office 365 AD users | Office 365 AD users list | Aug 24, 2020 | Feb 20, 2023 | ["user_name", "user_id", "real_name", "is_guest_user", "head_url", "gender", "email", "mobile", "dept_id", "status", "tenant_code", "creator", "create_date", "create_time", "updater", "update_date", "first_name", "last_name", "manager_id", "timezone_id", "timezone_name", "timezone_offset", "reg_source", "job_title", "update_source", "at_user_email", "cw_user_email", "home_channel", "aad_status", "manager_name", "last_login", "last7d_total_login", "last30d_total_login", "switch", "work_schedule_flag"] |
| Department list | Teams Department list | Aug 24, 2020 | Apr 26, 2021 | ["id", "name", "creator", "create_date", "group_id"] |
| Utilization - Daily Total Work Hours | Utilization - Daily Total Work Hours | Sep 09, 2020 | Dec 10, 2022 | ["user_id", "username", "tenant_code", "day_log_time", "month", "work_hours", "is invalid", "month_log_count", "month_work_hours", "5_days_login_flag"] |
| User Login New | User Login New Dataset Remove Client Code | Mar 22, 2021 | Dec 10, 2022 | ["username", "first_name", "last_name", "client_name", "login_time", "login_ip", "login_name", "notes", "current_dt"] |
| Teams Attendance Logs | Shows the attendance logs of personnel. | Apr 22, 2021 | Dec 10, 2022 | ["user_daily_time", "user_daily_id", "id", "teams_user_id", "duration_second", "log_time", "log_date", "log_week", "duration", "from_type", "user_id", "action", "in_duration", "start_time", "out_duration", "end_time", "sub_action", "paid", "username", "reason", "current_action", "message", "tenant_code", "tenant_name", "email", "manager", "manager_email", "previous_current_action", "first_name", "last_name", "last_action"] |
| Teams Messages | Teams Messages | Apr 25, 2021 | Dec 12, 2023 | ["id", "rule_id", "escalation", "tenant_code", "user_id", "job_title", "email", "manager_name", "send_level", "message", "status", "forward_status", "create_date", "expire_date", "business_id", "business_type", "priority", "sent_time", "to_type", "to_id", "producer", "display_name", "channel_id", "trigger_user_id", "send_type", "receiver", "installed_bot", "user_switch", "failure_reason", "channelauser", "manager_id", "sen_content"] |
| System Bot Id old and new | client_script,sys_bot | Apr 25, 2021 | Oct 09, 2023 | ["sys_script_id", "name"] |
| Integration Status | integration error | Apr 27, 2021 | Dec 10, 2022 | ["tenant_name", "id", "tenant_code", "config_code", "status", "creator", "create_date", "updater", "update_date", "config_name", "last_sync_status", "last_sync_msg", "config_date", "success_date", "error_date", "show_status"] |
| client usage | client usage history | Apr 27, 2021 | Dec 10, 2022 | ["statistic_date", "tenant_code", "TimeZone", "PageView", "MR", "MS", "ADTA", "ATDU", "PVU", "MRU", "EB", "AB", "ECB", "Accounting", "Reporting", "Attendance", "RMM", "CRM", "HU", "AU", "sync_time", "int_issues", "PSAU", "USR", "status", "name", "psa", "psa_sync_date", "cw_url", "reg_email", "other_software", "timezone_short", "signup_date", "signup_time", "last_login_date", "teams_lsd", "timedoctor_lsd", "jira_lsd", "science_lsd", "quickbook_lsd", "hubsport_lsd", "quickbook_online_lsd", "quickbook_online_lst", "user_off_switch_count", "liongard_lsd", "smileback_lsd", "xero_lsd", "automate_lsd", "nomgr_perc", "notitle_perc", "mru_prec", "atdu_prec", "pvu_prec", "hear_us", "peer_groups", "get_started", "aad_auth", "tenant_switch", "inprogress_status", "in_progress_flag", "status_tenant"] |
| Teams Bot Message Info Last 16 Weeks | bot message info | Apr 27, 2021 | Dec 15, 2023 | ["Message_Id", "user_id", "real_name", "job_title", "create_date", "sent_time", "Message", "jira_numer", "Message_Type", "send_level", "Bots", "bot_id", "original_bot_id", "escalation", "business_id", "producer", "trigger_user_id", "trigger_name", "Is_Escalation", "Status", "Send_To"] |
| User Work Schedule | User Work Schedule - A dataset used to determine the schedule of the client's users by using the columns Start and End time of their shifts, schedule duration, user's clock in or clock out status, late in and out minutes, and other columns needed. Date range: Current Day | May 07, 2021 | Mar 24, 2022 | ["Name", "Shift_Date", "Start", "End", "Schedule_Duration", "email_address", "to_clock_in_flag", "had_clocked_in_flag", "beginning_clocked_in_flag", "to_clock_out_flag", "late_time_in_mins", "late_time_out_mins", "Manager_Name", "Manager_email", "first_name", "last_name", "username", "current_date", "day_off", "within_schedule", "current_day"] |
| REV bot message statistics | bot message statistics | May 19, 2021 | Jul 13, 2023 | ["tenant_code", "create_date", "rule_id", "user_id", "day_message", "day_ready", "day_received", "day_read", "daily_reply", "bot_name", "tenant_name", "user_count", "daily_reply2", "real_name", "user_status"] |
| App - Benchmark ConnectWise Manage Late Entry User Last 7 days | This is an application dataset for Late Time Entry Application. Benchmark CW Late Entry User Last 7 days（late>5min) | Jul 01, 2021 | Oct 26, 2023 | ["tenant_code", "cw_uid", "cw_name", "sys_uid", "full_name", "user_status", "total_entry", "late_times", "late_minutes", "part_num", "percentile", "late_per_entry", "user_count", "late_user", "avg_late_times", "avg_late_hours", "median_late_times", "median_late_hours", "top_late_times", "top_late_hours", "real_name"] |
| REV attendance action daily statistics | client attendance action daily statistics | Jul 07, 2021 | Jan 31, 2023 | ["tenant_id", "user_id", "action_date", "action_count", "full_name", "date"] |
| REV widget pageview daily statistics | widget pageview daily statistics | Jul 07, 2021 | Dec 10, 2022 | ["tenant_code", "client_name", "visite_date", "widget_id", "widget_name", "user_id", "w_pv", "real_name", "user_status"] |
| Utilization log work hour msp | Utilization log work hour mspbot. | Jul 12, 2021 | Dec 18, 2023 | ["tenant_code", "log_date", "cw_uid", "total_time_entry", "hours_billed_billable", "hours_billed_donotbill", "hours_billed_nocharge", "total_entry_l30d", "actual_hours", "log_month", "log_week", "log_dow", "user_name", "user_title", "user_tenant_role", "include_in_utilization_reporting_flag", "date_hired", "hire_duration", "team_id", "team_name", "leader_id", "leader_name", "dept_id", "dept_name", "work_duration", "log_seq", "log_source", "log_missing", "sys_name", "uer_email", "setting_include_in_utilization_reporting_flag", "cw_user_id"] |
| App - ConnectWise Manage Late Time Entry User Benchmark Last 16 Weeks | This is an application dataset for Late Time Entry Application. ConnectWise Manage Late Time Entry User benchmark last 16 weeks | Jul 14, 2021 | Oct 26, 2023 | ["week_date", "user_count", "late_user", "avg_late_times", "avg_late_hours", "median_late_times", "median_late_hours", "top_late_times", "top_late_hours", "tenant_code"] |
| bot message last 14 days | bot message last 14 days | Jul 14, 2021 | Dec 10, 2022 | ["Message_Id", "tenant_code", "user_id", "real_name", "create_date", "sent_time", "Message", "Message_Type", "send_level", "Bots", "bot_id", "original_bot_id", "escalation", "business_id", "esc_bot_name", "producer", "trigger_user_id", "trigger_name", "Is_Escalation", "Status", "Send_To", "user_status", "exclude_cw_user", "cw_late_entry_set_exclude_flag", "trigger_cw_late_entry_set_exclude_flag"] |
| App - ConnectWise Manage late time entry user 30 days | This is an application dataset for Late Time Entry Application. | Sep 28, 2021 | Oct 26, 2023 | ["tenant_code", "cw_uid", "entry_day", "total_time_entry", "late_time_entry", "late_rate", "late_hours", "company_rank", "msp_rank", "sys_uid", "manager_id", "manager_full_name", "user_full_name", "user_status"] |
| My system user | Return all user depend on current login user role, if current login user is admin, return all user, else return current login user | Oct 07, 2021 | Dec 13, 2023 | ["user_id", "username", "first_name", "last_name", "email", "full name", "head_url", "create_date", "update_date", "manager_id", "timezone_id", "timezone_name", "timezone_offset", "job_title", "office_location", "attendance_flag", "installed_teams_flag", "manual_flag", "status"] |
| App - Average Late Time Entry Duration Per Team | This is an application dataset for Late Time Entry Application. Avg Late Time Entry Duration Per Team | Oct 26, 2021 | Oct 26, 2023 | ["dimension1", "This Week", "This Month", "Last Week", "Time Entry Count (Current Month)", "team name", "Last Month", "Improvement Rate"] |
| Agreement type setting | Agreement type setting | Oct 26, 2021 | Dec 07, 2021 | ["tenant_code", "create_time", "update_time", "agreement_set_type", "category_id", "agreement_id", "agreement_name", "agreement_name_formal"] |
| Attendance Summary report | Attendance Summary | Dec 27, 2021 | Mar 10, 2023 | ["tenant_code", "client_name", "team", "user_id", "member_full_name", "date", "lun_in", "lunch_time_out", "total_lunch_time", "day_out_time", "day_in_time", "work_start_time", "work_end_time", "total_hours_worked", "work_time", "total_consumed_breaks", "total_late_in_hours", "total_overtime_hours", "from_team"] |
| Microsoft Teams Groups - API | ODS Dataset which generated from Microsoft Teams Groups | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "group_id", "display_name", "description", "mail", "mail_enabled", "mail_nickname", "sync_time"] |
| Microsoft Teams Users - API | ODS Dataset which generated from Microsoft Teams Users | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "teams_user_id", "teams_display_name", "teams_mail", "is_admin", "teams_manager", "give_name", "surname", "job_title", "mobile_phone", "office_location", "preferred_language", "teams_original_mail", "user_principal_name", "creator", "create_date", "update_date", "situation", "status", "home_channel", "notify", "notify_time"] |
| member full name | for member full name slicer | Jan 18, 2022 | Dec 10, 2022 | ["username", "tenant_id"] |
| Task Prompter End of Day Update | Task Prompter End of Day Update | Jan 20, 2022 | Dec 11, 2023 | ["Name", "user_id", "begin_time", "Shift_Date", "end_time", "Schedule_Duration", "email_address", "to_clock_in_flag", "had_clocked_in_flag", "to_clock_out_flag", "late_time_in_mins", "late_time_out_mins", "Manager_Name", "Manager_email", "first_name", "last_name", "username", "tenant_code", "current_date", "Start_v", "End_v", "current_action", "tenant_id"] |
| Attendance Summary report New | Attendance Summary | Feb 08, 2022 | Nov 29, 2023 | ["tenant_code", "date", "user_id", "member_full_name", "member_email", "work_start_time", "work_end_time", "day_of_week", "from_team", "min_in_datetime", "min_in_time", "max_out_datetime", "max_out_time", "in_and_out", "total_hours_worked", "total_late_in_hours", "total_lunch_hours", "onsite_hours", "wfh_hours", "total_consumed_breaks1", "total_late_in_minutes", "total_consumed_breaks", "total_overtime_hours", "regular_hours_worked"] |
| Daily Availability - Form | To get data from form 'Daily Availability' | Feb 09, 2022 | Dec 10, 2022 | ["tenant_code", "technician", "sunday", "monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "weekly_billable_hours_goal", "total", "technician_name", "team_id", "team_name"] |
| Attendance Clock In and Clock Out | List all active users clock-in/clock-out time and shift time | Feb 17, 2022 | Oct 09, 2023 | ["first_name", "real_name", "email", "date", "shift_start", "shift_end", "clock_in_flag", "clock_out_flag", "log_time_in_min", "log_time_out_max", "work_day", "late_clock_in_min", "late_clock_out_min", "current_status"] |
| snapshot create Dataset Amount on Invoices Sent This Week (Snapshot) | dw Dataset which generated from widget 'Amount on Invoices Sent This Week (Snapshot)' | Feb 18, 2022 | Feb 21, 2023 | ["snapshot_date", "Total Amount"] |
| Punch card information | Punch card information sheet | Feb 24, 2022 | Jan 16, 2024 | ["Name", "current_time", "begin_time", "end_time", "first_name", "username", "to_clock_in_flag", "to_clock_out_flag", "manager_name", "manager_email"] |
| Attendance Adjustment Request Log | The dataset that lists the attendance adjustment request from the Attendance App from the last 60 days. | Apr 26, 2022 | Dec 10, 2022 | ["attendance_id", "request_time", "approve_time", "original_log_time", "log_time_updated", "comments", "status", "user_id", "user_name", "user_first_name", "user_last_name", "user_email", "manager_user_id", "manager_name", "manager_first_name", "manager_last_name", "manager_email"] |
| snapshot create Dataset Time Entered Today | dw Dataset which generated from widget 'Time Entered Today' | May 06, 2022 | Dec 10, 2022 | ["snapshot_date", "sum_hours_actual"] |
| snapshot create Dataset Utilization Snapshot | dw Dataset which generated from widget 'Utilization Snapshot' | May 06, 2022 | Dec 10, 2022 | ["snapshot_date", "Utilization"] |
| Client Portal Company List for Currently Logged in User | Client Portal Company List for Currently Logged in User | May 26, 2022 | Jun 02, 2022 | ["company_name"] |
| snapshot create Dataset Resolution Average - Daily | dw Dataset which generated from widget 'Resolution Average - Daily' | Jun 20, 2022 | Aug 02, 2023 | ["id", "snapshot_date", "avg_time_to_resolution"] |
| snapshot create Dataset New/Closed % - Daily | dw Dataset which generated from widget 'New/Closed % - Daily' | Jun 20, 2022 | Dec 10, 2022 | ["snapshot_date", "New/Closed %"] |
| snapshot create Dataset Ticket Update % - Daily | dw Dataset which generated from widget 'Ticket Update % - Daily' | Jun 20, 2022 | Dec 10, 2022 | ["snapshot_date", "Ticket Update %"] |
| snapshot create Dataset Average Time / Ticket - Daily | dw Dataset which generated from widget 'Average Time / Ticket - Daily' | Jun 20, 2022 | Dec 10, 2022 | ["snapshot_date", "avg_hours_actual"] |
| snapshot create Dataset % Over 5 Days - Daily t | dw Dataset which generated from widget '% Over 5 Days - Daily t' | Jun 20, 2022 | Dec 10, 2022 | ["snapshot_date", "% Over 5 Days"] |
| Request Time Off details | Request Time Off form details | Jul 12, 2022 | Jan 08, 2024 | ["id", "tenant_code", "create_time", "creator", "update_time", "creater_name", "real_name", "manager", "manager_email", "manager_username", "isadmin", "ismanager", "start_at", "end_at", "date_from", "date_to", "off_hours", "number_of_day", "timezone_id", "reason", "canceled", "message_switch", "status", "oneorall", "isedit", "approveid", "exception", "manageruserid", "ismanageruser", "isapprove", "issuperadmin"] |
| Next Ticket Activity - Last 90 days | This dataset shows all next ticket activities in the last 90 days | Jul 12, 2022 | Jan 31, 2023 | ["action_id", "user_id", "username", "name", "activity_date", "date", "ticket_id", "action", "action_type"] |
| Asset Users Last 90 days | This dataset extract assets that are viewed by tenant in the last 90 days | Jul 13, 2022 | Dec 10, 2022 | ["asset_id", "asset_name", "business_type", "type", "view_date", "visitor", "visitor_name", "visitor_username", "visitor_tenant"] |
| MSPF Benchmark Normalized EBITDA Form | Form list data | Jul 13, 2022 | Dec 10, 2022 | ["tenant_code", "month", "contribution", "draw_downs"] |
| snapshot create Dataset Datto Agents Without Recent Offsite (Snapshot) | dw Dataset which generated from widget 'Datto Agents Without Recent Offsite (Snapshot)' | Jul 27, 2022 | Dec 10, 2022 | ["snapshot_date", "ID Count"] |
| System Bot Modify records | Bot Modify records | Aug 18, 2022 | Oct 09, 2023 | ["operation_group", "operation_type", "status", "mode_type", "alert_type", "tenant_code", "operator", "operator_name", "operate_time", "business_id", "bot_name"] |
| MSPFinance Team Benchmarks Form | Dataset to return data from the MSPF Benchmarks input form | Aug 23, 2022 | Oct 06, 2023 | ["tenant_code", "date", "create_time", "pgm_1", "pgm_2", "pgm_3", "sga_1", "sga_2", "sga_3", "ebitda_1", "ebitda2", "ebitda_3", "ga_1", "ga_2", "ga_3", "bgm_1", "bgm_2", "bgm_3", "sc_1", "sc_2", "sc_3", "sgm_1", "sgm_2", "sgm_3"] |
| MCS Jira Issue - Client Facing | This dataset lists all MCS jira tickets based on the current login tenant. | Aug 24, 2022 | Dec 10, 2022 | ["ticket_id", "summary", "created_time", "age", "status_name", "update_time", "days_since_last_update", "closed_date", "reportor", "ticket_type", "description", "organization_name", "issue_id", "comment", "comment_create_date"] |
| MSPFinance Team Endpoints Form | MSP Finance Financial App Endpoints dataset. Manual input. | Sep 07, 2022 | Oct 06, 2023 | ["tenant_code", "month", "endpoints"] |
| Sys User | Sys User | Sep 30, 2022 | Feb 06, 2023 | ["id", "username", "password", "real_name", "head_url", "gender", "email", "mobile", "dept_id", "super_admin", "super_tenant", "status", "tenant_code", "creator", "create_date", "updater", "update_date", "first_name", "last_name", "manager_id", "timezone_id", "timezone_name", "timezone_offset", "reg_source", "update_source", "job_title", "office_location", "attendance_flag", "installed_teams_flag", "manual_flag", "manual_disable", "company_name", "home_page", "customer_id", "business_phones", "billed_user"] |
| snapshot create Dataset Tickets Not Updated - Last 48 Hours (Kaseya BMS) | dw Dataset which generated from widget 'Tickets Not Updated - Last 48 Hours (Kaseya BMS)' | Oct 06, 2022 | Dec 10, 2022 | ["snapshot_date", "ID Count"] |
| Generated Date Last 180 Days | Generated Date Last 180 Days | Oct 11, 2022 | Dec 10, 2022 | ["date"] |
| Predictive ML Model Financial Forecast | This dataset displays data from the predictive ML model form so it can be used in widgets. | Oct 19, 2022 | Dec 10, 2022 | ["tenant_code", "month", "cogs", "expense", "revenue", "gross_margin"] |
| Attendance Logs - Today and Yesterday | This dataset lists the attendance logs for today and yesterday. | Oct 26, 2022 | Dec 10, 2022 | ["username", "full_name", "log_time", "current_action"] |
| Microsoft Teams Channel Message - API | ODS Dataset which generated from Microsoft Teams Channel Message | Oct 28, 2022 | Oct 28, 2022 | ["id", "tenant_code", "sync_time", "other_id", "reply_to_id", "etag", "message_type", "created_date_time", "last_modified_date_time", "last_edited_date_time", "deleted_date_time", "subject", "summary", "chat_id", "importance", "locale", "web_url", "on_behalf_of", "policy_violation", "event_detail", "from_application", "from_device", "from_user_id", "from_user_display_name", "from_user_identity_type", "from_user_tenant_id", "body_content_type", "body_content", "channel_identity_team_id", "channel_identity_channel_id", "attachments", "mentions", "reactions", "group_id", "channel_id", "message_id"] |
| Microsoft Teams Joined Teams - API | ODS Dataset which generated from Microsoft Teams Joined Teams | Nov 01, 2022 | Nov 01, 2022 | ["id", "tenant_code", "other_id", "created_date_time", "display_name", "description", "internal_id", "classification", "specialization", "visibility", "web_url", "is_archived", "tenant_id", "is_membership_limited_to_owners", "member_settings", "guest_settings", "messaging_settings", "fun_settings", "discovery_settings", "summary", "sync_time"] |
| Microsoft Teams Channel Message reply - API | ODS Dataset which generated from Microsoft Teams Channel Message reply | Nov 01, 2022 | Nov 01, 2022 | ["id", "tenant_code", "sync_time", "other_id", "reply_to_id", "etag", "message_type", "created_date_time", "last_modified_date_time", "last_edited_date_time", "deleted_date_time", "subject", "summary", "chat_id", "importance", "locale", "web_url", "on_behalf_of", "policy_violation", "event_detail", "from_application", "from_device", "from_user_id", "from_user_display_name", "from_user_identity_type", "from_user_tenant_id", "body_content_type", "body_content", "channel_identity_team_id", "channel_identity_channel_id", "attachments", "mentions", "reactions", "teams_id", "channel_id", "message_id"] |
| snapshot create Dataset Stale Tickets (7 Days) - Autotask | dw Dataset which generated from widget 'Stale Tickets (7 Days) - Autotask' | Nov 04, 2022 | Dec 10, 2022 | ["snapshot_date", "> 7 day Tickets"] |
| N-able Geography Option | geography | Nov 13, 2022 | Feb 08, 2023 | ["id", "date_entered", "geography"] |
| N-able Currency Option | Currency | Nov 14, 2022 | Feb 08, 2023 | ["id", "date_entered", "currency"] |
| N-able Primary Market Option | Primary Market | Nov 14, 2022 | Feb 08, 2023 | ["id", "date_entered", "primary_market"] |
| N-able Benchmark User | N-able Benchmark Users For Headcount | Nov 29, 2022 | Jul 19, 2023 | ["user_id", "real_name", "job_title", "dept_name", "dept_id", "psa_user_id", "manager"] |
| Peer Group of current user | Peer Group of current user | Nov 29, 2022 | Dec 30, 2022 | ["id", "real_name", "username", "tenant_code", "tenant_name", "group_id", "group_peer", "peer_tenant_code", "peer_tenant"] |
| Peer group user info | Peer group user info | Nov 29, 2022 | Jan 27, 2023 | ["tenant_name", "group_peer", "id", "username", "password", "real_name", "head_url", "gender", "email", "mobile", "dept_id", "super_admin", "super_tenant", "status", "tenant_code", "creator", "create_date", "updater", "update_date", "first_name", "last_name", "manager_id", "timezone_id", "timezone_name", "timezone_offset", "reg_source", "update_source", "job_title", "office_location", "attendance_flag", "installed_teams_flag", "manual_flag", "manual_disable", "company_name", "home_page", "customer_id", "business_phones"] |
| Encore Benchmarking Employee Headcount | This dataset shows the manual data for the headcount of employees for the calculations in Encore Benchmarking. | Dec 19, 2022 | Jan 19, 2023 | ["company", "headcount", "service_headcount"] |
| Microsoft Teams User Presence - API | ODS Dataset which generated from Microsoft Teams User Presence | Jan 06, 2023 | Jan 06, 2023 | ["id", "tenant_code", "other_id", "availability", "activity", "out_of_office_settings_message", "is_out_of_office", "published_date_time", "expiry_date_time", "status_message_content", "status_message_content_type", "odata_context", "sync_time"] |
| Encore Accounting Mapping Manual Entry Data | This dataset pulls Accounting Mapping Manual Entry Data | Jan 23, 2023 | Feb 28, 2023 | ["id", "created_date", "created_by", "update_date", "update_by", "month", "account_id", "account_name", "amount", "report_type"] |
| Weekly usage user stats | Weekly user stats | Feb 01, 2023 | May 12, 2023 | ["week_date", "billable_users", "dashboard_user", "page_views", "attendance_user", "attendance_actions", "readers", "total_message", "next_ticket_user", "next_ticket_actions", "billable_users_added"] |
| Encore Strategic Peer Group List | A dataset listing the current user's peer group and the group members | Mar 14, 2023 | Apr 14, 2023 | ["tenant_name", "group_name"] |
| N-able Zero Out NSTE | A dataset listing members whose NSTE hours will be zero | Mar 16, 2023 | Oct 09, 2023 | ["data_content", "tb", "member", "zero_out"] |
| Client Asset Dashboard Requested | Client Asset Dashboard Request | Mar 22, 2023 | Aug 04, 2023 | ["tenant_code", "create_time", "update_time", "id", "uuid", "widget_name", "widget_url", "dashboard_name", "dashboard_url", "dataset_name", "dataset_url", "tenant_name", "dashboard_id", "dashboard_status", "bg_widget_count", "msp_widget_count", "msp_link", "complate_rate", "comment_id", "history_comment"] |
| Attendance Break Reminder | Break Reminder | Mar 23, 2023 | Oct 09, 2023 | ["user_id", "duration", "sub_action", "current_action", "log_time", "username", "now_time", "time_difference", "email", "first_name", "last_name"] |
| Time Off Request Notifier Bot | Time Off Request Notifier Bot | Mar 30, 2023 | May 03, 2023 | ["start_at", "end_at", "off_hours", "number_of_day", "reason", "canceled", "message_switch", "status", "create_time", "manager_email", "manager_name", "user_email", "user_name"] |
| Date Dimension | This dataset contains dates spanning the last 5 years, which can be used as a slicer to filter and analyze data within a specific time range. | Apr 14, 2023 | May 15, 2023 | ["month_date", "year_date", "year"] |
| User Work Schedule - Week | A dataset used to determine the schedule of the client's users by using the columns Start and End time of their shifts, schedule duration, day of the week and other columns needed. Scope of the schedule is all working days in a week | Apr 25, 2023 | Jun 07, 2023 | ["name", "schedule_duration", "begin_time", "end_time", "email_address", "manager_Name", "manager_email", "first_name", "last_name", "username", "day_of_week", "user_id", "identifier"] |
| User Manager | User Manager | May 30, 2023 | Jun 29, 2023 | ["real_name", "manager_name", "manager_id"] |
| idle Time bot | idle Time bot | Jun 09, 2023 | Aug 18, 2023 | ["firstname", "lastname", "real_name", "username", "tenantcode", "action", "is_ticket_staus", "is_ticket_time", "psa_type"] |
| Technology Marketing Toolkit Peer Group List | A dataset listing the current user's Technology Marketing Peer Group and the group members | Jun 16, 2023 | Jul 16, 2023 | ["tenant_name", "group_name"] |
| System Bot Email | Bot Email | Jun 28, 2023 | Oct 09, 2023 | ["name", "subject", "to_address", "create_date"] |
| snapshot create Dataset All Active Tickets - Daily | dw Dataset which generated from widget 'All Active Tickets - Daily' | Aug 02, 2023 | Aug 02, 2023 | ["id", "snapshot_date", "ticket_count"] |
| snapshot create Dataset 30 Day Response Average - Daily | dw Dataset which generated from widget '30 Day Response Average - Daily' | Aug 02, 2023 | Aug 02, 2023 | ["id", "snapshot_date", "avg_time_to_response"] |
| System Agent Client Info | Agent Client Info | Sep 15, 2023 | Dec 16, 2023 | ["id", "tenant_code", "tenant_name", "sync_time", "consume_time", "cpu", "memory", "cpu_set", "memory_set", "status", "processor_count", "last_disconnect_time", "max_run_thread_count", "pull_config_duration", "is_stop_task", "ip", "version", "install_time"] |
| Task Prompter Day Update | Handling the logic of going to and from work | Dec 25, 2023 | Jan 11, 2024 | ["Start_v", "End_v", "Start_v_with_timezone", "to_clock_in_flag", "had_clocked_in_flag", "late_time_in_mins", "late_time_out_mins", "Name", "user_timezone_id", "Start_v1", "End_v1", "current_date_with_timezone", "current_date_with_utc", "tenant_timezone", "weekDay", "Shift_Date", "Schedule_Duration", "email_address", "Manager_Name", "Manager_email", "first_name", "last_name", "username", "timezone_id", "timezone_offset", "timezone_name", "day_of_week", "user_id", "begin_time", "end_time", "tenant_code", "teamsuserid", "message", "curent_date", "current_action", "log_time", "tenant_id"] |