SQL query to extract associated remote destination profiles

[stephan.steiner]

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).

[stephan.steiner · Accepted solution]

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 :)