I’d also welcome some information on how to run this type of report. 

Adding here, I’ve tried the API Browser Quick Grabs: Find Enrolled Users Without Sessions in a ILT/VILT Course that BFarkas shared.  Unfortunately, this is also a one-by process.  I need something that reports out over all ILT courses that I can run weekly to identify and do outreach to anyone sitting in limbo.

I think you might be able to do this if you create a Users-Courses report (under New Reports) & make sure you have ‘Number of Sessions’ selected in the Usage Statistics section.

once you’ve downloaded the report you can filter by anyone who has ‘0’ in the field (it looks like 0 shows up as blank, but it should still be easy enough)

I would welcome this as well. We have the same frustration. If there is an idea created, please share and I will 100% upvote. 

I created an idea for this, but they parked it. :-(

The related Ideas are all Parked.  Like everything else related to ILT improvements.  

If you haven’t already upvoted, not sure it actually helps, but here are some of them: 

Report to capture users enrolled in ILT course shells, but not a session | Community (docebo.com)

Notification for users not enrolled in a session but subscribed in the course | Community (docebo.com)

I think you might be able to do this if you create a Users-Courses report (under New Reports) & make sure you have ‘Number of Sessions’ selected in the Usage Statistics section.

once you’ve downloaded the report you can filter by anyone who has ‘0’ in the field (it looks like 0 shows up as blank, but it should still be easy enough)

This does NOT actually report Sessions Enrolled.  

Number of Sessions refers to the number of times someone accesses a course and interacts with training material.  Which could work for folks who are enrolled in ILTs with no training materials, but if we are directing folks to access other training material outside of a session, then a number will show up in that column, even if the user is not enrolled into a session.  

This is referenced in previous post: Report of people enrolled on ILT but not attached to session | Community (docebo.com)

I think you might be able to do this if you create a Users-Courses report (under New Reports) & make sure you have ‘Number of Sessions’ selected in the Usage Statistics section.

once you’ve downloaded the report you can filter by anyone who has ‘0’ in the field (it looks like 0 shows up as blank, but it should still be easy enough)

This report does NOT actually report Sessions enrolled.  

Number of Sessions refers to the number of times someone accesses a course and interacts with training material.  Which could work for folks who are enrolled in ILTs with no training materials, but if we are directing folks to access other training material outside of a session, then a number will show up in that column, even if the user is not enrolled into a session.  

It’s referenced in previous post here: Report of people enrolled on ILT but not attached to session | Community (docebo.com)

The best way I’ve managed this so far was to view courses in Course Management and filter by the ILT course type and have the Enrollments column displayed.  Then I can visually see which courses have users enrolled but not enrolled in sessions and see how many users for each course.

So I am definitely onboard with having some sort of report option for this!  I’ve also been asked for course enrollment reports that show WHICH session the users are enrolled in, not just that they are enrolled in a session.

If the User-Course report includes all enrollments, and the User-ILT Session report includes everyone who is enrolled in a session, would I be right in thinking that if you get both reports, you can get the list you want by filtering the first report to exclude the second?

Don’t get me wrong, I can’t fathom why Docebo wouldn’t offer more functionality for this use case, but I’m just thinking that for now, these two reports can give you something to go on if you can combine them using either Power Query in Excel or the QUERY function in Google Sheets. Or just some kind of VLOOKUP hackery either way?

(Also, Docebo Connect or Power Automate could make light work of repeating the API approach for a single course, if either is available.)

I’m sure I can pull multiple reports and manually manipulate the data.  Lots of extra ridiculous work for something that should just be a reportable data in the platform. 

I have Docebo Connect, but haven’t been able to figure out how to cycle the API that Brian shared using the triggers in the recipe.  Also, it requires an additional connector and we pay for Connect per connector...I can’t waste a connector license on something like this. 

You can run the Users - ILT Sessions report to get which sessions are enrolled.  Just include the course information and the session information in your view/field options. 

We use that for the basis for our Attendance/Completion Audit, but use similar for just a Session Enrollment Report. 

Good luck!

I fully agree that you should not need to do these things. But by the same token, with the right techniques, my point was that it’s not that time-consuming to pull two tables into Excel or Google Sheets and merge the queries so that you’re left only with the users you’re looking for, and it would get you the data you need right now. But no matter, because:

You do not need an additional connector. The existing Docebo Learn connector that comes with every Docebo Connect subscription will work just fine for all Docebo API endpoints.

Re: Cycling, it does require a bit of knowledge re: Workato utilities (e.g. lists, repeat actions) but there is definitely a pay-off for learning how to use these.

I just made a recipe that gets all ILT/VILT courses, then cycles through them and gets all the enrolled users without sessions. On our platform, the recipe took two minutes to find 8,274 such users across 84 different ILT courses. Which is actually not a problem for us, by the way, I just mention it to demonstrate that the recipe can handle large numbers of both users and courses. I’m unable to share the recipe as a Community Recipe unfortunately, but I’ll explore whether it’s possible for me to share it using a private link instead. Need to do some due diligence there.

Would also love to see significant improvement to the options, management and reporting of ILT sessions. Very hard to operate session for global regions without a massive amount of extra time and configuration.

I agree on everything said here - Docebo has a ton of work to do around their ILT interface and the reporting capabilities associated with it.  Sad to see so many ideas are parked.  :(

I also agree. As much as I’d like to learn Workato and the Docebo API, I’m a one-man show as the Docebo superadmin, which is just one of my job roles.

I’ll mention this issue to my customer success rep - I have a meeting with them and our COO tomorrow. 

I also agree with the need for better reporting and management of the ILT Sessions and training materials in them. For most systems, this is a standard part of the application. I’m eager to learn the thought process behind the current setup as maybe I’m missing some part of a bigger plan in their roadmap. 

Hi @Ian  I’m wondering if you were able to share the recipe here? I’m still struggling with writing recipes.  I’ve taken all the trainings from Docebo and Workato. I am still failing.  I don’t have anyone to work with live.  I’ve scheduled for a live training with Workato as  Docebo doesn’t seem to offer anything other than DU and it’s woefully inadequate for what I’m trying to do.  Any help, screenshots, etc. are appreciated.