How can I retrieve the list of all users and their profiles alongwith their workloads? I can get the list of users and profile simply from DBC.users and list of rulenames from the TDWM.RuleDefs. but could not figure out to join which column with whom to get list of workloads which are associated with certain users & profiles. I am working in TD 14.10 and we r using viewpoint 15.0
Wdname is found on pdcrdata.dbqlogtbl_hst so you can associate it with users there for users that have submitted queries.
Also they may be able to run in multiple workloads but have only qualified for some so you would check TASM ruleset to see what workloads the user qualifies for based on classification criteria i.e: userid/account/profile/querband. This would apply for users who have not submitted any queries also.
Thanks RGlass. I have made the solution and following is the query to extract result set. Just posting it in case someone also needs it in future.