Prerequisites
Minimum Version: Requires SysTrack 10.1 or later.
Notes
After this DEX Pack is installed, it may take up to 24 hours for data to appear.
If you update or reinstall this DEX Pack, you must reassign any Views created below to the SF_Log4J Role and reapprove the log4j Action.
Installation Steps
To install this DEX Pack, complete the following steps:
Import the Kit
There are two ways to import the DEX Pack to SysTrack:
Import the pack directly from the Kits page in SysTrack. See the Import Online Kits guide for more information.
Import a local file downloaded from the DEX and Kit Downloads page. Click the Download Kit link for the pack and follow the Import Local Kits guide to finish the import.
Enable the log4j Action
Verify you have unlocked the tenant next to your username.
In Configure, click Automations and Collection Extensions on the left.
Select Action Governance, then click the Pending Approval tab.
Find the log4j Action and select the checkbox next to it.
Click Approve, then confirm. The action moves to the Actions tab and is enabled automatically.
NOTE: In SysTrack Cloud, the user who imported the Kit may not be allowed to approve its actions. If the checkbox is unavailable, ask another user with Action Governance – Management permission to approve the action.
Create the Log4J View
This DEX Pack requires you to make a View for the relevant SF_Log4j Role.
To create the new View:
Navigate to Configure > Views.
Click the padlock icon in the upper-right to enable editing.
Click the plus icon to add a new View.
Fill in the Settings as follows or follow them as per the screenshot from the kit.
View Name: SF_Log4j
Existing Category: General
Expires in: 30 Days
When Expired: Overwrite Data
Do NOT check When overdue by 1 day (s).
Set the Refresh drop-down to Daily, Inside, 24x7, and Every Day.
Copy the SF_Log4j SQL Query, and paste it into the box under SQL Selection > Generic.
Click Test SQL. A Success message should appear at the top of the screen. If the test is not successful, the query may have been copied incorrectly.
Click Create View at the top-right.
SF_Log4j SQL Query
SELECT
T0.WGUID,
GETUTCDATE() AS VWTIME,
Add_Date AS RunTime,
S0.STRVALUE AS FULLPATH
FROM DYNI_log4j AS T0
INNER JOIN SASTR_DYN AS S0 ON T0.FullName = S0.STRINGIDAssign the Log4J View to the Log4J Role
To assign the new View:
Navigate to Configure > Roles.
Use the drop-down at the top to select the SF_Log4J Role.
Click Views, then check the box next to SF_Log4j.
Click Save Changes at the top-right.
Assign the Log4J Role to Relevant Configurations
This solution requires you to assign the SF_Log4J Role to the relevant Configurations:
Navigate to Configure > Configurations.
Click the padlock icon in the upper-right to enable editing.
Use the drop-down at the top to select a relevant Configuration, or create a new Configuration.
Assign the SF_Log4J Role to the Configuration by dragging it from Available Roles to Assigned Roles.
Click Save Changes at the top-right.
Repeat this process for any other relevant Configurations.