SCTM - query for current executions
Hi, does anyone have any idea query for Current Executions. I searched each table and view in database, but I didn't find.
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":
from TM_ExecDefinitionRuns edr
where edr.Status = 7
and edr.ProjectID_fk = ?
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
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.