question time sheet not submitted / report to show uses who have not created time sheets. in SPM forum

time sheet not submitted / report to show uses who have not created time sheets.

User141348 — Wed, 03 Jun 2020 20:12:42 GMT

I am running a time sheet exception report that includes time sheet not submitted. My understanding is that this should show users who haven't created a time sheet, but it appears it doesn't work. Has anyone figured out how to report out on users how have not created time sheets/cards? I can report on those who are pending but I can't figure out how to see users who haven't even created a time sheet.

Re: time sheet not submitted / report to show uses who have not created time sheets.

Jayarnab Saha — Thu, 04 Jun 2020 11:45:31 GMT

Hi,

Timesheet(time_sheet) has a field sys_created_by which says, who has created this timesheet.

So, you can aggregate on time_sheet table to get the list of user who has created time sheet.

Then you can find out the list of users from user table, who has role timecard_user.

By checking the difference between above list, you can find out who haven't even created a time sheet.

Hope this will be helpful for your query.

Thanks,

Jayarnab

Re: time sheet not submitted / report to show uses who have not created time sheets.

Glenn Bowman — Thu, 04 Jun 2020 18:50:00 GMT

We have a report like that described by Jayarnab. Also, we are working on custom code to create empty timesheets weekly for those with the timecard_user role, this way with 1 report we can identify timesheets not submitted on time, including those who haven't initiated time entry for the week.

Hope this is helpful.

Glenn

Vidant Health

Re: time sheet not submitted / report to show uses who have not created time sheets.

sachin_namjoshi — Thu, 04 Jun 2020 18:57:51 GMT

This is available OOB with Timesheet dashboard where you have missing widget which gives you time sheets which are not submitted.

https://docs.servicenow.com/bundle/orlando-it-business-management/page/use/dashboards/application-content-packs/time-sheet-dashboard.html

Regards,

Sachin

Re: time sheet not submitted / report to show uses who have not created time sheets.

sachin_namjoshi — Thu, 04 Jun 2020 18:58:53 GMT

This is available OOB with Timesheet dashboard where you have missing widget which gives you time sheets which are not submitted.

https://docs.servicenow.com/bundle/orlando-it-business-management/page/use/dashboards/application-content-packs/time-sheet-dashboard.html

Regards,

Sachin

Re: time sheet not submitted / report to show uses who have not created time sheets.

Duncan Pedersen — Mon, 12 Apr 2021 14:03:03 GMT

We solved this by creating a scheduled job, to automatically create blank Time Sheets (time_sheet) records for users with the timecard_user role for the current week.

Re: time sheet not submitted / report to show uses who have not created time sheets.

rdskn023ET — Thu, 02 Dec 2021 15:23:04 GMT

So with this setup, you are creating a time sheet, which sets it to a state of Pending, correct? Could you share any information on the setup you used? Thanks!

Re: time sheet not submitted / report to show uses who have not created time sheets.

YummyAmericano — Mon, 08 May 2023 15:52:26 GMT

Hey! Can you please share your configuration for this? We would like to create blank time sheets for the user with the timecard_user role for the current week. Thanks!