Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Suggested answer

how to Query Today Work hours of a Bookable resources

Posted on by 245

Hello,

I am trying to Query today's work hours (start time, End time, Duration and Time Zone)  for Bookable resource. I tried using advanced find and XrmToolBox. could you please help me to query using XrmToolBox or any other tool.

  • Erdem Profile Picture
    Erdem 5 on at
    RE: how to Query Today Work hours of a Bookable resources

    So when I have a system with 3000 users and bookable resources, what method is recommended to see which resources have work time set or even the work time is set until a certain date?

  • Anthony Dong Profile Picture
    Anthony Dong on at
    RE: how to Query Today Work hours of a Bookable resources

    Hi ,

    I don't think you can filter the resource availability as one record. resource availability is more like a rule rather than records, it depends on the booking already scheduled.  

    We don’t have specific entity to extract/export the resource availability currently.  Resource Availability still depends on Schedule Board for display .

    pastedimage1593748479538v1.png

    To View the availability of each resource, I would like to suggest you view it in Schedule Board, but extracting the availability data is not supported. You can raise your suggestion or ideas here experience.dynamics.com/.../this would be helpful as the more votes will help PG understand Customer’s needs to have this feature developed.

  • raki Profile Picture
    raki 245 on at
    RE: how to Query Today Work hours of a Bookable resources

    I tried XMLBuilder but can't pull start time, end time and Duration.

  • Suggested answer
    Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: how to Query Today Work hours of a Bookable resources

    You will need to use XrmToolBox with the XMLBuilder.

    The two entities you need to look for is Calendars and CalendarRules entities. The CalendarRules entity holds the information you are looking for but the results are stored as XML and not flat records so it may be a little more difficult to report on than normal.

    Each Bookable Resource will have a CalendarId which you will need to find out to get the correct resource.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans