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.