Solutions

DIm cm : how to generate a report with following columns : User Name, Role, Capability, Full Name, Site, Department, Telephone



ID:    S143572
Published:    07 October 2021

Product(s)

  • Dimensions CM
 

Description

how to generate a report with following columns : User Name, Role, Capability, Full Name, Site, Department, Telephone ?

Resolution

The sql query below can be used below to generate this report, just need to replace cm_typical database by your own database name : 

select pur.user_name, pur.role, pur.leader, pup.full_user_name, pup.site, pup.dept, pup.phone

from cm_typical.pcms_user_roles pur, cm_typical.pcms_users_profile pup

where  pur.user_name = pup.user_name

order by pur.user_name, pur.role ;


Rate this Solution

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs