The report of using Process Designer

One man from DeveloperWorks forum asked the interesting question.
He needs create some report about using of PD. He want to know when some user used PD last time. He needs it for license control.



As we know, every time some developer presses the button Save in PD, one new unnamed snapshot of PA is created and the string about this snapshot is added in the table LSW_SNAPSHOTS. We say nothing about a named snapshot's creation. It is clear, the same situation.
Then we can use this table for our decision. We will use a query for solving this issue. Certainly, there are some limitations in using this way, but I don't see any another way in the standard mechanisms of BPM.

Create the query (for Oracle in my case):

SELECT LSU.FULL_NAME AS FULLNAME, LSU.USER_NAME AS USERNAME, MAX(LSN.LAST_MODIFIED) AS LASTDATE

FROM BPMDB.LSW_USR_XREF LSU 

INNER JOIN BPMDB.LSW_SNAPSHOT LSN ON LSN.LAST_MODIFIED_BY_USER_ID = LSU.USER_ID

GROUP BY LSU.USER_NAME, LSU.FULL_NAME

ORDER BY LSU.FULL_NAME

We get the result:

As a result, it is possible to create some good report with filters and so on using some report designer or create a new PA in BPM what will be use this query and will output the report. Also, this PA can use for controlling the users on creating the possibility to add or delete users in/from developers group (tw_authors, by default).