Related Articles
How to Get Size of a Database in Mysql
To Get Data Base Size in MB and Free Space in MBSELECT table_schema “dbName”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”, sum( data_free )/ 1024 / 1024 “Free Space in MB”FROM information_schema.TABLESGROUP BY table_schema ; To Get Size in GB: SELECT sum(round(((data_length + index_length) / 1024 […]
Linux Commands with Action
Type “Info” to get the list on the linux terminal. Linux Commands with Action Linux Commands List * aclocal: (automake)Invoking aclocal. Generating aclocal.m4. * autoconf: (autoconf)autoconf Invocation. How to create configuration scripts * autoheader: (autoconf)autoheader Invocation. How to create configuration templates * autom4te: (autoconf)autom4te Invocation. […]
Bonitasoft Groovy Scripts to Get Users Data
Using below Groovy Script code you will get the complete information of a particular user in Bonitasoftt To get Manager Email address in Bonitasoft: ${import org.ow2.bonita.facade.IdentityAPI;import org.ow2.bonita.facade.identity.User;IdentityAPI api = apiAccessor.getIdentityAPI();User user = api.findUserByUserName(processInstance.getStartedBy());User manager1 = api.getUserByUUID(user.getManagerUUID());return manager1.email;} To get Professional Email of a user : ${import org.ow2.bonita.facade.IdentityAPI;import org.ow2.bonita.facade.identity.User;IdentityAPI api = apiAccessor.getIdentityAPI();User user = api.findUserByUserName(processInstance.getStartedBy());User manager1 […]