A customer would like to know which IBM Connections Communities have a Sharepoint widget added. The following SQL statement should give the UUID and the name of these Communities:

The customer also wanted to send a mail to all creators of  these Communities. So he wanted to get a list of names and mail adresses of them. The following SQL statement creates that list:

As the original creator of a Community might no longer be in the company, it would be better to get a list of all Community owners who do have at least one Community with a Sharepoint widget added. You get that list with this statement:

You can use the same statements to find out about other widgets. Just replace “SharePointFiles” with the widget id of your choice.

The statements do work for ORACLE and you may need to adapt them for DB2.

Tagged with:  

Leave a Reply

© 2000-2015 Michael Urspringer