Workday collector

[ 1 Overview ] [ 2 Devo collector features ] [ 3 Data sources ] [ 4 Minimum configuration required for basic pulling ] [ 5 Accepted authentication methods ] [ 6 Run the collector ] [ 7 Collector services detail ] [ 8 Collector operations ] [ 9 Change log ]

Overview

Workday is a service that automates the sourcing, aggregation, normalization, and data management of security data across your organization into a security data lake stored in your account. A security data lake helps make your organization’s security data broadly accessible to your preferred security analytics solutions to power use cases such as threat detection, investigation, and incident response.

Workday has adopted the Open Cybersecurity Schema Framework (OCSF), an open standard. With OCSF support, the service can normalize and combine security data from AWS and a broad range of enterprise security data sources.

Devo collector features

Feature	Details

Feature	Details
Allow parallel downloading (`multipod`)	`not allowed`
Running environments	`collector server` `on-premise`
Populated Devo events	`table`
Flattening preprocessing	`no`
Allowed source events obfuscation	`yes`

Data sources

Data source	Description	API endpoint	Collector service name	Devo table	Available from release

Data source	Description	API endpoint	Collector service name	Devo table	Available from release
Workday	Provides the ability to view log entries in the User Activity report data source	`/activityLogging`	`activity_logging`	`app.workday.user_activity.activity`	`v1.0.0`

For more information on how the events are parsed, visit our page.

Minimum configuration required for basic pulling

Although this collector supports advanced configuration, the fields required to retrieve data with basic configuration are defined below.

This minimum configuration refers exclusively to those specific parameters of this integration. There are more required parameters related to the generic behavior of the collector. Check setting sections for details.

Setting	Details

Setting	Details
`client_id`	Client ID
`client_secret`	Client Secret
`refresh_token`	The refresh token
`base_url`	The base URL Please note that the tenant is used as part of the API URL. For instance, in the URL `https://wd5-services1.myworkday.com/ccx/api/v1/acme`, the base API URL is `https://wd5-services1.myworkday.com` and the tenant is “acme.”
`tenant`	The Workday tenant Please note that the tenant is used as part of the API URL. For instance, in the URL `https://wd5-services1.myworkday.com/ccx/api/v1/acme`, the base API URL is `https://wd5-services1.myworkday.com` and the tenant is “acme.”

See the Accepted authentication methods section to verify what settings are required based on the desired authentication method.

Accepted authentication methods

Authentication method	Client ID	Client Secret
`client_id` / `client_secret`	Required	Required

Run the collector

Once the data source is configured, you can either send us the required information if you want us to host and manage the collector for you (Cloud collector), or deploy and host the collector in your own machine using a Docker image (On-premise collector).

Collector services detail

This section is intended to explain how to proceed with specific actions for services.

Events service

Internal process and deduplication method

All Workday events are fetched via the activityLogging endpoint: {base_url}/ccx/api/privacy/v1/{tenant}/activityLogging

The collector continually pulls new events since the last recorded timestamp. A unique hash value is computed for each event and used for deduplication purposes to ensure events are not fetched multiple times in subsequent pulls.

Devo categorization and destination

All events of this service are ingested into the table app.workday.user_activity.activity.

Setup output

A successful run has the following output messages for the setup module:

