Can't find resource UserName Field

[SagarSarkar]

I am trying to find the UserName field which we setup in Admin -> Resources, not able to find it in the SRM_Resources Table, I thought that might be the right place to check, have looked in multiple other tables without any luck. Could some one help me out with this please? Thanks in advance.

[Alistair Miller]

It should be SRM_Resources.Unique_Name

[Sridhar Bandaru]

User Name : CMN_SEC_USERS.USER_NAME

Resource ID : SRM_RESOURCES.UNIQUE_NAME

[David Morton]

and CMN_SEC_USERS.ID = SRM_RESOURCES.USER_ID is the join

 

(need to take some care with that, since if you have always set up users at the same time as resources (and/or never created a non-labour resource) then from your data it might look like the join is CMN_SEC_USERS.ID = SRM_RESOURCES.ID, but it isn't!)

[SagarSarkar]

Thanks for this David, that would have been my next step, you made it easy for me.

[David Morton]

If you are looking around in the data model, you might like to look at the ERDs in the technical reference guides

(link for the 15.1 version here ; https://docops.ca.com/ca-ppm/15-1/en/administration/reference/technical-reference/entity-relationship-diagrams-erd - need to be logged in with a account that has access I think though)

 

The CMN_SEC_USERS --- SRM_RESOURCES relationship can be seen in the 'Resources' diagram - and thats only one of the very simple ones  )

[SagarSarkar]

Hi David,

 

Sorry to bother you again, but I can't find the actual Database ERD any more, this was working till a couple of weeks back but the link above comes back 404 Not Found. I tried to look for it but can't find it anywhere in the Technical Reference or any place related to the Release Information.

 

Thanks.

[David Morton]

Weird, the URL seems to have changed - I get the 404 error too.

 

You should have been able to find it yourself though I suspect - clicking on the CA PPM - 15.1 on that error page and then looking in the menu structure, but here is the link ; https://docops.ca.com/ca-ppm/15-1/en/administration/reference/entity-relationship-diagrams-erd 

[SagarSarkar]

Thanks Sridhar.