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

[User141348]

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. 

[Jayarnab Saha]

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

[Glenn Bowman]

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

[sachin_namjoshi]

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-co...

Regards,

Sachin

[sachin_namjoshi]

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-co...

Regards,

Sachin