I'm afraid I have no easy way to implement your query
On 18 July 2014 13:36, ARI HENDIAWAN <ari.hendia...@ocbcnisp.com> wrote: > 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> 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 > > > > > -- > 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
