NXQL Data Model

Objects

application

An application is a sets of executables e.g. 'Microsoft Office'. Platforms:

Name

Type

Operating system

Properties

Description

company

string

Windows
macOS

–

Company producing the application

database_usage

permill

Windows
macOS

–

Percentage of the database used by information related with the application

description

string

Windows

–

Application description

first_seen

datetime

Windows
macOS

First time activity of the application was recorded on any device.

identifier

Windows
macOS

–

Unique application identifier

known_packages

string

Windows
macOS

–

List of packages known to contain the application. This list is not exhaustive: The presence of a package does not necessarily imply that on a given device the application was installed through that package.

last_seen

datetime

Windows
macOS

Last time activity of the application was recorded on any device.

name

string

Windows
macOS

–

Application name

platform

enum

Windows
macOS

–

The platform (operating system family) on which the application is running.

storage_policy

enum

Windows
macOS

–

Indicates the event storage policy for the application. Possible values are:

all: web requests, connections and executions are stored;
connections and executions;
executions;
none: no activity is recorded.

total_active_days

day

Windows
macOS

–

Total number of days the application was active.

binary

A binary is an executable binary files identified by its hash code. Platforms:

Name

Type

Operating system

Properties

Description

application_category

string

Windows
macOS

Indicates the category of the application:

'-': Not yet tagged;
Unknown: Not categorized by Nexthink Library.

application_company

string

Windows
macOS

–

Application company

application_name

string

Windows
macOS

–

Application name

architecture

enum

Windows
macOS

–

Executable architecture (32/64 bit)

average_cpu_usage

permill

Windows

–

Average CPU usage for the binary

average_memory_usage

byte

Windows

Average memory usage for the binary

average_number_of_graphical_handles

integer

Windows

Average number of graphical handles (GDI)

company

string

Windows
macOS

–

Executable company

database_usage

permill

Windows
macOS

–

Percentage of the database used by information related with the binary.

description

string

Windows

–

Description as it appears in the binary file.

executable_name

string

Windows
macOS

–

Executable name

file_size

byte

Windows
macOS

–

Binary file size

first_seen

datetime

Windows
macOS

First time activity of the binary was recorded on any device.

hash

md5

Windows
macOS

–

Hash code of the binary (MD5)

identifier

Windows
macOS

–

Unique binary identifier

last_seen

datetime

Windows
macOS

Last time activity of the binary was recorded on any device.

paths

path

Windows
macOS

–

List of paths of the binary

platform

enum

Windows
macOS

–

The platform (operating system family) on which the binary is running.

sha1

Windows
macOS

–

SHA-1 hash code of the binary

sha256

Windows
macOS

–

SHA-256 hash code of the binary

storage_policy

enum

Windows
macOS

–

Event storage policy for the binary (connection and execution, execution-only or none)

threat_level

enum

Windows
macOS

Indicates the threat level of the binary:

'-': Not yet tagged;
none detected: No known threat;
low: low threat;
intermediate: Intermediate threat;
high: high threat.

total_active_days

day

Windows
macOS

–

Total number of days the binary was active.

user_interface

boolean

Windows

–

Application has interactive user interface

version

Windows
macOS

–

Version of the binary

destination

A destination is a device or server receiving TCP/UDP connections. Platforms:

Name

Type

Operating system

Properties

Description

database_usage

permill

Windows
macOS

–

Percentage of the database used by information related with the destination

first_seen

datetime

Windows
macOS

First time activity to the destination was recorded on any device.

identifier

Windows
macOS

–

Unique destination identifier

ip_address

Windows
macOS

–

IP address for the destination

last_seen

datetime

Windows
macOS

Last time activity to the destination was recorded on any device.

name

string

Windows
macOS

–

Reverse lookup name

device

A device is Windows physical or virtual machine monitored by a Nexthink Collector. Platforms:

Name

Type

Operating system

Properties

Description

administrator_account_status

enum

Windows

–

Determines whether the local Administrator account is enabled or disabled.

all_antispywares

string

Windows

–

Summary information about all the detected antispyware:

unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

all_antiviruses

string

Windows

–

