About SRP
When UGC is saved to shared storage, there is a single instance of member content that may, in most deployments, be accessed from both the author and publish environments. Regardless of SRP choice (MSRP, ASRP, JSRP), all must be accessed programmatically with the SRP API.
ASRP
If there is ASRP, UGC is not stored in JCR, it is stored in a cloud service hosted and managed by Adobe. UGC stored in ASRP may not be viewed with CRXDE Lite or accessed using the JCR API.
See ASRP - Adobe Storage Resource Provider.
It is not possible for developers to access the UGC directly.
ASRP uses Adobe cloud for queries.
MSRP
If there is, MSRP, UGC is not stored in JCR, it is stored in MongoDB. UGC stored in MSRP may not be viewed with CRXDE Lite or accessed using the JCR API.
See MSRP - MongoDB Storage Resource Provider.
While MSRP is comparable to ASRP, as all AEM server instances are accessing the same UGC, it is possible to use common tools to directly access the UGC stored in MongoDB.
MSRP uses Solr for queries.
JSRP
JSRP is the default provider for accessing all UGC on a single AEM instance. It lets you quickly experience AEM Communities 6.1 without the need for setting up MSRP or ASRP.
See JSRP - JCR Storage Resource Provider.
If there is JSRP while UGC is stored in JCR, and it is accessible in CRXDE Lite and JCR API, Adobe recommends that you never use JCR API to do so. If you do, future changes may affect custom code.
Further, the repository for the Author and Publish environments is not shared. While a cluster of publish instances results in a shared publish repository, UGC entered on Publish is not visible on Author, hence no ability to manage UGC from author. UGC is only persisted in the AEM repository (JCR) of the instance on which it was entered.
JSRP uses the Oak indexes for queries.