Is there a way to get a list of users with active subscriptions? The closest I found was a report on e-commerce transactions, but most of our subscription purchases do not run through Docebo’s e-commerce; they are paid via PO/invoice and we manually create the subscription transaction in Docebo.
I have contacted support and they indicated there is no report to do what I want. They suggested contacting our customer success manager to potentially obtain this data through a “custom DB query reports”. However, we don’t have a CSM.
Question
Get a list of users with active subscriptions?
+1
+1Support is correct that there isn't a native report type dedicated specifically to subscription assignments unless they pass through the e-commerce checkout flow. However, you don't need a custom DB query to pull this data.
There are two ways to handle this:
1. The API Approach (Quickest for a one-off list) You can retrieve this data directly using the Docebo API. The endpoint GET /learn/v1/sub_record returns all subscription records in your platform, including those created manually by admins. You can run this via the API browser or Postman and export the JSON results to CSV. You can find this endpoint referenced in the API essentials documentation.
2. The User Additional Field Approach (Best for long-term reporting) In organizations I've worked with that handle PO/invoice payments outside of Docebo, the pattern that holds up best is syncing the subscription status to the user's profile. We typically use Docebo Connect to listen for subscription updates and automatically map that status to a "Subscription Active" User Additional Field (e.g., Yes/No).
Once that status lives directly on the user profile, you can generate standard built-in Custom Reports (like a simple Users report) and filter by that field. This completely bypasses the need for e-commerce reporting and makes the data accessible to your admins inside the platform.
Let me know if you want to dig deeper into the API payload or the Connect setup.
+1Thank you Moshe for the ideas. I haven’t used the API browser before but played around with it yesterday. I need some more time to make the output of the json file more useful to me (I made some mistakes importing it into Excel I think). And I’m also interested to use Connect as you mentioned. It would also make it easier for us to ensure the status we pass back to Salesforce (also likely through Connect) would be accurate.
Log in to Docebo Community
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Docebo Employee Login
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.