SQL Query to pull Templates from Config DB

Scottyjohn · June 4, 2012, 5:25pm

Hi all,
I have managed this before and cant find the query

I want a query that will pull the template options from config DB. Any help much appreciated!

Rene · June 5, 2012, 4:53pm

Hi,

Here is the code:

SELECT templ.name,aopt.section,aopt.opt,aopt.val
FROM cfg_app_prototype templ
LEFT JOIN cfg_app_option aopt ON aopt.object_dbid = templ.dbid AND object_type = 20
ORDER BY templ.name,aopt.section,aopt.opt

R.

Scottyjohn · July 16, 2012, 3:49pm

Thanks Rene your a star ;D