Appreciations accepted

Vladlen Litvinov, the author: If you have some job offer for me, I'm ready to discuss it. View Vladlen Litvinov's profile on LinkedIn

Password

Friday, February 7, 2014

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).

No comments:

Post a Comment