SQL to select windows objects that use "Custom interpreter"

[Pete Wirfs]

I would like to identify all of our windows objects that use "Custom interpreter" for the "interpreter type" on the Windows settings panel, so we can consider depreciating the use of this feature and replace it with the script function :BEGIN_EXT_INTERPRETER.

Does anyone know where this setting is stored in the database?  I've investigated the JBA table, but I haven't been able to find it.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Peter Grundler]

Hi Pete,

it's part of JBA_Rest:

Values can be 0, 1 and 2 (batch/command/custom interpreter)

regards,
Peter

[Juergen Lechner]

Hi Pete,

this is one of the hidden "pearls" of the DB. <sarcasm>I love concatenated fields!</sarcasm> But as I said: hidden. :-)

Try this SQL: select * from uc_svalm order by svalm_attdbfname, svalm_hostattrtype, svalm_restid

This table explains a lot of the cryptic stuff.

Regards,
Juergen

------------------------------
Juergen Lechner
Managing Consultant
setis GmbH
Germany
------------------------------

[Pete Wirfs]

Thank you everyone!  This information got me what I needed.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------