Resource Work Hours RRS feed

  • Question

  • Hi all

    I am trying to query the MS CRM Database for the work hours of the various resources that can carry out Service Appointments/Activities.

    Having scoured the forums I can only find what appear to be solutions using VB or C#, both of which I am unfamiliar with.

    Does anyone know of a SQL query or stored proc that will list the working hours by day for each resource?

    I have found the CalendarId for the people I am interested in, but I cannot figure out how to extract the work hours from the CalendarRule view (if this is the correct data source).

    Any help would be greatly appreciated.



    Wednesday, August 13, 2014 12:09 PM