03-04-2016 11:59 AM
Hello,
i would like to get the Device Defaults table to see what is the default load for some device models via AXL/SQL query. What is the table name? Thanks.
g.
Solved! Go to Solution.
03-04-2016 12:42 PM
ha, i found the answer. (=
03-04-2016 12:42 PM
ha, i found the answer. (=
04-20-2016 06:20 AM
gecheung schrieb:
ha, i found the answer. (=
Good to know
Just provide the correct answer for all
04-20-2016 10:33 AM
by executing an AXL ExecuteSQLQuery request from the table named "defaults"
01-17-2019 06:09 PM
And what was the answer?
05-04-2016 09:28 PM
So for those who were looking for a proper answer, here is an SQL lookup that provides the info.
I do not claim to be an SQL Guru so I am sure there is better syntax, but this pulled what I needed:
select d.loadinformation, tm.name from defaults as d INNER JOIN typemodel as tm on d.tkmodel = tm.enum WHERE LENGTH (d.loadinformation) > 0
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: