Administering Data › Audit Log › Audit Log › Audit Example

Audit Example

A typical scenario of a user performing CA Harvest SCM project actions and then of an administrator auditing those actions follows.

Example: Perform User Actions

This example shows the user JohnD performing the following CA Harvest SCM actions, and the records of the actions in the audit log.

1. Log in as user JohnD to Broker1 with an invalid password.

   Action 1: The login fails.

2. Log in as user JohnD to Broker1 with a valid password.

   The login succeeds.

3. JohnD performs the following actions:

   Action 2: Creates project E1

   Action 3: Creates state S1 in project E1

   Action 4: Creates state process P1 in state S1

   Action 5: Creates linked process L1 in state process P1

4. Events are recorded in the audit log as follows:

Example: Query the Log View

This example shows how the administrator queries the log view using queries.

• Get all failed login events query

  SELECT *
  FROM HARAUDITLOGVIEW
  WHERE ActionName = ‘Login user’ AND SuccessFailure = ‘F’
  
  Results: Action 1.
  

• Get all actions performed by user JohnD query

  SELECT *
  FROM HARAUDITLOGVIEW
  WHERE UserName = ‘JohnD’
  
  Results: Actions 1,2,3,4,5.
  

• Get all actions performed only against the project E1 (nonrecursive) query:

  SELECT *
  FROM HARAUDITLOGVIEW
  WHERE ResourceTypeName = ‘Project’ AND ResourceName = ‘E1’
  
  Results: Action 2.
  

• Get all actions performed against the project E1 and any of its components (recursive) query:

  SELECT *
  FROM HARAUDITLOGVIEW
  WHERE 
         (ResourceTypeName = ‘Project’ AND ResourceName = ‘E1’)
         OR 
         (ER2ResourceTypeName = ‘Project’ AND ER2ResourceName = ‘E1’)
  
  Results: Actions 2,3,4,5.
  

  Note: Projects are a Level 2 resource.

• Get all actions performed against the stateS1 and any of its components (recursive) query:

  SELECT *
  FROM HARAUDITLOGVIEW
  WHERE 
         (ResourceTypeObjId = 7 AND ResourceObjId = 567)
         OR 
         (ER3ResourceTypeObjId = 7 AND ER3ResourceObjId = 567)
  
  Results: Actions 3,4,5.
  

  Note: States are a Level 3 resource.