Sometimes you need to find out more data about your version control. For example how many people commit their work right before a deadline? Or how many commits did a particular user make? Or when did a commit with a particular description get checked in?
This is where the awesome tool P4Sql comes in handy.
First you need to download the P4Report: Reporting System from this location.
Then you need to install this package.
Once installed, you should open the P4Sql tool, normally found under C:\Program Files\Perforce\P4Report
Here you can query the schema of the database.
The schema can be found here.
Thus we can run queries such as
SELECT * FROM FILES WHERE REVISION = 23;
to see what files were changed in the revision, or
select * from changes where description like '%maya%' ;
to see what changes had descriptions that included the word maya.
To see the schema of Perforce, you can refer here.
No comments:
Post a Comment