Hi @junaid_vengadan .  Not complex at all.  You just tick the box at the bottom of the properties tab - advanced properties, use physical table.  Then you can work with that physical table using your other sql update queries.   Regards ... View more

Hi @junaid_vengadan. You need a source to "tsart the connections. If your source is a a csv with 2 columns, License Name and Manual consumption, import that to a physical table; then use the update script provide to set consumption using a join to your physical table. Regards ... View more

Hi. He only needs admin rights to download the lms archive.zip. To export the instance view he would just need read rights to the view Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)86 208 0237 | Block E, Midridge Office Estate South, International Business Gateway Park, Cnr New and Sixth road, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)21 741 0939 | Fax: +27 (0)21 552 7764 | BG01, Roma House, The Forum, Northbank Lane, Century City, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. ... View more