Can I use pdm_extract on ca_owned_resource and ci_network_router table to extract asset name, serial_number, network_address for all network_router?
Service Desk Manager 17.3 and higher
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.
Note: while you can run pdm_extract for ca_owned_resource table, you can't do the same for co_network_router table