Time Worked report w/support group and created date
Hi all, so I'm working off a great query, which gives:
the assigned user's name,
the SR or IR #,
the category ,
and time worked on each request (the "time worked" which shows on the Results or Resolution tab of any SR or IR, which is manually entered by analysts).
It's run against Service Manager. However there's a couple things I'm trying to figure out.
1) Can the time be converted to Hours in the query so I don't have to calculate it later in Excel formulas?
2) How to also pull in the assigned user's support group?
3) How to pull in Created Date
4) How to remove billable time portion of the query without breaking it.
Any help would be awesome, thank you!