To view or create a ticket, please login to ActivTrak

Log in

ActivTrak Data Connect Quick Start Guide

Prerequisite: Need a Google Cloud account to access your ActivTrak Data Connect instance.

The following options are available:

  • Reuse your company’s Google Cloud account
  • Create a free Google Cloud account

Setting up a Google Cloud Account

If you have an existing Google Cloud account, please provide the email associated with this account to ActivTrak so we can enable access. 

If you don’t have an existing Google Cloud account, create a Google Cloud account by: 

  1. Going to cloud.google.com
  2. Click ‘Sign in’ 
  3. Click ‘Create account’ on the bottom left 
  4. Follow the prompts to fill out the required information. Be sure to fill out the Billing Information. This is needed to verify identification and in case you exceed the data query quota. 

Your data storage is unlimited and covered by your ActivTrak license. Also, you can query up to 1TB of data per month for free (the equivalent of 3.2GB records) before incurring additional costs, which is more than enough for most customers. 

Once you provide your Google Cloud account, we will proceed setting up your instance of ActivTrak Data Connect, which usually takes less than 24 hours. If you need assistance, please contact Customer Support.

Accessing ActivTrak Data Connect

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

  • Use one of ActivTrak Data Connect’s Templates to jumpstart your analysis by leveraging our pre-built reports.
  • Use Google BigQuery Console to access your data via SQL queries
  • Use a BI / Data tool (e.g. Tableau) 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 Template, Setup Guide and Pre-built Analysis Inventory from the Help Center. 
  2. Coming soon: We are working on templates for Power BI, Google Data Studio and others. Check for updates in a few weeks.

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/bigquery?p=activtrak-com-214616
  2. This will prompt you to log in using your Google Account credentials. 
  3. Once you are logged in, you will see your data instance on the left-hand side of the Google BigQuery Console (called ‘activtrak-com-214616’):

  4. Query your activity data within the BigQuery console using SQL statements that access your account’s logs table within the activtrak-com-214616 project. 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-com-214616.youraccountnumber.logs`
limit 100;

  1. 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 tool (e.g. Tableau, Power BI, Google Data Studio, etc.) 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

Tyler Winn
Comments