...
| Expand | ||
|---|---|---|
| ||
|
How is the data sent to Devo?
Use the JumpCloud collector.
Table structure
This is the set of columns displayed by this union table, which is the result of the collection of columns present in all source tables:
| Note |
|---|
Extra fields Fields marked as Extra in the table below are not shown by default in data tables and need to be explicitly requested in the query. You can find them marked as Extra when you perform a query so they can be easily identified. Learn more about this in Selecting unrevealed columns. |
Field | Type | Field transformation | Source field name | Extra fields | ||
|---|---|---|---|---|---|---|
eventdate |
|
|
| |||
source |
|
|
| |||
hostname |
|
|
| |||
initiated_by__id |
|
|
| |||
initiated_by__type |
|
|
| |||
initiated_by__email |
|
|
| |||
initiated_by__username |
|
|
| |||
geoip__country_code |
|
|
| |||
geoip__timezone |
|
|
| |||
geoip__latitude |
|
|
| |||
geoip__continent_code |
|
|
| |||
geoip__region_name |
|
|
| |||
geoip__region_code |
|
|
| |||
geoip__longitude |
|
|
| |||
resource__id |
|
|
| |||
resource__type |
|
|
| |||
resource__username |
|
|
| |||
changes |
|
|
| |||
auth_method |
|
|
| |||
event_type |
|
|
| |||
provider |
|
|
| |||
service |
|
|
| |||
organization |
|
|
| |||
at_version |
|
|
| |||
client_ipv4 |
|
| my_client_ip | |||
client_ipv6 |
|
| my_client_ip | |||
id |
|
|
| |||
user_agent__patch |
|
|
| |||
user_agent__minor |
|
|
| |||
user_agent__os |
|
|
| |||
user_agent__major |
|
|
| |||
user_agent__build |
|
|
| |||
user_agent__name |
|
|
| |||
user_agent__os_name |
|
|
| |||
user_agent__device |
|
|
| |||
timestamp |
|
|
| |||
err |
|
|
| |||
error_message |
|
|
| |||
start_tls |
|
|
| |||
tls_established |
|
|
| |||
dn |
|
|
| |||
mech |
|
|
| |||
connection_id |
|
|
| |||
port |
|
|
| |||
success |
|
|
| |||
error_code |
|
|
| |||
operation_number |
|
|
| |||
username |
|
|
| |||
mdm_type |
|
|
| |||
request_type |
|
|
| |||
mdm_device_id |
|
|
| |||
mdm_device_manager_id |
|
|
| |||
command__request_type |
|
|
| |||
command__payload |
|
|
| |||
command_uuid |
|
|
| |||
error_chain |
|
|
| |||
status |
|
|
| |||
message |
|
|
| |||
system__hostname |
|
|
| |||
system__displayName |
|
|
| |||
system__id |
|
|
| |||
process_name |
|
|
| |||
system_timestamp |
|
|
| |||
windows_meta__user_tasks |
|
|
| |||
windows_meta__user_process |
|
|
| |||
windows_meta__elevated |
|
|
| |||
windows_meta__user_services |
|
|
| |||
windows_meta__logon_type |
|
|
| |||
sso_token_success |
|
|
| |||
auth_context__policies_applied |
|
|
| |||
mfa |
|
|
| |||
application__name |
|
|
| |||
application__id |
|
|
| |||
application__sso_url |
|
|
| |||
idp_initiated |
|
|
| |||
at_devo_pulling_id |
|
|
| |||
hostchain |
|
|
| ✓ | ||
tag |
|
|
| ✓ | ||
rawMessage |
|
|
| ✓ |
...