RadioDJ - Free Radio Automation Software Forum

Song Counts

Song Counts
« on: October 28, 2017, 09:58:36 PM »
Ya know i find it odd that every post that i search dealing with song counts have no replys. Does anyone know how to retreive the total # of songs played each month, just the number? Those of you reporting to BMI, ASCAP and the like have to do this anyways. No biggie, just find it strange that no one replies to any post regarding this.

Re: Song Counts
« Reply #1 on: October 29, 2017, 12:13:07 AM »
To retrieve total number of play count per month, use the database setup utility of RadioDJ that can be found in radiodj/setup folder and RUN this SQL QUERY:

SELECT COUNT(ID) FROM SONGS WHERE DATE_PLAYED LIKE '%2017-10%';

it will count all songs played for the month of October 2017.

Re: Song Counts
« Reply #2 on: January 17, 2018, 04:41:16 AM »
the report plugin seems to do this perfectly!

Randy