Tks Maxim..
its works and now i can generate that report with a little tricky because i must collect data then compare and then calculate data to get the result..
if posible, we can get duration per user per room without tricky ?


tks
On 7/17/2014 12:00 PM, Maxim Solodovnik wrote:
please also check conferencelogtype DB table it should contain "roomLeave" type
then select from conferencelog with this type id


On 17 July 2014 10:42, ARI HENDIAWAN <ari.hendia...@ocbcnisp.com <mailto:ari.hendia...@ocbcnisp.com>> wrote:

    Dear Openmeetings forum,
    my management want to know report usage per user in specific
    conference room..
    can any one help me how to generate this report ?
    i tried to collect data from conferencelog table in database but
    on this table not shown date and time of leave room (this table
    only show inserted date and time to specific room)


    tks
    Ari Hendiawan
    IT Division
    OCBCNISP Bank
    Indonesia


    --
    Disclaimer :
    Confidential information may be contained in this message. If you
    are not the intended recipient, you are strictly prohibited and
    may be unlawful to use, copy, store, distribute, disclose or
    communicate any part of it to others and you are obliged to return
    it immediately to sender or notify us and delete the e-mail and
    any attachments from your system. Opinions, conclusions and other
    information in this e-mail that do not relate to the official
    business of any PT Bank OCBC NISP Tbk shall be understood as
    neither given nor endorsed by it. No assumption of responsibility
    or liability whatsoever is undertaken by PT Bank OCBC NISP Tbk in
    respect of prohibited and unauthorised use by any other person.




--
WBR
Maxim aka solomax




--
Disclaimer :
Confidential information may be contained in this message. If you are not the 
intended recipient, you are strictly prohibited and may be unlawful to use, 
copy, store, distribute, disclose or communicate any part of it to others and 
you are obliged to return it immediately to sender or notify us and delete the 
e-mail and any attachments from your system. Opinions, conclusions and other 
information in this e-mail that do not relate to the official business of any 
PT Bank OCBC NISP Tbk shall be understood as neither given nor endorsed by it. 
No assumption of responsibility or liability whatsoever is undertaken by PT 
Bank OCBC NISP Tbk in respect of prohibited and unauthorised use by any other 
person.

Reply via email to