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
  • 667 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