I was just looking into this yesterday. On our community, the friend request is initiated when a user clicks on 'Add as Friend' button. I was able to see get the Friendship requests sent i.e pending, Rejected, Accepted from the following query in jive application database.
select count(distinct jiveuserrel.relationshipid)as "Friends Accepted Count"
, to_char(to_timestamp(jiveuserrel.creationdate/1000), 'YYYY-MM')as "Friendship create date"
left join jiveuser on jiveuser.userid = jiveuserrel.relateduserid
---and jiveuser.username like '%erin%'
and jiveuserrel.state ='approved' --- can use other status like pending, rejected
group by to_char(to_timestamp(jiveuserrel.creationdate/1000), 'YYYY-MM')
order by "Friends Accepted Count" desc
Thank you so much! This helps a bunch to get me started. This particular group wants to know the friend requests sent just between their group, so it makes it a bit more difficult, but this definitely helps me a bunch, thanks again!
If this a special user group, then you may be able to use the following tables to get to that information-
jivesgroupmember, jivesgroup, jiveuser
where jivesgroup.groupid = jivesgroupmember.groupid
and jiveuser.userid = jivesgroupmember.userid