Cost Centre Table Query.

[servicenow lath]

In the Cost Centre Table there is Manager field, where some managers are Inactive.

Need to Prupose a solution

whenever an user record becomes inactive,
identify and report all the areas where it is still used (cost center manager, other approval groups, assignment groups, etc.)
so this can be looked at and fixed.

[Ankur Bawiskar]

@servicenow lath 

you can have a report on your tables and share the report daily/weekly using scheduled report feature

what did you try so far?

[devservicenow k]

@Ankur Bawiskar What do i need to Create Scheduled job ? or

Reports?

I did not understand? 

navigators--> reports

or

Navigator--> Scheduled job

?

[Ankur Bawiskar · Accepted solution]

@devservicenow k 

you need to create report using Reporting module

then you need to create scheduled report and select that report and send it to recipients

Scheduled reports 

I hope this much information is sufficient enough for you to get started

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

[Ankur Bawiskar]

@servicenow lath 

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.