Specifying Serena Release Automation Queries

You may specify SQL queries for the information you want returned from Serena Release Automation.

To specify the Serena Release Automation connection information:

Navigate to the Serena Release Manager common Tomcat Web server classes folder. For example:

C:\Program Files\Serena\common\tomcat\6.0\webapps\rlm\WEB-INF\classes
Open the nolio-client-queries.properties file.

Set the properties for the queries as follows:

Parameter	Value
query.get.applications	SQL queries to return the set of applications, environments, processes, and servers you want for the automation deployment tasks. For the default queries, see the example.
query.get.environments
query.get.processes
query.get.servers
query.find.application
query.get.job.status
message.application.not.found	Message to send if applications aren’t found.
message.environment.not.found	Message to send if environments aren’t found.

Example

This example shows the default SQL queries for Serena Release Automation.

nolio-client-queries.properties

query.get.applications = select app_name from applications where id!=1

query.get.environments = select name from environments where id!=1 and applicationId = ?

query.get.processes = select process_name from process_container pc, process_in_env pe where pc.id = pe.process_id and pe.environment_id = ? order by process_name

query.get.servers = select s.server_name, st.server_type_name from servers s, server_types st, server_type_instance sti where s.id = sti.mapped_server and st.id = sti.server_type and sti.environment_id = ?

query.find.application = select id from applications where app_name = ?

query.find.environment = select id from environments where name = ? and applicationId = ?

query.get.job.status = select step_title,step_state from step_events where id in (select MAX(id) from step_events where job_id=?)

message.application.not.found = Could not find specified application: {0}

message.environment.not.found = Could not find specified environment: {0}