Can I use pdm_extract on ca_owned_resource and ci_network_rounter table to extract asset name, serial_number, network_address for all network_router?
Release : 17.3
Pdm_extract can extract data from one table only so this can't be done via pdm_extract.
You can run this query on mdb
SELECT c1.resource_name, c1.serial_number, c2.network_address
FROM ca_owned_resource c1, ci_network_router c2 where c1.own_resource_uuid=c2.own_resource_uuid
and export the results to an external file.