search cancel

How to find information about changes to a project's lifecycle

book

Article ID: 42537

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

 Introduction:

If an SCM Administrator inadvertently changes one of the properties of his UDP process, such as the “Program” field, this change can be difficult to undo.

Question: 

Do you know from database can I find the previous value of the "Program" field of my UDP's properties?

Environment:  

CA Harvest SCM with Oracle database

Answer: 

SCM 12.1 introduced a new feature called the Harvest Audit Log.  You can read more about this feature in the SCM Administrator Guide. This feature collects information on changes to your Harvest database.There is no interface that lets you directly look at the audit log.  Instead there are "views" in the database that you can query using SQL to find the information you need.

The following query will let you know everything that has changed about a UDP named "My Example UDP" related to its "PROGRAMNAME" field from the time it was created to the present:

SELECT HARAUDITLOGVIEW.AUDITEVENTOBJID,
HARAUDITLOGVIEW.ACTIONNAME,
HARAUDITLOGVIEW.SUCCESSFAILURE,
HARAUDITLOGVIEW.EVENTTIME,
HARAUDITLOGVIEW.USERNAME,
HARAUDITLOGVIEW.RESOURCETYPENAME,
HARAUDITLOGVIEW.RESOURCENAME,
HARAUDITLOGVIEW.EVENTDESCRIPTION
FROM HARAUDITLOGVIEW
WHERE HARAUDITLOGVIEW.RESOURCENAME = 'My Example UDP'
AND HARAUDITLOGVIEW.EVENTDESCRIPTION LIKE '%PROGRAMNAME%'
ORDER BY HARAUDITLOGVIEW.EVENTTIME

Change “My Example UDP” to the name of the UDP you want to look at.

This should provide details on everything that has happened to the UDP in question that involves the Program Name field.  The columns returned by the query include:

ACTIONNAME : what type of change was performed

SUCCESSFAILURE : whether the change was successful

EVENTTIME : the date and time of the change

USERNAME : the Harvest userid of the user who made the cyange

RESOURCETYPENAME : what type of object was changed (a project? a state? a process? etc)

RESOURCENAME : the name of the object that was changed

EVENTDESCRIPTION : description of the change

Additional Information:

As always, please contact CA Technologies support for CA Harvest SCM if you have further questions.

 

Environment

Release: SCMNCR99000-12.5-Harvest-Software Change Manager-Named User-Competitive Replacem
Component: