How to update SOLIDWORKS PDM Viewer Settings for ALL users

Article by Joe Medeiros, CSWE 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.

Related Links

Want to do more with SOLIDWORKS PDM?

Our Certified SOLIDWORKS PDM Experts can help you to:

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.