Dears,
I am trying to create custom view to show employees calendar information (working hours, day off, holidays) and use this view to create pivot table but I didn't know the employee calendar information stored in which table.
appreciate your help.
Thanks and Regards,
Osama Mahmoud
*This post is locked for comments
Dear Alagu,
Thank you, the links are working.
but I want to query working hours using SQL query, as I need to create custom view and use it from power pivot table and I don't know in which table I can find it.
so I appreciate if you can help me.
Regards,
Osama Mahmoud
Hi
I think below link is "Prashant" wants to share
Query the working hours of a user
https://msdn.microsoft.com/en-us/library/gg327841.aspx
Query the working hours of multiple users
Dear Prashant,
Sorry for delay but the link still not working, I receive the below when try to open links:
Regards,
Osama Mahmolud
Dear Prashant,
Thanks for your help but the links are not working.
Regards,
Osama Mahmoud
Query the working hours of a user
https://msdn.microsoft.com/en-us/library/gg327841.aspx
Query the working hours of multiple users
https://msdn.microsoft.com/en-us/library/gg334424.aspx
Edit Work Hours as a direct link from the Ribbon
Dear Mark,
Thanks for your help,
from employee information console, I configured work schedule and time off for employees as below:
now I need to create custom view from SQL management console to show this information per employee and use it to measure employees total working hour and time off, to evaluate employee performance.
Regards,
Osama Mahmoud
Hi Osama
Could you elaborate a little on Employee Calendar? would this be the Availability or Service One?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (