ActivTrak Data Connect Quick Start Guide

 

ActivTrak will set up your instance of ActivTrak Data Connect in a hosted Google Cloud Account.  This process usually takes less than 24 hours. We will then send your credentials to access your account for your use. 

Note: You can query up to 1TB of data per month (the equivalent of 3.2GB records) which is more than enough for most customers. 

Accessing ActivTrak Data Connect

Once your Google Cloud account is setup, there are three ways you can access Data Connect:

  1. Use one of ActivTrak Data Connect’s Pre-Built Templates for PowerBI or Tableau to jumpstart your analysis.
  2. Use Google BigQuery Console to access your data via SQL queries.
  3. Use a BI / Data tool of your choice to access Data Connect and create your reports from scratch.

Below are the instructions for each of the three approaches listed.

Use one of ActivTrak Data Connect’s Templates to jumpstart your analysis

Our analysis templates contain a robust set of reports in the areas of Activity & Application Usage, Productivity, Collaboration & Knowledge Management, and Compliance & Risk Management.  

  1. Download ActivTrak Data Connect Tableau Setup Guide
  2. Download ActivTrak Data Connect Power BI Setup Guide

 

Use Google BigQuery Console to access your data via SQL queries

Follow the instructions below to access Data Connect via BigQuery Console:

  1. Once your Google Cloud account is set up, you can verify access to your data in ActivTrak Data Connect instance in BigQuery by clicking on the URL below:
    https://console.cloud.google.com/
  2. This will prompt you to log in using your Google Account credentials that end with "activtrak.us". 
  3. Once you are logged in, you will see your data instance on the left-hand side of the Google BigQuery Console (called ‘activtrak-us): 

Data_Connect_-_Quick_start_guide.png

4.  Query your activity data within the BigQuery console using SQL statements that access your account’s logs table within the activtrak-us. The prototypical SQL query statement should look like the select statement below. Note that youraccountnumber should be replaced with your six-digit ActivTrak account number. 

Use this sample query limited to 100 rows to test you can access your data.

Select * from `activtrak-us.youraccountnumber.logs`

limit 100;

Data_Connect_-_quick_start_guide_2.png

For reference as you start exploring your activity data, you can access a Data Dictionary describing the available fields and a Sample Data Output in the Appendix of this document.

 

Use a BI / Data Visualization tool of your choice to access Data Connect and create your reports from scratch

Follow the instructions for each tool below to access Data Connect using a BigQuery connection:

  1. Select the ‘activtrak-com’ project.
  2. Select the dataset with your six-digit account number. 
  3. Select the ‘logs’ table within your dataset.
  4. Query your activity data and start creating reports.
  5. For reference as you start exploring your activity data, you can access a Data Dictionary describing the available fields in the Appendix of this document.

Data Dictionary

The following table describes each of the columns available in ActivTrak Data Connect. Each record (row) represents an activity entry.

Field Name

Column

Description

Activity Time (UTC)

time

System activity DateTime in UTC time zone

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. Almost always the same as "executable" but in Proper Case.

Log Url

log_url

Url for website-related activity, otherwise it will be 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. Available values are Undefined, Productive, Unproductive. Passive time is defined in the Title bar field.

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.

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.

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)

Category

category

Activity category specified in the ActivTrak application.

 

Was this article helpful?

0 out of 0 found this helpful

Comments

No comments