Need a report which shows list of users id's and email id's information from SAP CPS

[former_member152974]

Hi Team,

can you able to provide a custom script or if there is any facility available to get a report of user id's and email id's of the users.

Appreciate your help in providing the script.

Regards,

Kiran

[former_member152974]

Thank you for the SQL statement.

Regards,

Kiran

[gmblom]

select s.Name, s.Email from Subject s where s.Type = 'U'

Regards Gerben