Hello All,
I need a custom SQL Query for the below requirement.
1. I need a end user report, which contains end user information such as their NAME, TELEPHONE NUMBER AND LIST OF DEVICES ASSOCIATED ( SEP, CSF, DEVICE PROFILE..ETC). basically this report should have all end users in the call manager.
2. Based on the first requirement, i would like to get only particular list of users for e.g say i only needed a 50 users information such as their, name, telephone number and list of device associated with their profile.
like table as below. i wanted to pass the employee Id as reference and pull their name, telephone number and device association.
employee Id Name, telephone number, Device association.
1234 Michael 56789 SEP XXX, CSFXXX
3456 David 34569 SEP, DP3456
I hope my requirement is clear.
