######
#  Check ExId (GUID) by Email through JDBC
#
#  Author:        Christoph Stoettner
#  Mail:          christoph.stoettner@stoeps.de
#  Documentation: http://scripting101.stoeps.de
#
#  Version:       2.0
#  Date:          2014-06-04
#
#  License:       Apache 2.0
#
#  Check ExId of a User in all Connections Applications

import ibmcnx.functions

dbs = ['FNOSDS', 'FNGCDDS', 'IBM_FORMS_DATA_SOURCE', 'activities', 'blogs', 'communities', 'dogear', 'files', 'forum', 'homepage', 'metrics', 'mobile', 'news', 'oauth provider', 'profiles', 'search', 'wikis']    # List of all databases to check

for db in dbs:
    t1 = ibmcnx.functions.getDSId( db )
    AdminConfig.show( t1 )
    print '\n\n'
    AdminConfig.showall( t1 )
    AdminConfig.showAttribute(t1,'statementCacheSize' )
    AdminConfig.showAttribute(t1,'[statementCacheSize]' )
@@ -347,16 +347,109 @@
 ctions%0A%0A
+dbs = AdminConfig.list('DataSource', AdminConfig.getid('/Cell:cnxwas1Cell01/'))%0Aprint dbs%0A#  
 dbs = %5B'
@@ -685,17 +685,23 @@
 o check%0A
-%0A
+#  %0A#  
 for db i
@@ -707,16 +707,19 @@
 in dbs:%0A
+#  
     t1 =
@@ -750,16 +750,19 @@
 d( db )%0A
+#  
     Admi
@@ -776,24 +776,27 @@
 .show( t1 )%0A
+#  
     print '%5C
@@ -800,16 +800,19 @@
  '%5Cn%5Cn'%0A
+#  
     Admi
@@ -833,16 +833,19 @@
 l( t1 )%0A
+#  
     Admi
@@ -892,16 +892,19 @@
 Size' )%0A
+#  
     Admi

Create documentation of DataSource Settings