Catalog task Assigned to tracking

[pampapathi1]

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

[Ankur Bawiskar]

@pampapathi1 

if your requirement is get the time it was assigned for the 1st time then create a date/time custom field and populate it with the current time when assigned to is populated.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Selva Arun]

Hi Pampa,

Please refer the below community post which be a great start:

Solved: How can I determine when an SCTASK is assigned? - ServiceNow Community

If you believe the solution provided has adequately addressed your query, could you please **mark it as 'Helpful'** and **'Accept it as a Solution'**? This will help other community members who might have the same question find the answer more easily.

Thank you for your consideration.

Selva

[pampapathi1]

Hi @Selva Arun,

Thank you for the update,

I can see in the above it seams assignment group changes but I am looking when the  catalog task assigned date and time

Ex: Software group have 10 members 

Catalog task has been assigned to one person in a group (assigned date&time).

Please help me out on this 

Thanks

Pampa

[Swapna Abburi]

hi @pampapathi1 

You can configure Metric definition on 'assigned_to' field for sc_task table, it will capture start time, end time and duration as well in metric instance table. But this will  only show data for new tasks created after configuring the Metric definition.

It's not recommended to use sys_audit table in custom scripts, database view or reporting considering it's size.