Creating reports for hours worked from a timesheet in ServiceNow

[Danielle10]

Great day! Would someone be able to help me with this?

I am trying to create reports for hours worked from a timesheet in ServiceNow.

Which table should I be using? There is a Timecard table, Timesheet table, and Task table.

For the following reports, which table should I be using? 

• Report by Project - # hours by person for each time period, including task name charged
• Report for all RESOURCES People - # hours by day charged to all projects (don't need split out), PTO, S&O Administrative

[Rahul Kumar17]

Hi 

To create reports for hours worked from a timesheet in ServiceNow, you should use the Time card table.

The Time card table contains all the time entries that have been recorded by users. It includes fields such as user, date, duration, and task, making it the best table to use for creating reports on hours worked.

The Timesheet table is used to represent a collection of time cards, while the Task table is used to represent individual tasks that are being worked on. While these tables contain relevant information, they may not have all the necessary fields needed to accurately report on hours worked.

To create a report on hours worked, you can use the reporting features within ServiceNow, such as the report designer or the Performance Analytics module. You can create a report that aggregates the time entries from the Time card table based on different criteria, such as by user, by task, by date range, or by project. You can also create charts and dashboards to visualize the data and make it more accessible.

Thanks,

Rahul Kumar

[ParmeseevenC]

I am also interested with this reporting.  Is there a way we filter the report by [Company]?