Blue Prism SQL Tables

[Val]

I need to extract from SQL Database, when a scheduled process has ended (date and time).
Does anyone know the name of the SQL table from which I can extract this information?

 

[joshwgray]

You could try something like this:

SELECT
    [BPAProcess].[name],
    [BPAProcess].[description],
    [BPASession].[sessionid],
    [BPASession].[startdatetime],
    [BPASession].[enddatetime],
    [BPASession].[statusid],
    [BPAStatus].[description]
FROM [BPAProcess]
JOIN [BPASession] ON
    [BPASession].[processid] = [BPAProcess].[processid]
JOIN [BPAStatus] ON
    [BPASession].[statusid] = [BPAStatus].[statusid]
WHERE [BPAStatus].[description] IN ('Completed', 'Stopped', 'Terminated')
    AND [BPASession].[sessionid] = 'Your session id'

 

[Val]

Thanks, it works

 

[rkhimava]

I need to get the @joshwgray can you please help me in getting the table from which i can get the future schedule of a process which we have set in blue prism, for e.g. a specific process will run from 7:00 AM - 11:00 PM in next week so from which table can i get this information.