We trying to to replicate the below connection and data extract for local reporting:
ODBC CONNECT32 TO Confluence (XUserId is [Username], XPassword is [Password])
Content:
sql select
concat('https://jira.isometrix.net/confluence/pages/viewpage.action?pageId=', c.contentid),
concat('https://jira.isometrix.net/confluence/display/', s.spacekey,'/',replace(c.title,' ','+') ) as displayurl,
lower(lu.username) as likedby,
lower(lu.username) = lower(cu.username) as likedbyself,
c.contentid,
c.contenttype,
c.title,
s.spacekey,
lower(cu.username) as username,
c.creationdate,
to_char(c.creationdate, 'MONTH YYYY') as createmonthandyear,
to_char(c.creationdate, 'MONTH') as concreatemonth,
to_char(c.creationdate, 'YYYY') as concreateyear
FROM content c
left JOIN spaces s ON c.spaceid = s.spaceid
LEFT JOIN bodycontent bc ON c.contentid = bc.contentid
left join likes l on c.contentid=l.contentid
left join user_mapping lu on l.username = lu.user_key
left join user_mapping cu on c.creator = cu.user_key
WHERE c.prevver IS NULL
and lu.username is not null
AND c.contenttype IN ('PAGE', 'BLOGPOST');
TeamContent:
IntervalMatch (creationdate,username)
LOAD C_From_Date, C_To_Date,username
