Data Reservation using Search and Reserve

book

Article ID: 193621

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Our QA testers are actively using Find and Reserve capabilities. Is there a way to pull a report of all reservations made by QA testers?

When I log in as an administrator and verify "My Reservations" it only shows the reservations made by admin log-in id. It does not show the reservations made by individual testers who log in using their own tester id's and reserve the data.

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

You can pull this data from telemetry – see

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/devops/test-data-management/4-9/administrating/ca-tdm-portal-administration/configure-telemetry.html.

You can import json data into excel https://theexcelclub.com/how-to-parse-custom-json-data-using-excel/ and create reports.



To pull a report directly from the database, assuming you are running on demand F&R, you can run

- to get the internal table name (assuming AIRPORTS is the driving table in my case)
select dvi.data_table_name from data_view dv
inner join data_view_instance dvi on dv.id = dvi.data_view_id
where dv.source_table = 'AIRPORTS')

- to get all the reserved records
select * from where "$RESERVATION_ID" IS NOT NULL

Attachments