Can I use a join with pdm_extract to fetch network router assets?

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

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?

Environment

Service Desk Manager 17.3 and higher

Resolution

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