Overview

Sometimes customers need detailed reports for videos. However, the only available information is present in the Content Leaderboard CMR report and this report only shows the Total Content count.

The Content report does not show videos as a content type.

This article assists you in finding the count and details of videos, for cases when customers want to know how many videos were in there and the whole analytics report for videos.

Information

Affected Version

The affected Hosted instance is Jive 9.0.2.

Steps to Reproduce

1. Ensure you have the video plugin enabled and working fine.
   
2. Create a few videos.
   
3. Wait for the 2 AM ETL run.
   
4. Go to CMR > Content Creation.

Actual Behavior

Videos are missing.

Expected Behavior

Videos should be present.

Solution

• This issue has been addressed in the Jive JIRA Bug ticket CUSTOM-2565. Therefore, Video Analytics Content is visible in Jive 9.0.3 and above.
  
• Depending upon the request received, use the following queries to check the videos using the Magic Query tool.
  
  
  • To check the number of videos on the whole instance:
    

    SELECT COUNT(*) FROM jiveVideo;

  • To check all video details and properties:
    

    SELECT * FROM jiveVideo;

Back to Top