I don't have a single query with all of this information handy but combining results for these 2 will get you what you want.
Query for Views of Ideas:
join jivedw_object on jivedw_object.dw_object_id = jivedw_activity_fact.direct_dw_object_id
left join jivedw_day on jivedw_day.day_id = jivedw_activity_fact.day_id
left join jivedw_container on jivedw_container.dw_container_id = jivedw_activity_fact.dw_container_id
where jivedw_day.begin_ts > '2/1/2015'
and jivedw_day.begin_ts <= '3/1/2015'
and jivedw_activity_fact.activity_type = 10
and jivedw_activity_fact.direct_object_type = 3227383
Query to return all Ideas and where they live:
select idea.ideaid,juser.username,juser.userid,idea.score,stage.stagename, idea.containertype,community.name as "Space Name"
from jiveidea idea
left join jiveideastage stage on stage.stageid = idea.stageid
left join jivecommunity community on community.communityid = idea.containerid
left join jiveuser juser on juser.userid = idea.userid