Audit

Build 1501 on 14/Nov/2017  This topic last edited on: 22/Mar/2016, at 17:02

Description

Extract audit trail information.

NOTE: Use caution when executing this command with no parameters. It will retrieve the entire audit trail in the system, which can take a significantly long time.

Parameters (* denotes an optional parameter)

Ids*

A comma-separated list of database ids of the object(s) to fetch in the audit trail.

UserIds*

A comma-separated list of user ids to retrieve.

Actions*

An optional comma-separated list of actions. If not present, all actions are shown.

Actions include: Login, Logout, Create, Update, Spike, Unspike

Logins*

A comma separated list of GUIDs. The GUIDs correspond to the login session, that is, the ticket assigned when the user logged in.

From*

Optional specification of starting date/time. Uses a properly constructed date-time condition, e.g., cmd=audit&from=2009-12-04T12:04:00Z for GMT time, or cmd=audit&from=2009-12-04T01:04:00 to search by local system time.

NOTE: the audit trail is returned in chronological order, that is, the most recent activity is at the bottom of the returned xml.

To*

Optional specification of ending date/time. Uses a properly constructed date-time condition, e.g., cmd=audit&to=2009-12-04T12:04:00Z for GMT time, or cmd=audit&to=2009-12-04T01:04:00 to search by local system time.

NOTE: the audit trail is returned in chronological order, that is, the most recent activity is at the bottom of the returned xml.

X*

An optional string parameter specifying the name of an XSL transformation to be applied to the XML. The XSL transformation must be loaded in the database.

Examples

To retrieve the list of login entries for a user with id=5, use this command:

http://demo.teradp.com/Tark4/do.ashx?Cmd=audit&userids=5&actions=login

To retrieve the audit trail for a user with id=19348 since 2009-12-04, use this command:

http://demo.teradp.com/Tark4/do.ashx?Cmd=audit&userids=19348&from=2009-12-04

To retrieve the entire audit trail for an object with id=28129, use this command:

http://demo.teradp.com/Tark4/do.ashx?Cmd=audit&ids=28129

<ActionList

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns="http://www.teradp.com/schemas/GN4/1/Audit.xsd">

 <ActionDesc

  xsi:type="ObjectActionDesc" Time="2010-01-01T23:23:17.707Z"

  UserId="28289" LoginGuid="9ec20249-9328-45ec-96d4-635e9f0e0ffd"

  Action="Create" UserDesc="Ciro Cesar" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743" />

 <ActionDesc

  xsi:type="CheckOutActionDesc" Time="2010-01-11T22:05:35.853Z"

  UserId="19362" LoginGuid="91665bdb-51fe-45bc-9db9-2168a2c2043e"

  Action="CheckOut" UserDesc="Michele Mottini" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743"
   Codes="Normal" />

 <ActionDesc

  xsi:type="CheckOutActionDesc" Time="2010-01-11T22:05:49.903Z"

  UserId="19362" LoginGuid="91665bdb-51fe-45bc-9db9-2168a2c2043e"

  Action="UncheckOut" UserDesc="Michele Mottini" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743"
   Codes="Normal" />

 <ActionDesc

  xsi:type="SpikeActionDesc" Time="2010-01-19T19:39:28Z"

  UserId="4" LoginGuid="7a04f5a8-e43d-4271-aa8f-727230f1e0b5"

  Action="Spike" UserDesc="Administrator" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743"
   Code="Normal" />

 <ActionDesc

  xsi:type="ObjectActionDesc" Time="2010-01-19T19:40:19.563Z"

  UserId="4" LoginGuid="7a04f5a8-e43d-4271-aa8f-727230f1e0b5"

  Action="Unspike" UserDesc="Tark4 Administrator" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743" />

 <ActionDesc

  xsi:type="UpdateActionDesc" Time="2010-01-19T19:45:11.573Z"

  UserId="4" LoginGuid="7a04f5a8-e43d-4271-aa8f-727230f1e0b5"

  Action="Update" UserDesc="Tark4 Administrator" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743"

  Codes="Normal" NewVersion="false" />

 <ActionDesc

  xsi:type="UpdateActionDesc" Time="2010-01-19T19:49:05.76Z"

  UserId="4" LoginGuid="7a04f5a8-e43d-4271-aa8f-727230f1e0b5"

  Action="Update" UserDesc="Tark4 Administrator" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743"
   Codes="Normal" PreviousStateId="82785" NewVersion="false" />

 <ActionDesc

  xsi:type="UpdateActionDesc" Time="2010-01-19T19:58:51.043Z"

  UserId="14" LoginGuid="7a04f5a8-e43d-4271-aa8f-727230f1e0b5"

  Action="Update" UserDesc="Editor" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743"

  Codes="Content" NewVersion="false" />

 <ActionDesc

  xsi:type="UpdateActionDesc" Time="2010-01-19T19:59:03.07Z"

  UserId="14" LoginGuid="7a04f5a8-e43d-4271-aa8f-727230f1e0b5"

  Action="Update" UserDesc="Editor" ObjectId="82649"

  ObjectTypeName="image" ObjectDesc="image_10010118231743"

  Codes="Normal Content" NewVersion="false" />

</ActionList>

 

Description of information found in the audit trail results:

xsi:type

The type of action from one of these:

CheckOutActionDesc

CounterActionDesc

LoadActionDesc

PublishActionDesc

SpikeActionDesc

UpdateActionDesc

Time

Date-time stamp when the action occurred

UserId

Id of the user that performed the action

LoginGuid

Login 'ticket' valid for that action

Action

Type of action from one of these:

Create

Update

CheckOut

UncheckOut

Spike

UnSpike

UserDesc

Descriptive name of the user

ObjectId

Id of the object on which the action was done

ObjectTypeName

Name of the object type, e.g., image, video, etc.

ObjectDesc

Name (attribute) of the object

Codes

'Normal' if action involved metadata, 'Content' if action modified the object content, such as when an image is cropped.

PreviousStateId

Id of the folder the object was moved from. Only present when object was moved.

NewVersion

True if a new version of the object was created.

See also

AuditModifiedDate, AuditNav