Report on change tasks Pulling certain data from description

[hoho1313]

Report on change tasks Pulling certain data from description

I need a reporting pulling just certain information from the description field. For instance I have a task Number "A00004534" there could be four or more of these numbers in that task. I need a report showing all those numbers. See attached file

 

[kmohammed]

You can create a custom report in ServiceNow to pull specific information from the description field of change tasks. Here are the steps to create such a report:

Navigate to Reports > Create New.
Select the "Change Task" table as the data source.
In the "Columns" section, add the "Number" field as a column.
In the "Filters" section, add a filter on the "Description" field.
In the filter condition, you can use the "Contains" operator and enter the pattern you want to match in the description field (e.g "A00004534").
Save the report.
Once the report is saved, it will display all the change tasks that contain the pattern "A00004534" in the description field, along with the change task number.

You can also include other columns like "Opened for", "Assigned to" etc to understand the context of the report.

It's important to note that this is just one possible way to accomplish this task and other methods may exist. It's recommended to test the report thoroughly in a development instance before deploying it to a production instance. Also, be careful when modifying or disabling any of the OOB functionality as it may affect the overall functionality of the instance.

[hoho1313]

Thank you for the response. I was able to get a report to show those Tasks. What I need is the report to ONLY show that A0000 # Only on the report. Nothing else from the description . 

[kmohammed · Accepted solution]

You can modify the report you created to only display the specific task numbers you're looking for. Here are the steps:

Navigate to the report you created and select it.
In the "Columns" section, remove all columns except for the "Number" field.
In the "Filters" section, add a new filter on the "Description" field.
In the filter condition, use the "Contains" operator and enter the pattern you want to match in the description field (e.g "A00004534").
In the filter condition, use the "Regular expression" operator and enter the pattern you want to match in the description field (e.g "A0000[0-9]{4}").
Save the report.
This will only show the change tasks that contain the pattern "A0000[0-9]{4}" in the description field, which will match the specific task numbers you're looking for. The regular expression used in step 5 will match any 4 digit number starting with A0000.

It's important to test the report thoroughly before deploying it to a production instance. And please be careful when modifying or disabling any of the OOB functionality as it may affect the overall functionality of the instance.