Location of Client in PS database

[lszyrmer]

Hi there!

I'm wondering where I can typically pull the name of the IRL client from the
project server database in SQL server. There seem to be many references to
it, but where is the actual definition of "unique_client_key" and
"unique_client" in a typical setup? I'm doing a small VBA project.

 

[Kevin W Flanagan]

What do you mean by "unique client key" as I do not see that field referenced
in the database schema I have. What version of the tool are you using?

Kevin

 

[lszyrmer]

Kevin,

Good point...I should have posted this too. I am using Project Server
2003, Project 2003, and SQL Server 2000. Any suggestions? I am seeing
Client in the drop-down in Project, and it is drawing on data in the
server(s), but I don't know where to look in the back end to find this
data. I am working on a few VBA queries, and knowing where I can pull
this info from would be rather useful. Using relational database
terminology i'm looking for the primary key and the client name, to be
able to pull data from all tables for each client. I hope this gives
enough background on what I am trying to do...I am a PS newbie, and I
was wondering if there is a standard place to look for this kind of
stuff...

Luke

 

[Kevin W Flanagan]

I am gueeisn here but I am thinking you or someone else has defined a custom
outline code for "Client" and it assigned on a per project basis?? If so,
what custom field or outline code is it specifically?i.e., Project
OUtlineCode3 or Project Text2

 

[lszyrmer]

Kevin,

It's possible that it is a custom outline code created by the people
who were installing and configuring project server for my company. Any
suggestions on how to look for it?

Luke

 

[Kevin W Flanagan]

In Project Pro, hover your mouse pointer over the column heading and it will
show you what the field name is. "Help on -----"