Data of version control dates and modified by, for scripts in database

Question ID: 109025
0
0

I needs to create a report of the dates and who modified a script with Version Control enabled on all projects. I don’t think there is an actual report, in ALM version 12.55, that could be run to provide this information; however, i can pull the data from the ALM projects database schema, if I could locate it.

If I log into ALM Desktop Client-> Test Plan, where VuGen scripts, or UFT scripts are stored for a test, on the scripts "History" tab, I can see the Date modified, and the account that made the modification.

I find in the projects database, the version history in the HIST_ASSET_REPOSITORY_ITEMS table (which match the user interface); but, this table does not have the Date or Modified By. I cannot find this information in any other table within the projects database tables.

Has anyone let know where exactly this information is stored in the projects database?

Marked as spam
Posted by (Questions: 144, Answers: 1)
Asked on May 6, 2019 12:54 pm
5 views
Answers (1)
0
Private answer

ALM 12.55 does not have a built in report that can be run for this information.

You will need to access each projects database individually, from the SQL Server Management Studio, and run a SQL quarry to extract the information. In each project's database schema, navigate to the HIST_TEST table, the following columns will have the data you need:

TS_VC_USER_NAME

TS_VC_CHECKIN_USER_NAME

TS_VC_COMMENTS

TS_VC_CHECKIN_DATE

TS_VC_CHECKIN_TIME

TS_VC_CHECKIN_COMMENTS

TS_VC_START_AUDIT_ACTION_ID

Marked as spam
Posted by (Questions: 0, Answers: 152)
Answered on May 6, 2019 12:56 pm