how to get the device Defaults table via AXL/SQL query

[gecheung]

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.

[gecheung · Accepted solution]

ha, i found the answer. (=

[thedd]

gecheung schrieb:

ha, i found the answer. (=

Good to know
Just provide the correct answer for all

[gecheung]

by executing an AXL ExecuteSQLQuery request from the table named "defaults"

[coryalbert]

And what was the answer?

[bezcomservices]

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