At our site, there is a user in the database called TDWM that contains the configuration. It is not very straight-forward though.
SELECT * FROM tdwm.RuleQualifyCriteria rc
INNER JOIN tdwm.RuleDefs rd
ON rc.ConfigId = rd.ConfigId
AND rc.RuleId = rd.RuleId
INNER JOIN tdwm.WlcClassifyOrder wlc
ON wlc.ConfigId = rd.ConfigId
AND wlc.WlcId = rd.RuleId
WHERE rd.ConfigId = ?
ORDER BY ClassifyOrder
That query will probably get you most of what you want. It will not display exceptions and such since it inner joins with the wlc order. You will need to modify it if you want different data. Replace the ? with your config ID. You can get your current config ID with the following query:
SELECT * FROM TABLE(tdwm.TDWMINQUIRE()) tab;
We also has TDWM user enabled,the table tdwm.WlcClassifyOrder is showing as not existant in TD 14.10.
*** Failure 3807 Object 'tdwm.WlcClassifyOrder' does not exist.
Statement# 1, Info =0
Could you please suggest any alternate solution?
Sorry, I am not aware of any other solution. We are using TD 13.10. They may have changed the data model... no idea.
The main reason to join to the classify order table was to make it easier to determine which rules get evaluated first. Presumably, that value is somewhere else now.
If RuleDefs and RuleQualifyCriteria exist, you can get the PROFILE->WDID mapping without the classification order.