How to export Teradata access log and DBQL from Teradata table to a file

Database

How to export Teradata access log and DBQL from Teradata table to a file

Hi,

I am trying to audit Teradata database.I have enabled DBQL and access log auditing.

Now i want to export audit logs to logfile in human readable format.

I have tried BTEQ but it exports to file when i use export Report option but all columns are not exported.

When i use Fast export It exports to a file but it is not in proper Human readable format.

Let me know If any Body  tried Audit log export and able to successfully export audit logs to a file in proper format with header.

Thanks In advance.

Deepak jha

Tags (1)
1 REPLY

Re: How to export Teradata access log and DBQL from Teradata table to a file

Hi

Will anybody help me on the above query.

Has anybody exported Teradata DBQL and accss audit log to a file or able to send to remote syslog server.

Thanks in Advance.