[teiid-issues] [JBoss JIRA] (TEIID-5684) Show Latest Deployed Date of VDB in metadata tables

[Steven Hawkins (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13716892#comment-13716892 ] 

Steven Hawkins commented on TEIID-5684:
---------------------------------------

What do you consider the deployment date?

We should have a last modified time of the resource, and we have a last started time (or when the deployment scan picked up the resource).  However on every restart the vdb is effectively redeployed.

>From https://issues.jboss.org/browse/HAL-391 you can get the WildFly enabled-timestamp from the cli.  For example:

/deployment=bqt.vdb:read-attribute(name=enabled-timestamp)

would return something like:
{code}
{
    "outcome" => "success",
    "result" => "2019-04-02 16:11:43,222 EDT"
}
{code}

Alternatively is this something that you could set via a vdb property such that it could be obtained in the Properties or a new VDBProperties table?

> Show Latest Deployed Date of VDB in metadata tables
> ---------------------------------------------------
>
>                 Key: TEIID-5684
>                 URL: https://issues.jboss.org/browse/TEIID-5684
>             Project: Teiid
>          Issue Type: Enhancement
>            Reporter: Chandra Akkinepalli
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 12.2
>
>
> There is no easy way to tell when a VDB is last deployed on the server without scanning through server.log. This is very useful metadata to have handy.
> Is it possible to show when a VDB is last deployed on the server via metadata tables.
> May be show this info along with VDB name and version in SYS.VirtualDatabase table?



--
This message was sent by Atlassian Jira
(v7.12.1#712002)