Platform Operations, Administration, and Management (OA&M) Release Notes
========================================================================
+Version 1.2.0, 15 August 2018
+-----------------------------
+
+- Updated ELK queries to match with database 1.17 version
+
Version 1.1.0, 27 June 2018
---------------------------
jdbc_password => "${ACUMOS_ELK_JDBC_PASSWORD}"
jdbc_validate_connection => true
schedule => "* * * * *"
- statement => "SELECT * FROM C_SOLUTION WHERE ACCESS_TYPE_CD='OR'"
+ statement => "SELECT * FROM C_SOLUTION s, C_SOLUTION_REV r WHERE s.SOLUTION_ID = r.SOLUTION_ID AND r.ACCESS_TYPE_CD='OR' and s.ACTIVE_YN ='Y'"
type => "company_model"
- tags => ["database"]
+ tags => ["database"]
}
jdbc {
jdbc_driver_library => "${ACUMOS_ELK_JDBC_DRIVER_LIBRARY}"
jdbc_password => "${ACUMOS_ELK_JDBC_PASSWORD}"
jdbc_validate_connection => true
schedule => "* * * * *"
- statement => "SELECT * FROM C_SOLUTION WHERE ACCESS_TYPE_CD='PB'"
+ statement => "SELECT * FROM C_SOLUTION s, C_SOLUTION_REV r WHERE s.SOLUTION_ID = r.SOLUTION_ID AND r.ACCESS_TYPE_CD='PB' and s.ACTIVE_YN ='Y'"
type => "public_model"
tags => ["database"]
}
jdbc_password => "${ACUMOS_ELK_JDBC_PASSWORD}"
jdbc_validate_connection => true
schedule => "* * * * *"
- statement => "select solution.name,CONCAT(user.first_name,' ',user.last_name) from c_solution solution inner join c_user user on user.USER_ID = solution.OWNER_ID"
+ statement => "SELECT * FROM C_SOLUTION s, C_SOLUTION_REV r WHERE s.SOLUTION_ID = r.SOLUTION_ID AND r.ACCESS_TYPE_CD='PR' and s.ACTIVE_YN ='Y'"
+ type => "private_model"
+ tags => ["database"]
+ }
+jdbc {
+ jdbc_driver_library => "${ACUMOS_ELK_JDBC_DRIVER_LIBRARY}"
+ jdbc_driver_class => "${ACUMOS_ELK_JDBC_DRIVER_CLASS}"
+ jdbc_connection_string => "${ACUMOS_ELK_JDBC_CONNECTION_STRING}"
+ jdbc_user => "${ACUMOS_ELK_JDBC_USERNAME}"
+ jdbc_password => "${ACUMOS_ELK_JDBC_PASSWORD}"
+ jdbc_validate_connection => true
+ schedule => "* * * * *"
+ statement => "select s.SOLUTION_ID, s.NAME Model_Name, u.First_Name, u.Last_Name, r.ACCESS_TYPE_CD, s.Created_Date, s.Modified_date, s.ACTIVE_YN from C_SOLUTION s, C_USER u, C_SOLUTION_REV r where s.USER_ID = u.USER_ID and s.SOLUTION_ID = r.SOLUTION_ID order by u.Last_Name"
+ type => "solutions"
+ tags => ["database"]
+ }
+jdbc {
+ jdbc_driver_library => "${ACUMOS_ELK_JDBC_DRIVER_LIBRARY}"
+ jdbc_driver_class => "${ACUMOS_ELK_JDBC_DRIVER_CLASS}"
+ jdbc_connection_string => "${ACUMOS_ELK_JDBC_CONNECTION_STRING}"
+ jdbc_user => "${ACUMOS_ELK_JDBC_USERNAME}"
+ jdbc_password => "${ACUMOS_ELK_JDBC_PASSWORD}"
+ jdbc_validate_connection => true
+ schedule => "* * * * *"
+ statement => "select solution.name,CONCAT(user.first_name,' ',user.last_name) from c_solution solution inner join c_user user on user.USER_ID = solution.USER_ID"
type => "name_model"
tags => ["database"]
}