MSPBots WIKI : Datto RMM Public Datasets
Here are the published or Alpha version Datto RMM datasets that you can use to create the widgets and dashboards
If you need some dataset that is not listed here, please check with https://rmm.datto.com/help/en/Content/2SETUP/APIv2.htm, find the API call, then submit a ticket to support@mspbots.ai , typically, we can get the dataset in about 2-3 business days.
In total, there are 11 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| Datto RMM Machine Statistics | This dataset contains a listing of all the machines in your AEM account. | Nov 30, 2021 | Jan 17, 2024 | ["domain", "site", "device_class", "suspended", "id", "last_reboot", "local_ip", "hostname", "x64_bit", "device_type", "device_category", "online", "external_ip", "description", "last_logged_user", "created_date", "age", "displayversion", "last_audit_date", "reboot_required", "operating_system", "last_seen", "sysinfo_dot_net_version", "sysinfo_manufacturer", "sysinfo_model", "sysinfo_total_cpu_cores", "sysinfo_total_physical_memory", "sysinfo_username", "board_manufacturer", "board_product", "av_status", "patch_status", "patches_approved_pending", "patches_installed", "patches_not_approved", "site_description", "processors", "company_name", "os_type", "antivirus_product", "warranty_date", "mapped_company_name"] |
| Datto RMM Devices - API | ODS Dataset which generated from Datto RMM Devices | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "other_id", "devices_id", "sync_time", "uid", "site_id", "site_uid", "site_name", "devices_type", "devices_type_category", "hostname", "int_ip_address", "operating_system", "last_logged_in_user", "domain", "cag_version", "display_version", "ext_ip_address", "description", "a64_bit", "reboot_required", "online", "suspended", "deleted", "last_seen", "last_reboot", "last_audit_date", "creation_date", "snmp_enabled", "device_class", "portal_url", "warranty_date", "antivirus_product", "antivirus_status", "patch_status", "patches_approved_pending", "patches_not_approved", "patches_installed", "udf"] |
| Datto RMM Audit Data - API | ODS Dataset which generated from Datto RMM Audit Data | Jan 25, 2022 | Jan 25, 2022 | ["id", "tenant_code", "other_id", "device_id", "sync_time", "portal_url", "mobile_info", "snmp_info", "system_info_manufacturer", "system_info_model", "system_info_username", "system_info_total_physical_memory", "bios_instance", "bios_serial_number", "base_board_product"] |
| Datto Alerts Lite | This dataset reports on all open alerts and alerts resolved in the last 14 days. | Apr 28, 2022 | Jun 06, 2023 | ["id", "ticket_created", "resolved", "resolved_on", "autoresolve_mins", "muted", "timestamp", "ticket_number", "alert_description", "alert_sample", "alert_text", "alert_class", "priority", "site", "device_name", "diagnostics", "resolved_by", "hours_to_resolve", "hours_open", "operating_system", "reboot_required", "last_seen", "last_logged_in_user", "devices_type", "device_category", "device_class", "domain", "alert_context_status"] |
| Datto RMM Application Data | This is a listing of all software installations detected by AEM. | Apr 29, 2022 | Feb 08, 2023 | ["id", "version", "application", "site", "device_class", "devices_type", "devices_type_category", "device_host_name", "operating_system"] |
| Datto Alerts Resolved Last 240 Days | The dataset contains data on all opened alerts and alerts resolved in the last 240 days. | Apr 29, 2022 | Jun 06, 2023 | ["id", "ticket_created", "resolved", "resolved_on", "autoresolve_mins", "muted", "timestamp", "ticket_number", "alert_description", "alert_sample", "alert_text", "alert_class", "priority", "site", "device_name", "diagnostics", "resolved_by", "hours_to_resolve", "hours_open", "operating_system", "reboot_required", "last_seen", "last_logged_in_user", "devices_type", "device_category", "device_class", "domain", "alert_context_status"] |
| Datto RMM Disk Statistics | This dataset contains a listing of all the machines and disks in your AEM account. | May 27, 2022 | Feb 08, 2023 | ["id", "device_id", "hostname", "domain", "site", "device_class", "description", "last_audit_date", "latest_audit", "disk_description", "disk_idenitifier", "disk_free_space", "used_space", "percent_used", "percent_free", "space_used_range", "devices_type", "operating_system", "devices_type_category"] |
| Datto RMM Sites - API | ODS Dataset which generated from Datto RMM Sites | Dec 08, 2022 | Dec 08, 2022 | ["id", "tenant_code", "sync_time", "other_id", "uid", "account_uid", "name", "description", "notes", "on_demand", "splashtop_auto_install", "proxy_settings_host", "proxy_settings_password", "proxy_settings_port", "proxy_settings_type", "proxy_settings_username", "number_of_devices", "number_of_online_devices", "number_of_offline_devices", "autotask_company_name", "autotask_company_id", "portal_url"] |
| Datto RMM Audit Device Software | ODS Dataset which generated from Datto RMM Audit Device Software | Jan 31, 2023 | Jan 31, 2023 | ["id", "tenant_code", "device_id", "name", "version"] |
| Datto RMM Activity Logs - API | ODS Dataset which generated from Datto RMM Activity Logs | Oct 13, 2023 | Oct 13, 2023 | ["id", "tenant_code", "device_id", "site_id", "date", "datetime", "sync_time", "other_id", "entity", "category", "action", "site_name", "hostname", "duser", "details", "has_std_out", "has_std_err"] |
| Datto RMM Machine Stats Lite | This dataset contains a listing of all the machines in your AEM account. | Dec 06, 2023 | Jan 05, 2024 | ["domain", "site", "device_class", "suspended", "id", "last_reboot", "local_ip", "hostname", "x64_bit", "device_type", "device_category", "online", "external_ip", "description", "last_logged_user", "created_date", "displayversion", "last_audit_date", "reboot_required", "operating_system", "last_seen", "patch_status", "patches_approved_pending", "patches_installed", "patches_not_approved", "site_description"] |