Accessing audit revision numbers

[David OD]

Hi all

I am generating documention from models, and for particular elements, want to provide the following details:

Version No X.X  Revision No XX  Last Edited XX/XX/XX

I can easily get the first and last bits of this, but the Revision obviously comes from the auditing.  I can't find any API call that provides access to this.  I can't even see a table (t_something) in the database that contains the information so I can do a SQL query.

I know it is possible, as RaQuest shows the data.

Do any of you gurus know how to access this information?  

[Geert Bellekens]

David,

I don't know it by heart (we don't use auditing), but whenever I need to find out something like this I do following:
- Start with an empty model
- Do the absolute minimum to get the data that you need
- Open the model file with MS Access
- Open every table and inspect its contents untill I find what I need.

Geert

[David OD]

Geert

Thanks.  Not what I wanted to hear, but probably a very accurate approach!!!  I just found out where matrix profiles were located, so next stop, audit data!    If I find it I'll post the answer.