Summary information about all the detected antiviruses:

unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

all_firewalls

string

Windows

–

Summary information about all the detected firewalls:

unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

allow_non_provisionable_devices

boolean

–

Indicates whether a device which does not fully support the policy is still allowed to connect to the Exchange Exchange ActiveSync server. If 'yes', the security policy is not guaranteed to be applied, even if the field 'ActiveSync policy application status' value is 'applied in full'

antispyware_name

string

Windows

Name of the main antispyware

antispyware_rtp

enum

Windows

–

Indicates whether the antispyware real time protection (RTP) is active:

on: Indicates that RTP is active;
off: Indicates that either RTP is not active or no antispyware has been detected;
unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

antispyware_up_to_date

enum

Windows

–

Indicates whether the antispyware is up-to-date:

yes: Indicates that antispyware is up-to-date;
no: Indicates that either the antispyware is not up-to-date or no antispyware has been detected;
unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

antivirus_name

string

Windows

Name of the main antivirus

antivirus_rtp

enum

Windows

–

Indicates whether the antivirus real time protection (RTP) is active:

on: Indicates that RTP is active;
off: Indicates that either RTP is not active or no antivirus has been detected;
unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

antivirus_up_to_date

enum

Windows

–

Indicates whether the antivirus is up-to-date:

yes: Indicates that antivirus is up-to-date;
no: Indicates that either the antivirus is not up-to-date or no antivirus has been detected;
unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

audit_account_logon_events

enum

Windows

–

Determines whether to audit each instance of a user logging on to or logging off from another computer in which this computer is used to validate the account.

audit_account_management

enum

Windows

–

Determines whether to audit each event of account management on a computer.

audit_directory_service_access

enum

Windows

–

Determines whether to audit the event of a user accessing an Active Directory object that has its own system access control list (SACL) specified.

audit_logon_events

enum

Windows

–

Determines whether to audit each instance of a user logging on to or logging off from a computer.

audit_object_access

enum

Windows

–

Determines whether to audit the event of a user accessing an object, e.g. a file, folder, registry key, printer, and so forth - that has its own system access control list (SACL) specified.

audit_policy_change

enum

Windows

–

Determines whether to audit every incident of a change to user rights assignment policies, audit policies, or trust policies.

audit_privilege_use

enum

Windows

–

Determines whether to audit each instance of a user exercising a user right.

audit_process_tracking

enum

Windows

–

Determines whether to audit detailed tracking information for events such as program activation, process exit, handle duplication, and indirect object access.

audit_system_events

enum

Windows

–

Determines whether to audit when a user restarts or shuts down the computer or when an event occurs that affects either the system security or the security log.

average_boot_duration

millisecond

Windows

Full boot duration baseline

average_fast_startup_duration

millisecond

Windows

Indicated the fast startup boot duration averaged over the fast startups. In the calculation, recent boots weigh more than older boots (exponentially weighted moving average).

average_logon_duration

millisecond

Windows

User logon duration baseline

bios_serial_number

string

Windows
macOS

BIOS serial number

boot_disk_health_status

enum

Windows

Indicates the health of the disk from which the device is booting [from], as reported by the operating system.

boot_disk_type

enum

Windows
macOS

Indicates the type of the disk from which the device is booting.

chassis_serial_number

string

Windows

Chassis serial number

cltr_ca_license_uid

string

Windows
macOS

Indicates the Collector assignment license UID

cltr_ca_status

enum

Windows
macOS

Indicates whether Collector assignment service is enabled or disabled

cltr_crash_guard_count

integer

Windows

Indicates the number of consecutive hard resets or system crashes of the device

cltr_crash_guard_limit

integer

Windows

Indicates the Collector CrashGuard limit

cltr_crash_guard_protection_interval

integer

Windows

Indicates the CrashGuard monitoring interval in minutes

cltr_crash_guard_react_interval

integer

Windows

Indicates the Collector CrashGuard reactivation interval in hours

cltr_custom_shells

enum

Windows

Indicates whether the Collector reports user logon events and user interactions in virtualized and embedded (kiosk mode) environments

cltr_data_channel_protocol

