Is there any order in which records are stored in SessionDetails and Conferences Table in Lync Archiving DB? RRS feed

  • Question

  • Hi,

    Archiving Database Schema states that in the tables SessionDetails and Conferences tables, the column 'SessionIdTime' holds datetime value at which session request is captured by Archiving service.

    But, is there any order in which the records are stored in the db?

    Say, a session 'S1' starts at 1:00 PM and another session 'S2' starts at 1:05PM. 'S2' ends at 1:10 PM and 'S1' is still on going. I have observed that on ending the session the record is written to DB, so is it possible that details of session S2 is written in db prior to 'S1'?

    Is there any way to query these tables, in the order in which the records are stored?

    Thanks and Regards,


    • Edited by arjabhsay01 Tuesday, January 28, 2014 3:59 PM
    Tuesday, January 28, 2014 3:52 PM