For each workflow execution I would like to capture workflow information in a DB but how to read/get deployed Workflow meta data like “Last uploaded date” or “version”
You can see some helpful information via REST API. You can send a GET request to http://your-knime-server/knime/rest/v4/repository/path/to/your/workflow.
The easiest way to explore the API is by having a look at the swagger ui. In KNIME explorer just right click a workflow on your server and click “Show API definition”.