How to import CA EEM audit.log to SQL.
Article ID: 415499
Updated On:
Products
Issue/Introduction
Need to import CA EEM audit.log to SQL.
Environment
ITPAM 4.4
EEM 12.6.7
Resolution
The SE provided the mssql-jdbc.jar with the following steps that solved the issue:
Step 1: Extract the manifest
jar xf yourfile.jar META-INF/MANIFEST.MF
Step 2: Edit META-INF/MANIFEST.MF with any text editor
Original Manifest
----------------------
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.10.12
Created-By: 11.0.19+7 (Eclipse Adoptium)
Build-Env: Windows 7/amd64/6.1
Main-Class: com.ca.eiam.audit.AuditTool
Class-Path: log4j-api.jar log4j-core.jar jaxb-api-2.3.1.jar jaxb-runti
me-2.3.1.jar
Name: C:\ci\workspace\eem-safe-12-6-CR07-GA-Windows\safe\server\tools\
audittool\dist\safeauditimport.jar
Specification-Title: CA Embedded Entitlements Manager Audit Event Impo
rt Tool
Specification-Version: 12.6.7.0
Specification-Vendor: CA
Implementation-Title: Audit Event Import Tool
Implementation-Version: 12/28/2023 11:43
Implementation-Vendor: CA
Updated with mssql-jdbc.jar(example)
---------------------------
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.10.12
Created-By: 11.0.19+7 (Eclipse Adoptium)
Build-Env: Windows 7/amd64/6.1
Main-Class: com.ca.eiam.audit.AuditTool
Class-Path: log4j-api.jar log4j-core.jar jaxb-api-2.3.1.jar jaxb-runti
me-2.3.1.jar mssql-jdbc.jar
Name: C:\ci\workspace\eem-safe-12-6-CR07-GA-Windows\safe\server\tools\
audittool\dist\safeauditimport.jar
Specification-Title: CA Embedded Entitlements Manager Audit Event Impo
rt Tool
Specification-Version: 12.6.7.0
Specification-Vendor: CA
Implementation-Title: Audit Event Import Tool
Implementation-Version: 12/28/2023 11:43
Implementation-Vendor: CA
Step 3: Update the JAR with the modified manifest for the jar.
jar ufm yourfile.jar META-INF/MANIFEST.MF
Step 4: Create the database with the name audit_data and run the eem_audittool_mssql_db_schema.sql to create the required tables.
Step 5: Update the config.xml with the required details and run the below command.
C:\Program Files\CA\SC\EmbeddedEntitlementsManager\bin>"C:\Program Files\CA\SC\EmbeddedEntitlementsManager\jre11\bin\java" -jar safeauditimport.jar config.xml
config.xml is attached to the case. Update the hostname and password before running the tool.
Kindly open a support case requesting the .jar and config.xml.
Feedback