enum

Windows
macOS

Specifies if the Collector data is sent over TCP or UDP

cltr_dns_res_preference

enum

Windows

Indicates the DNS resolution preference for Collector in terms of IP protocol version on the device

cltr_engage_service_status

enum

Windows
macOS

Indicates whether Engage is enabled or disabled

cltr_freezes_monitoring

enum

Windows

Indicates whether the Collector is monitoring for unresponsive applications on the device

cltr_installs_scan_interval

integer

Windows

Indicates the interval, in hours, after which the Collector checks for newly installed packages and updates

cltr_is_visible

enum

Windows

Indicates whether Collector is hidden in the "Add or Remove Programs"

cltr_log_level

enum

Windows
macOS

Indicates the Collector log level

cltr_max_segment_size

integer

Windows

Indicates the maximum segment size of packets sent by Collector

cltr_ra_execution_policy

enum

Windows

Indicates the Powershell script execution policy

cltr_smb_print_mon_status

enum

Windows

Indicates whether SMB printing monitoring is enabled or disabled

cltr_string_tag

string

Windows
macOS

Indicates the Collector string tag

cltr_web_mon_status

enum

Windows

Indicates whether Web & Cloud monitoring is enabled or disabled

collector_distinguished_name

string

Windows

Indicates the distinguished name (DN) as seen:

For Windows: In Active Directory (AD). if no connection with AD is set up, a '-' is displayed;
For Mobile: In the Exchange ActiveSync server Note that this DN is reported by the Collector.

collector_installation_log

string

Windows

Link to the last Nexthink Collector installation error log

collector_package_target_version

version

Windows
macOS

Indicates the Collector package version that is targeted.

collector_print_monitoring_status

enum

Windows

Indicates whether the Collector printing monitoring is enabled or disabled

collector_status

enum

Windows
macOS

Indicates the status of the Nexthink Collector package installed on the device:

unmanaged: the Collector is not automatically updated
up-to-date: the Collector is up-to-date
outdated: a newer Collector version is available.

collector_tag

integer

Windows

–

Collector installation tag

collector_update_status

enum

Windows

–

Current status of Nexthink Collector Updater

collector_version

version

Windows
macOS

–

Version number of Nexthink Collector installation

cpu_frequency

mhz

Windows
macOS

CPU frequency

cpu_model

string

Windows
macOS

CPU model

database_usage

permill

Windows
macOS

–

Percentage of the database used by information related with the device

device_encryption_required

boolean

–

Indicates whether device encryption is required.

device_manufacturer

string

Windows
macOS

Indicates the device manufacturer.

device_model

string

Windows
macOS

Indicates the model of the device.

device_password_required

boolean

–

Indicates whether a password is required on the device.

device_product_id

string

Windows
macOS

Device product ID

device_product_version

string

Windows
macOS

Device product version

device_serial_number

string

Windows
macOS

Indicates the device serial number.

device_type

enum

Windows
macOS

–

Type of device (desktop, laptop, server, mobile)

device_uid

md5

Windows
macOS

–

Indicates the universally unique identifier (based on Engine name and device ID)

device_uuid

string

Windows
macOS

–

Indicates the device universally unique identifier (UUID)

directory_service_site

string

Windows

Site (or location) of an Active Directory (AD) service

disks_manufacturers

string

Windows

–

Hard disks manufacturers

disks_smart_index

percent

Windows

Lowest S.M.A.R.T. index of installed hard disks (index is based on S.M.A.R.T. attributes)

distinguished_name

string

Windows

Indicates the distinguished name (DN) as seen:

For Windows: In Active Directory (AD). if no connection with AD is set up, a '-' is displayed;
For Mobile: In the Exchange ActiveSync server

eas_access_state

enum

–

Indicates whether the device can access the Exchange ActiveSync server. The possible states are:

allowed: the device has access;
blocked: the device is blocked;
discovery: the device is temporary quarantined while it is being identified by the Exchange ActiveSync server;
quarantined: the device is waiting for Exchange ActiveSync administrator approval.

eas_access_state_reason

enum

–

Indicates the reason for the device access state. The possible values are:

