MSPBots WIKI : Time Doctor Public Datasets
Here are the published or Alpha version Time Doctor datasets that you can use to create the widgets and dashboards
In total, there are 8 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| Timedoctor Hours by Employee_2 | Timedoctor hours by employee | May 23, 2021 | Dec 10, 2022 | ["tenant_code", "start_time", "end_time", "timedoctor_user_name", "duration", "Hour_in_Decimal"] |
| Employee Performance | Employee Performance | Nov 04, 2021 | Feb 16, 2023 | ["user_id", "name", "username", "real_name", "team_name", "tenant_id", "from_date", "idle_mins", "total_mins", "idle_mins_ratio", "id"] |
| TimeDoctor2 Work Logs - API | ODS Dataset which generated from TimeDoctor2 Work Logs | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "start_time", "end_time", "timedoctor_user_id", "timedoctor_user_name", "sys_user_id", "duration", "sync_time"] |
| TimeDoctor2 Users - API | ODS Dataset which generated from TimeDoctor2 Users | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "user_id", "email", "role", "hired_at", "timezone", "name", "employee_id", "exists", "active", "screenshots", "videos", "work_check_interval", "allow_edit_time", "poor_timeuse_popup", "allow_delete_screenshots", "tasks_mode", "tracking_mode", "tracking_type", "show_on_reports", "email_reports", "blur_screenshots", "signup_step", "strip_url_query", "allow_admin_sid", "hide_screencasts", "payroll_access", "payroll_feature", "allow_manager_tag_categories", "force_autostart", "email_confirmed", "created_at", "profile_timezone", "status", "creator", "create_date", "update_date"] |
| TimeDoctor2 Projects - API | ODS Dataset which generated from TimeDoctor2 Projects | Mar 10, 2023 | Mar 10, 2023 | ["id", "tenant_code", "sync_time", "other_id", "name", "scope", "weight", "deleted", "creator_id"] |
| TimeDoctor2 Tasks - API | ODS Dataset which generated from TimeDoctor2 Tasks | Mar 10, 2023 | Mar 10, 2023 | ["id", "tenant_code", "sync_time", "other_id", "name", "status", "deleted", "folders", "project_id", "reporter_id", "integration_provider"] |
| TimeDoctor2 Companies - API | ODS Dataset which generated from TimeDoctor2 Companies | Mar 10, 2023 | Mar 10, 2023 | ["id", "tenant_code", "other_id", "sync_time", "name", "locked", "archived", "parent_id", "settings_name", "settings_active", "settings_rdbms_status", "settings_videos", "settings_exists", "settings_weekend_work_included", "settingstoo_many_hours_value", "settingstoo_many_hours_included", "settings_late_hours_after_included", "settings_hours_outside_shift_work_value", "settings_hours_outside_shift_work_included", "settings_tasks_mode", "settings_employee_id", "settings_signup_step", "settings_can_edit_time", "settings_screenshots", "settings_allow_no_break", "settings_email_reports", "settings_tracking_mode", "settings_tracking_type", "settings_allow_admin_sid", "settings_allow_edit_time", "settings_billing_access", "settings_payroll_access", "settings_show_on_reports", "settings_strip_url_query", "settings_first_day_of_week", "settings_force_autostart", "settings_payroll_feature", "settings_blur_screenshots", "settings_hide_screencasts", "settings_poor_timeuse_popup", "settings_track_connectivity", "settings_web_and_app_tracking", "settings_work_check_interval", "settings_screencasts_feature", "settings_work_schedule_feature", "settings_allow_delete_screenshots", "settings_allow_manager_invite_users", "settings_who_can_access_screenshots", "settings_allow_manager_projects_tasks", "settings_allow_manager_tag_categories", "settings_allow_manager_work_schedules", "settings_track_internet_connectivity", "settings_tracked_data_retention_period", "timezone", "created_at", "creator_id", "split_test", "user_count", "description", "pricing_plan", "no_workspaces", "old_company_id", "subscription_plan", "subscription_status", "subscription_expires", "user_discount", "all_users_tag_id", "force_user_count", "only_domains_for", "unique_user_count", "min_billable_users", "settings_late_hours_after_value"] |
| Time Doctor Summary | This dataset will show your employees' time summary | Mar 23, 2023 | Jun 16, 2023 | ["user_id", "from_date", "from_date_offset", "to_date", "idle_sec", "idle_mins", "idle_sec_ratio", "idle_mins_ratio", "total_mins", "total_hours", "mode_total", "email", "name", "employee_id", "active", "sys_name", "sys_email", "team_name", "sys_user_id"] |