cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
204
Views
0
Helpful
1
Replies
Highlighted
Rising star

SQL query to extract associated remote destination profiles

Does anybody have an SQL query handy to get the associated remote destinations for a user? I'm doing mass stuff and listUser does not return these tags so I have to inject them later on and SQL is usually the most effective way to extract the data. I found where devices / UDPs are mapped (enuserdevicemap), but RDPs seem to be different even though they are also devices (and this in the device table).

Everyone's tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Rising star

Re: SQL query to extract associated remote destination profiles

Debug level traces are a beautiful thing.. just had a look at what is being done SQL wise when I do a getUser

 

select name from device where fkEnduser_mobility = '2fc645dc-5176-5632-216c-a28072a8d207' and tkproduct= '112' and tkclass='20'

 

And that's that. Problem solved :)

1 REPLY 1
Rising star

Re: SQL query to extract associated remote destination profiles

Debug level traces are a beautiful thing.. just had a look at what is being done SQL wise when I do a getUser

 

select name from device where fkEnduser_mobility = '2fc645dc-5176-5632-216c-a28072a8d207' and tkproduct= '112' and tkclass='20'

 

And that's that. Problem solved :)

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards