Phython scrupting
Budget: $30 – $50 AUD
Requirement is Read from the .log file.
It is comma separated, 3rd element has deployment Id, get the deployment Id.
Connect to Db2 database
Run the query passing the deployment id.
Select create_timestamp,last_modfied_timestamp from deployment where deployment_id = (from the log file) with ur
Repeat the same above query for another table object store table
Print the current timestamp followed by the deployment id, created timestamp from the deployment table and last modified timestamp from the deployment table, created timestamp from the object store table, and last modified timestamp from the object store table to another log file
It is comma separated, 3rd element has deployment Id, get the deployment Id.
Connect to Db2 database
Run the query passing the deployment id.
Select create_timestamp,last_modfied_timestamp from deployment where deployment_id = (from the log file) with ur
Repeat the same above query for another table object store table
Print the current timestamp followed by the deployment id, created timestamp from the deployment table and last modified timestamp from the deployment table, created timestamp from the object store table, and last modified timestamp from the object store table to another log file