How to identify a Plan with Clover results (we have hundreds of plans)

[Craig Solinski]

I understand the Clover link is visible on the Summary line when opening a plan if it was configured to execute Clover.

Is there an way to identify which plans among hundreds use Clover? (SQL or otherwise...?)

Thanks,

Craig

[Marek Parfianowicz]

Hi Craig,

The following query returns jobs for which the "Use Clover to collect code coverage for this build" check-box is enabled:

select
  project.title, chain.title, job.title, job.full_key
from
  project
  join build as chain on chain.project_id = project.project_id
  join chain_stage as stage on stage.build_id = chain.build_id
  join build as job on job.stage_id = stage.stage_id
  join build_definition on build_definition.build_id = job.build_id
where
  build_definition.xml_definition_data like '%<custom>%<clover>%<exists>true</exists>%';

The following query will return you jobs for which the "Clover Report" artifact is defined:

select
  project.title, chain.title, job.title, job.full_key, artifact_definition.label
from
  project
  join build as chain on chain.project_id = project.project_id
  join chain_stage as stage on stage.build_id = chain.build_id
  join build as job on job.stage_id = stage.stage_id
  join artifact_definition on artifact_definition.producer_job_id = job.build_id
where
  artifact_definition.label like 'Clover Report%';

Cheers
Marek