How to create a Stored Query to display all change orders with workflow tasks in pending status?

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Create a scoreboard node to display Change Orders with workflow tasks in Pending status.

Environment

Service Management 17.x

Resolution

Please 

group.[group]group_list.member IN (@cnt.id) AND id.[chg]workflow.status IN (\'PEND\')

To display all Change Orders which has tasks in pending status irrespective of the group please use the below query:

id.[chg]workflow.status IN (\'PEND\')