global: caused by the global access settings;
device rule: caused by a device access rule;
individual: caused by an individual exemption;
policy: caused by Exchange ActiveSync policy.

eas_device_access_rule

string

–

Indicates the name of the access rule. An access rule allows, blocks or quarantines devices based on the device type, model, OS or user agent characteristics.

eas_device_identity

string

–

Indicates the identity of the device in Exchange ActiveSync Server.

eas_exemption

enum

–

Indicates whether a personal exemption is set for the device and its user. Possible values are:

none;
allow;
block.

eas_policy_application_status

enum

–

Indicates whether the Exchange ActiveSync policy is applied or not. Possible values are:

not applied;
applied in full: the policy is applied (unless the field 'Allow non provisionable devices' value is 'yes');
partially applied.

eas_policy_name

string

–

Indicates the name of the Exchange ActiveSync policy applied to the user's mailbox.

eas_policy_update

datetime

–

Indicates the last time the Exchange ActiveSync policy was updated on the device.

email_attachment_enabled

boolean

–

Indicates whether attachments can be downloaded to the mobile device through the Exchange ActiveSync protocol.

enforce_password_history

integer

Windows

Indicates the number of unique passwords that have to be associated with a user account before an old password can be reused.

entity

string

Windows
macOS

–

Entity

extended_logon_duration_baseline

millisecond

Windows

Extended logon duration baseline

firewall_name

string

Windows

Name of the main firewall

firewall_rtp

enum

Windows

–

Indicates whether the firewall real time protection (RTP) is active:

on: Indicates that RTP is active;
off: Indicates that either RTP is not active or no firewall has been detected;
unknown: Indicates that the information could not be retrieved;
N/A: This field is not available on this operating system;
'-': No data, incompatible collector version or the data is not yet available.

first_seen

datetime

Windows
macOS

Indicates the first time when the activity of the device was recorded:

For Windows and Mac OS: The first time Collector reported activity;
For Mobile: The first time the device was reported with a successful synchronization.

graphical_card_ram

byte

Windows

Amount of RAM of the graphical card with most RAM

graphical_cards

string

Windows

–

Installed graphical cards

group_name

string

Windows
macOS

Name of computer domain or workgroup

guest_account_status

enum

Windows

–

Determines if the Guest account is enabled or disabled.

hard_disks

string

Windows
macOS

List of all hard disks

identifier

Windows
macOS

–

Unique device identifier

internet_security_settings

enum

Windows

–

Internet security settings (ok, at risk or unknown)

ip_addresses

ip_address

Windows
macOS

–

List of IP addresses for the device

is_collector_distinguished_name_truncated

boolean

Windows

–

Flag indicating whether the collector DN is truncated or not

is_directory_service_site_truncated

boolean

Windows

–

Flag indicating whether the DS site is truncated or not

last_boot_duration

millisecond

Windows

Last boot time duration

last_extended_logon_duration

millisecond

Windows

Last extended logon duration

last_ip_address

ip_address

Windows
macOS

Last IP address assigned to the device

last_known_connection_status

enum

Windows
macOS

Indicates the last known connection status of the device:

udp: the device successfully connected via UDP but not TCP.
tcp: the device successfully connected via TCP but not UDP.
udp_tcp: the device successfully connected via both UDP and TCP.
'-': Collector version is below V6.6.

last_local_ip_address

ip_address

Windows
macOS

Last local IP address assigned to the device

last_logged_on_user

string

Windows

Last logged on user

last_logon_duration

millisecond

Windows

Last user logon duration

last_logon_time

datetime

Windows

Last logon time

last_seen

datetime

Windows
macOS

Indicates the last time that activity on the device was reported:

For Windows and Mac OS: The last time Collector reported activity through the UDP channel,
For Mobile: The last time the device successfully synchronized with the Mobile Bridge.

last_seen_on_tcp

datetime

Windows
macOS

Indicates the last time that the device was successfully connected through the TCP channel.

'-': The Collector is an older version that does not support TCP.

last_system_boot

datetime

Windows
macOS

Last boot time

last_update

datetime

Windows
macOS