Skip to content

How to update SOLIDWORKS PDM Viewer Settings for ALL users

Article by Joe Medeiros, CSWE created/updated May 20, 2016

Currently if you need to make changes to User Viewer settings, each user has to be updated individually.

SOLIDWORKS PDM Viewer Settings

Viewer settings

If there are multiple users to update, this can be a tedious time consuming task. To avoid this toil, the SOLIDWORKS PDM Viewer Settings can be updated for all users by using the following SQL query:

Update Settings
 set value = (
 select Value From Settings S
 Inner Join Users U on S.UserID = U.UserID
 Where VarID = 16 and Username = 'Admin')
 Where VarID = 16 and UserID != 2

First update the Viewer settings for the Admin and then run the query on your vault.

Run query

Run query

Learn more about SOLIDWORKS PDM

Attend our SOLIDWORKS PDM Administration training course either online, in a classroom near you, or ask us about training on-site at your location.

Posts related to 'How to update SOLIDWORKS PDM Viewer Settings for ALL users'

Find Related Content by TAG:

Joe Medeiros, CSWE

Joe Medeiros is a SOLIDWORKS and PDM Certified Expert. He has been helping SOLIDWORKS users with training, mentoring and implementations since 1998. He combines industry experience with a thorough understanding of SOLIDWORKS products to assist customers in being successful. He shares his experience and expertise through blogs; one of which has been incorporated into the SOLIDWORKS Essentials training manual.

Want to learn SOLIDWORKS?

Take a training course from our team of Certified SOLIDWORKS Experts

Scroll To Top