topic Re: SQL query to extract associated remote destination profiles in Management

SQL query to extract associated remote destination profiles

stephan.steiner — Thu, 09 Aug 2018 12:42:03 GMT

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

Re: SQL query to extract associated remote destination profiles

stephan.steiner — Thu, 09 Aug 2018 12:49:55 GMT

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 🙂