Creating a Report for Active and Closed Change Tasks

[ellencarpen]

I manage a dashboard that has multiple reports and recently noticed 2 reports are not generating results. I believe the report owner might be pulling data from the wrong table but am not sure. The goal is to see all Active and closed (Last Month) Change Tasks for 10 plus users. Currently, the data is being pulled from the Change Task table.

Can someone assist with correct table and criteria to generate correct reports? (Please note, I do not have admin privileges; however, I can create/modify reports.)

[AndersBGS · Accepted solution]

Hi @ellencarpen ,

If it is only all active and closed closed last month, then the report should have a condition as "closed on last month".... The reason that nothing is generated could be, that when a change task is closed, then it's not active any longer. When that said, In general it is very hard to state why it is not running without knowing your current configuration. So please change condition as stated or share your cofiguration.

[J Siva · Accepted solution]

Hi @ellencarpen

Change task (change_task) is the correct table.

Condition is pretty straightforward "active is true" or "closed on last month "

Try the above and let us know 

Regards,

Siva

[AndersBGS · Accepted solution]

Hi @ellencarpen ,

If it is only all active and closed closed last month, then the report should have a condition as "closed on last month".... The reason that nothing is generated could be, that when a change task is closed, then it's not active any longer. When that said, In general it is very hard to state why it is not running without knowing your current configuration. So please change condition as stated or share your cofiguration.

[J Siva · Accepted solution]

Hi @ellencarpen

Change task (change_task) is the correct table.

Condition is pretty straightforward "active is true" or "closed on last month "

Try the above and let us know 

Regards,

Siva

[Aniket Chavan · Accepted solution]

Hello @ellencarpen ,

If you’re able to create or modify reports, then you're already halfway there. Just to clarify — are you mainly looking to confirm the correct table name for Change Tasks?

If so, the correct table is change_task. Once you select this table while creating your report,  just try to add the filter condtions as per your need  and Additionally, filter by Assigned to if you want to target those 10+ users and try to run the filter and validate the data.

Let me know how it works for you.

🔹 Please mark ✅ Correct if this solves your query, and 👍 Helpful if you found the response valuable.

Best regards,
Aniket Chavan
🏆 ServiceNow MVP 2025 | 🌟 ServiceNow Rising Star 2024

[ellencarpen]

Thanks. Everything was filtered properly. After some researching, I realized that the Change Tasks have an Assignment Group but the Assigned To for all of the tickets were Empty. The report is filtered on Assigned To (can't utilize an Assignment Group for this particular report), hence the message, "Cannot generate the report. No matching records."