2023-06-19T00:22:09.263    INFO InputProcess::MainThread -> WorkdayPullerSetup(unknown,workday#10001,activity_logging#predefined) -> Starting thread
2023-06-19T00:22:09.264    INFO InputProcess::MainThread -> WorkdayPuller(workday,10001,activity_logging,predefined) - Starting thread
2023-06-19T00:22:09.264 WARNING InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Waiting until setup will be executed
2023-06-19T00:22:09.651 WARNING InputProcess::WorkdayPullerSetup(unknown,workday#10001,activity_logging#predefined) -> Testing fetch from https://wd5-services1.myworkday.com/ccx/api/privacy/v1/acme/activityLogging.
2023-06-19T00:22:10.067    INFO InputProcess::WorkdayPullerSetup(unknown,workday#10001,activity_logging#predefined) -> Successfully tested fetch from https://wd5-services1.myworkday.com/ccx/api/privacy/v1/acme/activityLogging. Source is pullable.
2023-06-19T00:22:10.068    INFO InputProcess::WorkdayPullerSetup(unknown,workday#10001,activity_logging#predefined) -> Setup for module <WorkdayPuller> has been successfully executed

Puller output

2023-06-19T00:28:13.500    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> WorkdayPuller(workday,10001,activity_logging,predefined) Starting the execution of pre_pull()
2023-06-19T00:28:13.501    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Reading persisted data
2023-06-19T00:28:13.502    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Data retrieved from the persistence: {'@persistence_version': 1, 'start_time_in_utc': '2023-06-19T04:23:01Z', 'last_event_time_in_utc': '2023-06-19T04:26:52Z', 'last_ids': ['60ff86dc074ba6762adc31bb7e1cf9de1bb739fef8e6f3138f1220ce39f98261', '5137ae41a8ed84eda7d1b3daf077022e6f138829315961743be50f210971ff56', '9f5c18ae1506a54755a559b2806f61bf234fd4489fcde694804f4b7d51c70ee0'], 'next_offset': 0}
2023-06-19T00:28:13.503    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Running the persistence upgrade steps
2023-06-19T00:28:13.503    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Running the persistence corrections steps
2023-06-19T00:28:13.503    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Running the persistence corrections steps
2023-06-19T00:28:13.504    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> No changes were detected in the persistence
2023-06-19T00:28:13.504    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> WorkdayPuller(workday,10001,activity_logging,predefined) Finalizing the execution of pre_pull()
2023-06-19T00:28:13.504    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Starting data collection every 60 seconds
2023-06-19T00:28:13.505    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Pull Started
2023-06-19T00:28:15.338    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Fetching all activity logs subject to the following parameters: {'from': '2023-06-19T04:26:52Z', 'to': '2023-06-19T04:28:13Z', 'limit': 1000, 'offset': 0}
2023-06-19T00:28:15.506    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> 104 record(s) returned for last batch which is less than limit of 1000. No new records remaining. Finishing pull.
2023-06-19T00:28:15.507    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> (Partial) Statistics for this pull cycle (@devo_pulling_id=1687148893500):Number of requests made: 1; Number of events received: 104; Number of duplicated events filtered out: 3; Number of events generated and sent: 101; Average of events per second: 50.447.
2023-06-19T00:28:15.507    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Statistics for this pull cycle (@devo_pulling_id=1687148893500):Number of requests made: 1; Number of events received: 104; Number of duplicated events filtered out: 3; Number of events generated and sent: 101; Average of events per second: 50.442.
2023-06-19T00:28:15.507    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> The data is up to date!
2023-06-19T00:28:15.508    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Data collection completed. Elapsed time: 2.007 seconds. Waiting for 57.993 second(s) until the next one

After a successful collector’s execution (that is, no error logs found), you will see the following log message:

2023-06-19T00:28:15.507    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Statistics for this pull cycle (@devo_pulling_id=1687148893500):Number of requests made: 1; Number of events received: 104; Number of duplicated events filtered out: 3; Number of events generated and sent: 101; Average of events per second: 50.442.
2023-06-19T00:28:15.507    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> The data is up to date!
2023-06-19T00:28:15.508    INFO InputProcess::WorkdayPuller(workday,10001,activity_logging,predefined) -> Data collection completed. Elapsed time: 2.007 seconds. Waiting for 57.993 second(s) until the next one

This collector uses persistent storage to download events in an orderly fashion and avoid duplicates. In case you want to re-ingest historical data or recreate the persistence, you can restart the persistence of this collector by following these steps:

Edit the configuration file.
Change the value of the reset_persistence_auth parameter to a different one.
Save the changes.
Restart the collector.

The collector will detect this change and will restart the persistence using the parameters of the configuration file or the default configuration in case it has not been provided.

Note that this action clears the persistence and cannot be recovered in any way. Resetting persistence could result in duplicate or lost events.

This collector has different security layers that detect both an invalid configuration and abnormal operation. This table will help you detect and resolve the most common errors.

Error Type	Error Id	Error Message	Cause	Solution
InitVariablesError	1	Invalid `start_time_in_utc: {ini_start_str}`. Must be in parseable datetime format.	The configured `start_time_in_utc` parameter is a non-parseable format.	Update the `start_time_in_utc` value to have the recommended format as indicated in the guide.
InitVariablesError	2	Invalid `start_time_in_utc: {ini_start_str}`. Must be in the past..	The configured `start_time_in_utc` parameter is a future date.	Update the `start_time_in_utc` value to a past datetime.
SetupError	101	Failed to fetch OAuth token from `{token_endpoint}`. Exception: `{e}`.	The provided credentials, base URL, and/or token endpoint is incorrect.	Revisit the configuration steps and ensure that the correct values were specified in the config file.
SetupError	102	Failed to fetch data from `{endpoint}`. Source is not pullable.	The provided credentials, base URL, and/or token endpoint is incorrect.	Revisit the configuration steps and ensure that the correct values were specified in the config file.
ApiError	401	Error during API call (API provider HTML error response here)	The server returned an HTTP 401 response.	Ensure that the provided credentials are correct and provide read access to the targeted data.
ApiError	429	Error during API call to (API provider HTML error response here)	The server returned an HTTP 429 response.	The collector will attempt to retry requests (default up to 3 times) and respect back-off headers if they exist. If the collector repeatedly encounters this error, adjust the rate limit and/or contact the API provider to ensure that you have enough quota to complete the data pull.
ApiError	500	Error during API call to (API provider HTML error response here)	The server returned an HTTP 500 response.	If the API returns a 500 but successfully completes subsequent runs then you may ignore this error. If the API repeatedly returns a 500 error, ensure the server is reachable and operational.

Collector operations

This section is intended to explain how to proceed with specific operations of this collector.

Initialization

The initialization module is in charge of setup and running the input (pulling logic) and output (delivering logic) services and validating the given configuration.

A successful run has the following output messages for the initializer module:

Events delivery and Devo ingestion

The event delivery module is in charge of receiving the events from the internal queues where all events are injected by the pullers and delivering them using the selected compatible delivery method.

A successful run has the following output messages for the initializer module:

Sender services

The Integrations Factory Collector SDK has 3 different senders services depending on the event type to delivery (internal, standard, and lookup). This collector uses the following Sender Services:

Logging trace	Description

Logging trace

Description

Number of available senders: 1

Displays the number of concurrent senders available for the given Sender Service.

sender manager internal queue size: 0

Displays the items available in the internal sender queue.

This value helps detect bottlenecks and needs to increase the performance of data delivery to Devo. This last can be made by increasing the concurrent senders.

Total number of messages sent: 44, messages sent since "2022-06-28 10:39:22.511671+00:00": 21 (elapsed 0.007 seconds)

Displays the number of events from the last time the collector executed the pull logic. Following the given example, the following conclusions can be obtained:

44 events were sent to Devo since the collector started.
The last checkpoint timestamp was 2022-06-28 10:39:22.511671+00:00.
21 events were sent to Devo between the last UTC checkpoint and now.
Those 21 events required 0.007 seconds to be delivered.

By default these traces will be shown every 10 minutes.

Sender statistics

Each service displays its own performance statistics that allow checking how many events have been delivered to Devo by type:

Logging trace	Description

Logging trace

Description

Number of available senders: 1

Displays the number of concurrent senders available for the given Sender Service.

sender manager internal queue size: 0

Displays the items available in the internal sender queue.

Standard - Total number of messages sent: 57, messages sent since "2023-01-10 16:09:16.116750+00:00": 0 (elapsed 0.000 seconds

Displays the number of events from the last time and following the given example, the following conclusions can be obtained:

44 events were sent to Devo since the collector started.
The last checkpoint timestamp was 2023-01-10 16:09:16.116750+00:00.
21 events where sent to Devo between the last UTC checkpoint and now.
Those 21 events required 0.007 seconds to be delivered.

To check the memory usage of this collector, look for the following log records in the collector which are displayed every 5 minutes by default, always after running the memory-free process.

The used memory is displayed by running processes and the sum of both values will give the total used memory for the collector.
The global pressure of the available memory is displayed in the global value.
All metrics (Global, RSS, VMS) include the value before freeing and after previous -> after freeing memory

Change log

Release	Released on	Release type	Recommendations

Release	Released on	Release type	Recommendations
`v1.3.0`	Oct 29, 2024	improvement bug fixing	`Recommended version`
`v1.3.0`
`v1.2.0`	Oct 16, 2024	improvement bug fixing	`-`
`v1.2.0`
`v1.1.0`	Jun 18, 2024	NEW FEATURE bug fixing	`-`
`v1.1.0`
`v1.0.0`	Aug 17, 2023	initial release	`-`