How do I create a report for user Subscriptions?

Environment:

Knowledge Advanced for Oracle B2C Service 

Issue:

There is no OOB (out of box) report for user subscriptions.  When CP users (contact users) or .NET and BUI users (account users) view an article in search results they can create a subscription to that article.  The subscription will send a notification when the article is updated.  The okcs_subscription table shows subscriptions for both CP users and .Net/BUI users.   But there is no indication for the users subscription type.

Limitation on Custom Analytics Reporting on the KA Subscriptions

Resolution:

A report can be created from the OOB okcs and Accounts and Contacts tables.  By using the outer joins you can show both types of users.  Here is an example report definition.

This report definition will produce a simple grid report of the subscriptions in the system.