Get DataAuditTrail

Use this command to retrieve data audit trail information to a file or an object list. You can retrieve specific data audit trail information by using a DataSpec document to filter the results retrieved.

Note: Using the Data Audit Trail functionality requires that the Data Audit Trail parameter be set to TRUE in Longview Server Manager (the default value is FALSE). For more information, see the Longview Server Manager Guide. If you do not have access to this functionality, contact your System Administrator.

Get DATAAUDITTRAIL TO FileName|ObjectListName [USING dataSpecName]                         

where:

• FileName is the name for the created ASCII file, containing the data audit trail information in comma delimited format. It can include a complete or partial folder path in the format C:\...\FileName. If FileName includes spaces, enclose it in double quotation marks; for example:

  @"C:\My Documents\Info.csv"

• ObjectListName is the name of the object list variable, containing the data audit trail information.
• dataSpecName is the name of the DataSpec document to filter the result. This parameter is optional. If you do not specify a DataSpecName, all data audit trail data will be retrieved.

Note: There are specific DataSpec functions that can be used to filter the DataAuditTrail results: BatchID, DataChangedThreshold, DateFilter, Dimension, Schedule, and UserFilter. See Using DataSpec functions

Get DATAAUDITTRAIL TO AuditData.csv USING MyDataSpec.lvdsp                        

ACCOUNTS SalesT#99
TIMEPERCP#99
SCHEDULE ICStandard
CONTRAS Boston
  
USERFILTER user888
DATEFILTER 2018-09-05, TO, 2018-09-30
DATACHANGEDTHRESHOLD BETWEEN, 10.1, 335.5                                
BATCHID 5, to, 9

Sample output file to csv