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