v5.1.1: find the creation date of repository

[kha]

Hi,

I would like to find the creation date of the repositories. Instead of running the history of each repository, is there a way I can find that using sql script? If so, can you please let me know which table and which column i should look at?

[lbauer]

It might be possible to write a SQL script. I'm not sure what kind of query you could write, but the information you need is in the sgvault dbo.tbltransactions and in dbo.tblrepositories.

In dbo.tbltransactions you can look for the earliest transaction per repid, which would be the creation date, then find the repository name for that repid in dbo.tblrepositories.

[kha]

Hi Linda,

I thought transaction table will show every single transaction (including check in, deletion, creation, etc.), not just only repository creation.

I just need the new repository that created last month, i don't need to know all activities that happened last month.

Transactions table doesn't show details what kind of action that happened, it only shows txbegin and txend.

I found out that I have to do it in multiple steps by
- querying the transactions tbl, repositories tbl, then get the txid smallest from the result
- querying the transactionattrvalues tbl where [attrvalue] = 'creating repository' AND [txid] >= the smallest number that i got from above query
- then go from there

[lbauer]

Transactions table doesn't show details what kind of action that happened, it only shows txbegin and txend.

That's true, though the very first transaction for a particular repid is the creation of the repository. At least that's what I found when I created a new repository and looked at the transations table.