This request is content system based, so not useful for ASR connection to STATS - it might come in useful for those using openDB.
I am looking for assistance with a query that will list the courses that a Content System item is linked to. I have built a query - given below - which will obtain all content within the given schema. I would like to know if it can be adapted to include the ID of a Courses(s) or Organization(s) when the item has been linked to.
F.FILE_ID as Files_FID, U.FILE_ID as URLS_FID, F.FILE_SIZE, F.MIME_TYPE,
U.FILE_ID = F.FILE_ID
order by U.FULL_PATH asc
Within the GUI you can look at links but not to my knowledge against a bulk of courses in one go. The basis for this request is to determine linked content, versus non linked content for environment cleanup.
Any assistance appreciated