SQL quairy - Clarity PPM

[Anon Anon]

Hello

 

I am trying to find the table(s) in SQL Management Studio that have all the resources' and users' details. I wander what table(s) is this stored at?

 

Thanks

[Deactivated User]

Look at the Tech ref Entity relation diagrams

cmn_sec_users

srm_resources

pac_mnt_resources

and others

[Suman Pramanik]

Hi Davitg,

 

You can take a look at the technical reference guide but at start you can use SRM_RESOURCES & CMN_SEC_USERS.

 

Regards

Suman Pramanik

[Anon Anon]

Thanks.

I am using MS SQL server 2005 - can I view Tech ref Entity relation diagrams from there?

 

Regards

Davit

[Anon Anon]

Sorry I meant MS SQL Server Management Studio.

[navzjoshi00]

https://support.ca.com/cadocs/7/CA%20Clarity%20PPM%2013%203%2000%20%20On%20Premise%20-%20Restricted%20Content%20-ENU/Bookshelf_Files/HTML/techref/index.htm

 

 

 

 

NJ

[Anon Anon]

thanks

[Deactivated User]

Tech ref is CA Clarity PPM documentation.

[uk3373]

Hi NJ,

 

I am not able to access this link -,it is loading loading but nothing happening .where can i get v 13/14 technical guide

Many thanks in Advance.

SAP Portal Services

[navzjoshi00]

As Martti mentioned, it's part of CA docs.

You can access the same for the CA support site

NJ

[Deactivated User]

Log in to support online

And go to documentation.

 

Or go to booksehlf directly

https://support.ca.com/cadocs/0/CA%20Clarity%20PPM%2013%200%2000-ENU/Bookshelf.html

Then login in to get access to the Restricted contend  where the Tech Ref is

 

[uk3373]

Hi Martink,NJ,

I have registered only for  community so it is not allowing me to access support page.

Thinking I need to register for support also..

Many thanks for your prompt help..

Regards,

Udaya kumar k

[navzjoshi00]

Can you follow the attached doc and see where you get to ?

 

NJ

Attachment(s)

Access support online.docx   337 KB 1 version

[Deactivated User]

If you have access to the install media verify whether or not it is on the media.

[uk3373]

Hi Urmas,NJ ,

 

Can you please guide me , I can able to navigate to the page but not able to download the restricted content .

 

Many thanks in advance.

Regards,

Udaya

[Nathan Arp]

In order to download Restricted Content, you have to login to CA Support as noted above by Martii:

 

Log in to support online

And go to documentation.

 

Or go to booksehlf directly

https://support.ca.com/cadocs/0/CA%20Clarity%20PPM%2013%200%2000-ENU/Bookshelf.html

Then login in to get access to the Restricted contend  where the Tech Ref is

[uk3373]

Hi ,

 

From here I clicked on restricted bookshelf then it askes me to login .

I logged in with my credentical then  it is running running ...nothing is happening.

Please find the screen shots for the same .

 

Many thanks in Advance .

[Deactivated User]

Are you on support ie do you have maintenance?

You need that. Then you need the site id and your ID authorized to login to online support with that site id.

Find out who is the CA contact in your organization and then if you have a site ID and if your id is authorized for login.

If not talk to your CA account manger to get thing going.

[uk3373]

Hi Urmas,

 

Many thanks for the suggestion and help.

I will try to find out CA Contact .

 

Regards,

Udaya