SCTM - query for current executions

[WojtekH]

Hi, does anyone have any idea query for Current Executions. I searched each table and view in database, but I didn't find.

[Roland Kern]

Hi,

are you looking for Execution Plan runs or Test Runs?

And are you talking about manual tests or automated tests?

Automated test runs can not be queried from the database, they are running on their execution servers and don't get an entry in TM_ExecDefinitionRuns until finished.

For manual test runs, entries in TM_ExecDefinitionRuns are created immediately when an execution plan is started, and the Status is "7" meaning "Pending Manual Tests":

select *

from TM_ExecDefinitionRuns edr

where edr.Status = 7

and edr.ProjectID_fk = ?

Regards,

RolandK

[WojtekH]

I talked about automated tests, no matter Execution Plan or Test Runs

So, I supposed is this possible from database such as from Tracking/Current Executions

Regards,

Wojtek

[Roland Kern]

Hi,

this is not possible at the moment, currently running automated test runs can not be queried from the database.

For displaying automated test runs in Tracking/Current Executions, Silk Central contacts all execution servers and collects information on current executions.

Regards,

RolandK