Is there a programatic way to get Audit Activity? An sql query would be nicest.
One answer
Since this question fails to provide information about the product, nobody will be able to answer.
In general for most Jazz based products, you don't access the repository with sql. If you do so, a lot of information is not available because Jazz uses EMF and stores a lot of information in blobs and such.
Some products such as RTC provide an API you can use, some a REST interface. Some information can also be found in the data warehouse.
In general for most Jazz based products, you don't access the repository with sql. If you do so, a lot of information is not available because Jazz uses EMF and stores a lot of information in blobs and such.
Some products such as RTC provide an API you can use, some a REST interface. Some information can also be found in the data warehouse.