...
From the above-mentioned paths, we need to pick one of them. makeProcessIdsUnique operator will pick the first path based on the specified ordering on the other hand pathFromRoot operator does not respect the ordering but, it picks the first one. Refer to the Example section below.
Operator Usage in Easy Mode
- Click + on the parent node.
- Enter the Make Process IDs Unique operator in the search field and select the operator from the Results to open the operator form.
- In the Input Table drop-down, enter or select the table containing the data to run this operator on.
- In the Partition by Column drop-down, enter or select a column name to partition by.
- In the Order by Column drop-down, enter or select the column name to order within each partition.
- In the Parent Process ID drop-down, enter or select the source column.
- In the Child Process ID drop-down, enter or select the destination column.
- Click Run to view the result.
- Click Save to add the operator to the playbook.
- Click Cancel to discard the operator form.
Usage Details
LQL Command
Code Block |
---|
makeProcessIdsUnique(makeProcessIdsUniqueParentTable, $.partitionByColumn, $.orderByColumn, $.parentProcessId, $.childProcessId) |
Parameters
Input Table: select the input table
Partition by Column: Partition by column name
Order by Column: Names of columns (comma separated string) to order table
Source: Name of the source column
Destination: Name of the destination column
Example
Let's assume that the input table contains the following connections from parent ID to a child ID.
...