what database?
On 17 July 2014 17:04, ARI HENDIAWAN <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> 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
