ActivConnect Data Dictionary

'logs' and 'logsV2'

The ActivConnect tables (views) logs and logsV2 represent your organization's detailed activity logs.

  • logs is the ActivConnect view available since early 2020 and compatible with current BI templates
  • logsV2 is an update utilizing the new Passive Time Classifications, allowing you to see what activity (app or website) a user is using even when their activity level moves to a "passive" state

Field Name

Column

Description (logs)

Description (logsV2)

Active State

active_state

(NOT AVAILABLE)

User's activity level:

  • Active - using keyboard/mouse
  • Passive - not using keyboard/mouse
  • Passive Locked - computer is locked/asleep

Activity Time (UTC)

time

System activity DateTime in UTC time zone

Category

category

Activity category specified in the ActivTrak application.

Computer

computer

Computer name. Comes from the operating system.

Duration (sec)

duration

Activity duration in seconds.

Email

email

Flag to denote if the log entry is associated with an alarm that triggered an email (0 = no email notification was sent, 1 = email notification was sent)

Executable

executable

Name of the app running, usually in its raw format. E.g. Slack.exe

IP Address

ip

Private IP address

Log Description

log_description

Friendly name of the app or site running, based on "executable".

NULL if user is Passive.

Friendly name of the app or site running, based on "executable".

 

Log Url

log_url

URL for website-related activity; otherwise NULL.

Logon Domain

logondomain

Active Directory domain attached computers will show the domain name here. If not attached to a domain, the computername will be shown. Macs almost always show computername and Google Chrome agents will not show anything. Comes from operating system.

Popup

popup

Flag to denote if the log entry is associated with an alarm that triggered a popup in the user's screen (0 = popup notification didn't fire, 1 = popup notification fired)

Primary Domain

primarydomain

Often the same as the local system name, though not always. if the computer is attached to an Active Directory domain, that domain name will show up here. If not, it's typical for Windows machines to use "WORKGROUPS", Chrome agents to use "Google". Macs typically don't show anything related to the primary domain. Comes from the operating system.

Productivity

productivity

Productivity classification (configurable per application/website). Available values are Undefined, Productive, Unproductive.

Not available for Passive activities.

Productivity classification (configurable per application/website). Available values are Undefined, Productive, Unproductive.

Available for all activities.

 

Public IP Address

publicip

The public IP address is the IP address that can be accessed over the Internet

Screenshot

screenshot

Flag to denote if the log entry is associated with an alarm that triggered a screenshot capture (0 = screenshot was not captured, 1 = screenshot was captured)

Terminate

terminate

Flag to denote if the log entry is associated with an alarm that triggered an application termination (0 = no application termination occurred, 1 = originating application was terminated)

Title Bar

titlebar

Name of the title bar of the active window.

NULL if user is Passive.

Name of the title bar of the active window.

 

User

user

Friendly user name. E.g. First Last. Comes from the operating system.

User (Raw)

userraw

Simple login name. Often first initial, last name. Comes from the operating system.

User Alias

useralias

Comes from ActivTrak, and not the operating system. User Aliases are used to combine multiple user logins in our graphs and reports as well as provide a "friendly name" in case the "userraw" and "user" fields are ambiguous.

Version

version

NEW - Version number of the table schema, so you can easily track if there are new field changes

Webhook

webhook

Flag to denote if the log entry is associated with an alarm that triggered a webhook sent (0 = no webhook sent, 1 = webhook was sent)

 

Was this article helpful?

0 out of 0 found this helpful

Comments

No comments