How to find RTC repository version by running SQL commands on Jazz or JTS schema.?

I've used the "application-about" to good effect in a curl or wget.  

e.g. curl -k https://server.dom:nnnn/ctx/application-about

substitute as follows:
The fully-qualified host for server.dom
The actual port for nnnn
The application context for ctx

You will get back something like:

<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
         xmlns:jfs="http://jazz.net/xmlns/prod/jazz/jfs/1.0/"
         xmlns:dcterms="http://purl.org/dc/terms/"
         xmlns:oslc="http://open-services.net/ns/core#">
    <oslc:Publisher  rdf:about="https://server.com:9443/jazz/application-about">
        <dcterms:title>Change and Configuration Management</dcterms:title>
        <dcterms:description>Provides capabilities for change management, planning, software configuration management, automation (build system), and extensions for IBM enterprise platforms development.</dcterms:description>
        <dcterms:identifier>http://jazz.net/application/ccm</dcterms:identifier>
        <jfs:version>5.0.2</jfs:version>
        <oslc:icon rdf:resource="https://server.com:9443/jazz/web/com.ibm.team.rtc.web/ui/graphics/UICustomizations/RTC_16.png"/>
        <jfs:instanceName>RTC</jfs:instanceName>
    </oslc:Publisher >
</rdf:RDF>

The best thing is that NO authentication is required all you need to know is the URI of the server.

Hi Kevin,

Thanks for the answer but this method is useful only when application is up & running.

I need to check the version of the repository incase the DB is corrupted or the server is not starting because of repository version mismatch.

I could see something as below in the <JAZZ_SCHEMA>.JAZZ_PROPERTIES table after the application is upgraded to 5.0.2



Regards,

Nagesh S