Extracting Location info from All Day Event in mailboxes into webpage RRS feed

  • Question

  • We have a requirement to identify where people are working as many of our staff move between offices.
    We were thinking about each person setting an All Day event where the location has been set.


    A script could then run daily to extract the information for the week on where each person in a division was located
    i.e. uses a particular AD group to enumerate through each Mailbox to produce an HTML file such as:

    User Monday Tuesday Wednesday Thursday Friday Saturday Sunday
    Adams, John London Luton Luton London Luton Home Home
    Smith, Mike Paris Chicago Chicago Chicago Chicago Chicago Home

    A second HTML file would be set up based on Location, so that the reception team were aware who would be in the office (for fire regulations etc)
    Smith, Mike Tuesday Wednesday Thursday Friday Saturday

    Adams, John Monday London

    Adams, John Tuesday Wednesday Friday

    Smith, Mike Monday

    Anyone come across this in the past, or could give me some pointers? We are moving everyone onto Exchange/Office10.

    Tuesday, December 6, 2011 2:29 PM

All replies