Venio Console: Need to detect if any processes are running for a particular project

The Problem

I need to check if there are any processes that are running for a particular project.

Resolution

The following query will show if any process is running for a project. This query has to be run in the project database.

SELECT *FROM tbl_ds_ServerDetail WITH(NOLOCK)
WHERE 
RunningInstances.value('(/RunningInstances/Instance/ProjectId)[1]','bigint')=replace_with_your_project_id