Hi Max,
we use MySql form database

tks
On 7/17/2014 6:03 PM, Maxim Solodovnik wrote:
what database?


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

    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.




--
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