MSPBots WIKI : NinjaOne Public Datasets
Here are the published or Alpha version NinjaOne datasets that you can use to create the widgets and dashboards
In total, there are 29 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
NinjaOne Software Patch Installs | A dataset which returns 3rd party software patch installation history records (successful and failed). This has no date range limitation and diff syncs pull in the last 1 day worth of data. | Aug 23, 2022 | Jan 12, 2023 | ["id", "product_identifier", "title", "impact", "status", "type", "installed_at_utc", "device_id", "time_stamp_utc", "node_class", "organization_id", "system_name", "dns_name", "organization_name"] |
NinjaOne Devices | Returns list of devices (basic node information). No date range limitation and diffs return the last 1 day worth of data. | Aug 23, 2022 | Nov 22, 2023 | ["id", "organization_id", "location_id", "node_class", "approval_status", "offline", "system_name", "dns_name", "os_name", "created", "age_in_years", "last_contact", "organization_name", "device_name", "location_name", "created_utc", "maintenance_status", "maintenance_start", "maintenance_end", "mapped_company_name"] |
NinjaOne Disks | A dataset containing the information about the physical disks. This has no date range limitation and diffs return the last 1 day worth of data. | Aug 23, 2022 | Dec 10, 2022 | ["id", "bytes_per_sector", "description", "interface_type", "device_id", "manufacturer", "timestamp", "media_type", "node_class", "model", "disk_name", "partition_count", "serial_number", "size", "status", "smart_capable", "system_name", "dns_name", "organization_id", "organization_name"] |
NinjaOne Alerts - API | ODS Dataset which generated from NinjaOne Alerts | Aug 24, 2022 | Aug 24, 2022 | $row.get($key) |
NinjaOne Software - API | ODS Dataset which generated from NinjaOne Software | Aug 24, 2022 | Aug 24, 2022 | $row.get($key) |
NinjaOne Antivirus Status | Returns list of statuses of antivirus software installed on devices. No date range limitation and diff syncs return the last 1 day worth of data. | Aug 24, 2022 | Dec 10, 2022 | ["id", "definition_status", "product_state", "product_name", "device_id", "version", "time_stamp", "node_class", "organization_id", "system_name", "organization_name"] |
NinjaOne Operating Systems - API | ODS Dataset which generated from NinjaOne Operating Systems | Aug 24, 2022 | Aug 24, 2022 | ["id", "tenant_code", "devices_id", "sync_time", "manufacturer", "name", "architecture", "last_boot_time_date", "build_number", "release_id", "service_pack_major_version", "service_pack_minor_version", "locale", "language", "needs_reboot", "timestamp_date"] |
NinjaOne - Operating Systems | Returns operating systems' for devices. No date range limitation and diff syncs return the last 1 day worth of data. | Aug 24, 2022 | Oct 26, 2023 | ["id", "mspbots_id", "architecture", "build_number", "language", "devices_id", "last_boot_time_date", "locale", "manufacturer", "os_name", "needs_reboot", "release_id", "service_pack_major_version", "timestamp", "service_pack_minor_version", "node_class", "organization_id", "dns_name", "organization_name", "system_name"] |
NinjaOne Organizations Detailed - API | ODS Dataset which generated from NinjaOne Organizations Detailed | Aug 24, 2022 | Aug 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "description", "userdata", "node_approval_mode", "tags", "fields", "locations", "policies", "trayicon_product", "trayicon_enabled", "trayicon_targets", "trayicon_options", "splashtop_product", "splashtop_enabled", "splashtop_targets", "splashtop_options", "teamviewer_product", "teamviewer_enabled", "teamviewer_targets", "teamviewer_options", "backup_product", "backup_enabled", "backup_targets", "backup_options", "psa_product", "psa_enabled", "psa_targets", "psa_options"] |
NinjaOne Software Patches - API | ODS Dataset which generated from NinjaOne Software Patches | Aug 24, 2022 | Aug 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "type", "title", "impact", "status", "device_id", "timestamp", "product_identifier", "timestamp_utc"] |
NinjaOne - Software | Returns the list of software installed on devices. No date range limitation and diff syncs pull in the last 1 day worth of data. | Aug 24, 2022 | Nov 22, 2023 | ["id", "install_date", "location", "software_name", "device_id", "publisher", "timestamp", "version", "node_class", "organization_id", "system_name", "dns_name", "organization_name", "last_logged_in_user"] |
NinjaOne Device - API | ODS Dataset which generated from NinjaOne Device | Aug 24, 2022 | Aug 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "organization_id", "location_id", "node_class", "node_role_id", "role_policy_id", "approval_status", "offline", "system_name", "dns_name", "created", "last_contact", "last_update", "created_utc", "last_contact_utc", "last_update_utc"] |
NinjaOne Software Patch Install - API | ODS Dataset which generated from NinjaOne Software Patch Install | Aug 24, 2022 | Aug 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "type", "title", "impact", "status", "device_id", "time_stamp", "product_identifier", "time_stamp_utc", "installed_at", "installed_at_utc"] |
NinjaOne Antivirus Statue - API | ODS Dataset which generated from NinjaOne Antivirus Statue | Aug 24, 2022 | Aug 24, 2022 | ["id", "tenant_code", "sync_time", "device_id", "product_name", "product_state", "definition_status", "version", "time_stamp", "time_stamp_utc"] |
NinjaOne Os Patches - API | ODS Dataset which generated from NinjaOne Os Patches | Aug 24, 2022 | Aug 24, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "type", "status", "device_id", "severity", "timestamp"] |
NinjaOne - Alerts | A dataset which returns the list of active alerts/triggered conditions. This has no date range limitation and diff syncs return the last 1 day worth of data. | Aug 24, 2022 | Dec 10, 2022 | ["id", "device_id", "message", "create_time", "update_time", "source_config_uid", "source_name", "subject", "system_name", "organization_id", "organization_name"] |
NinjaOne OS Patches Not Installed | Returns list of OS patches for which there were no installation attempts. No date range limitation and diff syncs pull in the last 1 day worth of data. | Aug 24, 2022 | Oct 17, 2023 | ["id", "ospatch_name", "device_id", "severity", "timestamp", "node_class", "status", "type", "organization_id", "system_name", "dns_name", "organization_name", "mapped_company_name"] |
NinjaOne Os Patch Installs - API | ODS Dataset which generated from NinjaOne Os Patch Installs | Sep 09, 2022 | Sep 09, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "status", "installed_at", "device_id", "timestamp", "kb_number"] |
NinjaOne - OS Patch Installs | A dataset containing the OS Patch installation report per device. No date range limitation on full syncs and diff syncs will pull in the last 1 day worth of data. | Sep 09, 2022 | Jan 12, 2023 | ["id", "os_patch_install_name", "status", "installed_at", "device_id", "timestamp", "kb_number", "node_class", "organization_id", "system_name", "dns_name", "organization_name"] |
NinjaOne Locations | ODS Dataset which generated from NinjaOne Locations | Dec 06, 2022 | Dec 06, 2022 | ["id", "tenant_code", "other_id", "organization_id", "name", "address", "description", "sync_time"] |
NinjaOne Device Custom Fields | ODS Dataset which generated from NinjaOne Device Custom Fields | Jan 28, 2023 | Jan 28, 2023 | ["id", "tenant_code", "sync_time", "device_id", "wlanwarnings", "wlanfailures", "win11capable", "ni_cadapters_under1gbps", "wlan_disconnect_reasons", "warranty_expiration_date", "warranty_expiration_date_time", "purchase_date", "purchase_date_time", "windows_license_status", "public_ip_asn", "public_ip_geo", "domjoinstatus", "do_mad_name", "public_ip_address", "app_is_controlinstalled", "filewindows_old", "ram_max_capable_ram", "ram_current_ram", "ram_slots_used", "ram_available_slots", "dom_azad_tenant", "ram_detail", "win11check_details", "windows11_compatibility", "network_adapters_under1_gbps", "pwr_battery_health", "pwrfull_charge_cyles", "pwrhas_battery", "pwr_secondary_battery", "pwr_battery_id", "pwr_default_max_capacity", "pwr_current_max_capacity", "wintop_disk_consumers", "svr_scheduled_reboot_always", "svr_scheduled_reboot_window", "server_uptime", "profilelist"] |
NinjaOne Devices History | Historical data of NinjaOne devices including the devices that have been deleted. | Apr 25, 2023 | Jun 12, 2023 | ["id", "system_name", "dns_name", "created_utc", "last_update_utc", "last_contact_utc", "organization_id", "organization_name", "offline", "display_name", "netbios_name", "manufacturer", "os_name", "os_architecture", "last_boot_time", "system_manufacturer", "system_model", "system_serial_number", "last_logged_in_user", "device_type", "location_name", "delete_time", "deleted_flag"] |
NinjaOne Volumes - API | ODS Dataset which generated from NinjaOne Volumes | May 09, 2023 | May 09, 2023 | ["id", "tenant_code", "sync_time", "name", "drive_letter", "label", "device_type", "file_system", "auto_mount", "compressed", "capacity", "free_space", "serial_number", "device_id", "timestamp", "timestamp_utc"] |
NinjaOne Device Volumes | This dataset displays the disk volume report per device. | May 15, 2023 | Oct 17, 2023 | ["drive_id", "computer_id", "system_name", "company_name", "location_name", "device_type", "asset_date", "total_memory", "cpu", "main_drive", "drive_free_space_gb", "drive_total_capacity_gb", "drive_used_space_gb", "percent_drive_space_used", "percent_drive_space_free", "serial_number", "age_in_years", "last_boot_time", "last_user", "model", "os_name", "os_version", "manufacturer", "node_class", "last_contact_utc", "offline", "mapped_company_name"] |
NinjaOne raid controllers - API | ODS Dataset which generated from NinjaOne raid controllers | May 24, 2023 | May 24, 2023 | ["id", "tenant_code", "sync_time", "backup_battery_status", "battery_temperature", "bios_version", "cache_size", "controller_index", "driver_name", "driver_version", "family", "firmware_version", "hardware_revision", "manufacturer", "manufacturing_date", "manufacturing_date_time", "model", "physical_drive_count", "slot", "system_health_status", "virtual_drive_count", "device_id", "timestamps", "timestamp_time"] |
NinjaOne Roles - API | ODS Dataset which generated from NinjaOne Roles | Jun 20, 2023 | Jun 20, 2023 | ["id", "tenant_code", "sync_time", "other_id", "name", "node_class", "chassis_type", "custom", "description", "tags", "created", "created_time"] |
NinjaOne Device Network Interfaces | ODS Dataset which generated from NinjaOne Device Network Interfaces | Jul 25, 2023 | Jul 25, 2023 | ["id", "tenant_code", "sync_time", "device_id", "adapter_name", "default_gateway", "interface_type", "dns_host_name", "dns_servers", "interface_index", "interface_name", "ip_address", "link_speed", "mac_address", "mtu", "status", "subnet_mask"] |
NinjaOne Antivirus Threats - API | ODS Dataset which generated from NinjaOne Antivirus Threats | Jan 16, 2024 | Jan 16, 2024 | ["id", "tenant_code", "threat_id", "name", "product_code", "quarantine_id", "status", "type", "category", "level", "detection_source", "trace_list", "device_id", "time_stamp", "time_stamp_utc", "sync_time"] |
NinjaOne Antivirus Threats | Returns list of antivirus threats. No date range limitation and diff syncs return the last 1 day worth of data. | Jan 17, 2024 | Jan 17, 2024 | ["id", "antivirus_threat_name", "product_code", "status", "type", "threat_id", "category", "level", "detection_source", "device_id", "timestamp", "system_name", "organization_id", "organization_name"] |