How to retrieve information regarding users preferable site for uploading/downloading contents

[Saravanan]

Hello All,

We have a master server and three light weight replica servers. We requested users for setting their upload/download (default cache server setting) preference setting to their local server and not master. For enforcing this setting, we would like retrieve the individual users setting information from the DB. Could you please provide the table names or any SQLs for retrieving this information

Thanks in advance.

[RandyJones]

On 01/17/11 13:15, Ganapathy Saravanan (Consultant) wrote:
> Hello All,
> We have a master server and three light weight replica servers. We requested
> users for setting their upload/download (default cache server setting)
> preference setting to their local server and not master. For enforcing this
> setting, we would like retrieve the individual users setting information from
> the DB. Could you please provide the table names or any SQLs for retrieving
> this information

There is probably some sql query you can run however you can also do this the
"Windchill way" as follows:
1. login to Windchill as wcadmin
2. Site | Utilities | Preference Manager
3. select the "Find.." button
4. change "Search For:" to User
5. enter user name
6. Select Search
7. Select Ok

Now you are looking at that users preferences.
Drawback is that if you have many users this is a tedious process...

> Thanks in advance.
>

[imendiola]

Hi,

the info about that preference is stored in the "DBPREFENTRY" table of the database. You need to search those records that have "contentCacheSite" value in the NAME column. The VALUE column has the name of the preferred site. Anyway, there are only records for those users that have changed the default value of the preference. You can use the CONTEXT column to link to the user.

Regards

Iker Mendiola

Prambanan IT Services
http://www.prambanan-it.com

[imendiola]

Btw, I think that dbprefentry table is used until Windchill 9. I have checked it, and it looks that at least 9.1 is using PREFERENCEDEFINITION (name='/wt/content/contentCacheSite') and PREFERENCEINSTANCE (ida3a4 = ida2a2 from preferencedefinition) tables to store this info.

Regards

In Reply to Iker Mendiola:

Hi,

the info about that preference is stored in the "DBPREFENTRY" table of the database. You need to search those records that have "contentCacheSite" value in the NAME column. The VALUE column has the name of the preferred site. Anyway, there are only records for those users that have changed the default value of the preference. You can use the CONTEXT column to link to the user.

Regards

Iker Mendiola

Prambanan IT Services
http://www.prambanan-it.com

Iker Mendiola

Prambanan IT Services
http://www.prambanan-it.com

[nweydert]

I don't know why you want to use a sql query, when there is a windchill service
available to get any value from the preferences .....

PreferenceHelper.service.getValue("your preference name", theContainer,
theWTUser) >> String theValue

My pleasure,

- Nicolas Weydert -

[VincentQuesnoit]

I wish one could set default preferences in user profiles, then you would only need to assign a profile to a user to set some preferences ...

Vincent

In Reply to Nicolas WEYDERT:

I don't know why you want to use a sql query, when there is a windchill service
available to get any value from the preferences .....

PreferenceHelper.service.getValue("your preference name", theContainer,
theWTUser) >> String theValue

My pleasure,

- Nicolas Weydert -