How do i retrieve values for specific production settings from Ens_Config.Item using SQL Query in Management Portal
The select query here "select Settings from Ens_Config.Item" in the SQL Query of management portal returns this:
ValidationHost 7ActOnTransformErrorHost1 ReplyCodeActionsHostE=D AlertOnErrorHost1 9 AlertGroupsHost$LabAlertGroup,1-CriticalAlertGroup BusinessPartnerHost
How do I isolate just one of the settings e.g. ReplyCodeActions or LocalInterface
For example, i want to search for all entries that have a value for ReplyCodeActions
I realize i can open the production in studio and search for those setting values.
Via SQL:
Documentation on [.
You can also get it without SQL:
To get production setting use one of:
To get setting of production item use:
Where Type can be Host or Adaptor.
The ItemName argument may contain the following elements:
Notes on ItemName:
Documentation.
Excellent!
How do i isolate the individual setting?
e.g. I'd like to search for any ID that has a setting that's not null for ReplyCodeActions and then list what that value is
Seems like this is a collection or list of some kind, but can't figure out the correct syntax
1. Get list of all items in production (via Ens.Director:getProductionItems)
2. Iterate over items local array and for each item:
Structure can be anything you want:
That mainly depends on what do you want to do with this information later.
Is it possible to isolate an item setting and its value using only SQL?
Here's a stored procedure that accepts a setting name and returns the setting value for all components that have it. It's not SQL, but can be executed from SQL :)
You can call it this way -- this example returns the port setting for all components that have it:
Here's the source code as XML export format. Copy this into a file and then import it using Studio, terminal, or the System Management Portal.