cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
255
Views
0
Helpful
0
Replies
Dominik_B
Beginner

SQL Query Callmanager Publishers for licence reporting

Hi Guys

 

I hope somebody can help me with this. I would like to make a SQL Query on the Callmanager Publishers for the fields "Device Name", "UserID 1" and "Owner User ID". I found already the fields "Owner User ID" and "Device Name" with:

SELECT device.name, enduser.userid FROM device LEFT JOIN enduser ON device.fkenduser = enduser.pkid

But now I struggle a lot to find the last field "UserID 1" in this table and DB jungle. 

To make a usable licence reporting per user on our CUCM I need this two user fields.

 

Mabye somebody can help me out to find this field.

 

Thank you in advance,

Regards Dominik

0 REPLIES 0
Create
Recognize Your Peers
Content for Community-Ad