Skip to main content
Saravanan10-Marble
10-Marble
January 17, 2011
Question

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

  • January 17, 2011
  • 5 replies
  • 1655 views
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.

5 replies

RandyJones20-Turquoise
20-Turquoise
January 18, 2011
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.
>
imendiola13-Aquamarine
13-Aquamarine
January 18, 2011

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



imendiola13-Aquamarine
13-Aquamarine
January 18, 2011

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



nweydert1-Visitor
1-Visitor
January 18, 2011
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 -






VincentQuesnoit1-Visitor
1-Visitor
January 24, 2011


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 -






Terms & ConditionsAccessibility statement