get_datamart_info

This command returns details on the datamart, for example, the report and query on which the datamart is based, creation date, results are extracted to file or initial start, time granularity, and so on.

This API is available in Guardium V9.5 and later.

GuardAPI syntax

get_datamart_info parameter=value

Parameters

Parameter Value type Description
datamart_name String Required.
isExtended Boolean Valid values:
  • 0 (false)
  • 1 (true)

Default = 0 (false)

Examples

To output info on data mart Export:RD1:

grdapi get_datamart_info datamart_name="Export:RD1"
=========================================
Data Mart Name: Export:RD1
=========================================
Description:
Based on Query: RD1
Extract result to: File
Initial Start: 2020-06-24 06:06:00
Creation Date: 2020-06-24 07:13:09
Time Granularity: 20 MINUTE
Active: true
---------------------
Customized Date Format:
File Name: EXP_RD1
Lines per File: 0
File Header: "UTC Offset","% CPU Mysql","% CPU Sniffer","% Mem Mysql"
Include File Header: true
-----------------------------------------
Copy File Info
-----------------------------------------
Host Name: <hostname>
Failover Host Name: <failover hostname>
Port #   :
User Name: root
Directory: /var/tmp/
Password: ******
Transfer Method: SCP
Bundle Name:
Bundle Main Datamart: false
Send COMPLETE File: true
-----------------------------------------
Last Extraction Info
-----------------------------------------
State:1
---------------------
Timestamp: 2020-06-29 09:09:50
Next Period: 2020-06-29 09:06:00
Last Extracted ID: 0
---------------------
Extraction Log
---------------------
Timestamp: 2020-06-29 09:10:48
Extract Status: OK
Start Time: 2020-06-29 09:09:49
End Time: 2020-06-29 09:09:50
Period Start: 2020-06-29 08:46:00
Period End: 2020-06-29 09:06:00
Records Extracted: 20
Details: SCP to: <hostname to which it was exported>, User: root, Path: /var/tmp/, File: 2542225914053566522_<hostname data was exported from>_EXP_RD1_20200629124600.gz
Last for Period: true
File Name: /opt/IBM/Guardium/data/dump/DATAMART/EXP_RD1_20200629124600.csv
Bundle Name:
File Transfer Status: Done
ok