How to identify restricted courses? [On-premise]

In order to identify every course that has restrictions, you can use the following script:

SELECT c.CONTENTID, c.TITLE, s.SPACEKEY, s.SPACENAME
FROM SPACES s
JOIN CONTENT c ON s.SPACEID = c.SPACEID
JOIN CONTENT_PERM_SET cps ON c.CONTENTID = cps.CONTENT_ID
where c.pluginkey = 'com.mute.confluence.plugins.lms:course-type' and c.PREVVER is null

CODE

This script will generate a list in the following format: