need ticket count for payload output 200

[ShaibaazFaheem]

Hello Community!

I wanted to count the number of tickets where the Payload output status is 200 and the ticket hop was routed to a specific group.

Any help is much appreciated.

[Tanushree Maiti]

Go To Outbound Http log 

Filter by response status =200 AND URL = <End point>  AND HTTP Method = <>

You will get ticket count for which you have received payload response 200

[Sachin_Nasa]

Hi @ShaibaazFaheem  ,

If the integration is designed using staging tables (inbound or outbound), the count can be derived directly by filtering records in those tables.

For integrations implemented using Script Includes, payload request/response details are often stored in integration-specific staging or log tables. You can filter the records where:

• Payload output status = 200

• Ticket hop was routed to the required assignment group

Common backend tables where this data may exist (based on implementation):

• Import Set tables (imp_*) – commonly used as inbound staging tables

• ECC Queue (ecc_queue) – used for MID Server–based integrations

• IntegrationHub execution tables – for Flow Designer / Action-based integrations

If IntegrationHub is used, checking the Integration Definition helps identify:

• The spoke or action used

• Where execution and response data is logged

• Which table stores payload status and routing details

Once the correct staging or execution table is identified, applying the required filters will give the needed count.

If you find this response helpful, please mark it as Helpful and accept it as the solution if it addresses your question—it would encourage me to contribute more to the ServiceNow Community.

Thanks & regards,
Sachin Narayanasamy