Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Catalog task Assigned to tracking

pampapathi1
Tera Expert

‎02-13-2025 07:12 AM - edited ‎02-13-2025 07:13 AM

Hi Everyone,

 

I need to create a report in ServiceNow that shows when Catalog Task(sc_task)was assigned to a group member date and time. I have created the database view for sys_audit and sc_task tables but it will not working as expected.

Could you please help on this.

 

Thanks,

Pampa

0 Helpfuls
  • 871 Views
5 REPLIES 5

Prajwal Chauhan
Tera Expert

‎02-15-2025 09:35 PM - edited ‎02-15-2025 09:39 PM

Hi @pampapathi1 , 

You mentioned you have already created a database view. Now you want to create a report based on that database view to show when a Catalog Task (sc_task) was assigned to a group member, including the date and time. Correct?
 

Database View:

PrajwalChauhan_0-1739684078621.png

Report based on Database View:

PrajwalChauhan_1-1739684109940.png

 

The ‘Created’ column (from sys_audit) represents the date and time when the catalog task was assigned to a member of the group.

If I was able to help with your query, please click the thumbs-up icon and mark it as correct!

Prajwal

 

 

0 Helpfuls