Hi,
Not sure about the BP objects but if you have read acess to the MS SQL DB (or better a mirror of the MS SQL DB), you can use the query below.
To get it to work you just need the name of the BP databse and replace the 'xxxxxxx'
Then add a WHERE clause for the specific date range you are interested in
Lastly add the process name to the WHERE clause
---------CODE STARTS HERE
USE XXXXXXX; -- Replace with the name of your database
GO
with SessionLog as
(
SELECT
S.SessionID
,S.StartDateTime
,S.EndDateTime
,S.StopRequested
,S.LastUpdated
,S.LastStage
,P.Name as ProcessName
FROM [dbo].[BPASession] as S
inner join [dbo].[BPAProcess] as P
on P.[processid] = S.[processid]
and P.[ProcessType] = 'P'
)
select LG.*
from SessionLog as LG
;
---------CODE ENDS HERE
