CA Service Management

 Hello Team

I need to extract ca_group_memeber table from pdm_extract command. But it saying table not recognized. see below.

I need to extract this table n load on my replica server. Please help me to extract this table.

I also checked below link to confirm the table name but I couldn't find .Please dvise

https://docops.ca.com/ca-service-management/14-1/en/reference/ca-service-desk-manager-reference-commands/technical-reference/table-and-object-cross-references

The correct name for the table, according to the link you provided, is Group_Member.

Hi Cristi

thanks for you reply

But pls see below screenshot. There isn't the table group_member. how can I extract this table (ca_group_member)from pdm command? 

Can you tell me whats the data difference in these both tables?  grpmem and ca_member_group? 

As it's explained in the documentation, the table name - as needed by pdm_load/pdm_extract - , it's not always the same as the one in the SQL, that's why there is a mapping between them in the document. The pdm_ utilities don't connect directly to the SQL tables, but go through an intermediary layer (Data Element Dictionary), just as the names at the Objects and Attributes layer are different (i.e. grpmem).

I got u Cristi

But please clear me where I can see the data in sdm interface for ca_group_member?

I know about the grpmem. 

I have a replica server in which I need to update ca_group_member table .there is a difference of records in this table.

grpmem table records are same in my both server.

According to the documentation link - and the SD files I checked - this SQL table is not used in SDM, so there is no interface to show it there.

Hi Aamir,

This table is not used by SDM.  It may be used by other CA products.  SDM only uses the grpmem table to store the relationships of contacts to groups.

Because that ca_group_member table is not defined at the SDM object layer (which is what pdm_extract runs queries against as Cristi mentioned), you cannot do a pdm extract against that object.  You would need to use some type of SQL tool to copy the data over.

Thanks

Jon I.

Hi Jon

Thanks for the clarification

Aamir - no problem.  Are you good to go on this one?

Let us know,

Jon

Hi JOn

yes as u said it is not concerned with sdm contact n groups.

Correct - so in this case, we will mark Cristi's answer as the correct one.

Thanks Aamir!

Jon

Dear  Jon_Israel

Please clarify one thing. As you said CA_group_member table is not used by SDM and may be use by other CA product. So in my case why I have 1000's of records in this table.? Rightnow our sdm is integrated with spectrum n uim. So the data in this table came from these 2 products???

Most likely not, since neither of them use the MDB directly.

Cristi is correct - Most likely it came from another CASM application like CA Service Catalog, or CA IT Asset Manager.

thanks mitu & jon

Welcome.

You good to go on this one?

yes jon

On 19-Oct-2017 12:49 am, "Jon_Israel" <

Great!  Have a great day Aamir!