Check Orch Items

select name,COUNT(id) from vlocity_cmt__OrchestrationItem__c where 
((vlocity_cmt__OrchestrationPlanId__r.vlocity_cmt__OrderId__r.MC_SourceSystem__c='Clarity'
OR vlocity_cmt__OrchestrationPlanId__r.vlocity_cmt__OrderId__r.MC_SourceSystem__c='ECommerce')
AND ( vlocity_cmt__State__c ='Ready' OR vlocity_cmt__State__c = 'Running' )
AND CreatedDate <LAST_N_DAYS:7)
AND
(Name ='Fiber Installation Completion'
OR Name ='SAP Hardware Provisioning Completion - Router - POD'
OR Name ='SAP Hardware Provisioning Completion - Streama - POD'
OR Name ='SAP Hardware Provisioning Event - Router - POH'
OR Name ='SAP Hardware Provisioning Event - Streama - POH'
OR Name ='Fiber - Wait LeadId')
GROUP BY Name