How to I get report on all users with last edited page and on which space that they have last edited

[Sachin Ramaprasad]

Hi, I'm trying to query on all users last edited page and on which space that was edited on. I could able to get the first part i.e., user vs last edited page (just the last page I need) but further querying onto which space that was done is what is really making my task quite difficult.

I was able to partially accomplish using following SQL query

SELECT u.lower_username, c.title, c.lastmoddate FROM content c join user_mapping u on u.user_key=c.lastmodifier where u.lower_username = '$user' group by c.lastmoddate DESC LIMIT 1;

From the above I could able to even join spaces table but my challenge is that some page that was edited by users , contains 'null' value in the db on which i'm trying match common columns 'spaceid' and i'm unable to retrieve space names of those edited page and that list is unfortunately pretty big for me.

Any idea if this is ever possible ?

[Victor Mutambuki]

sachin,

I don't know if this will fully give you what you need, however, you can take a look at the Content by User Macro

victor

[Sachin Ramaprasad]

Hi Victor,

I tried this macro and other content macros too , but this particular macro can run against just one user but I have 1000's of users and it becomes difficult. to have those in one page and also this gives a lot of content but i'm interested with just latest record. I was looking to automate this task running against this huge number of users. SQL or REST api is always helpful to automate our little tasks. I checked from REST api point of view, but I couldn't really get the data. So is there any other better idea to get this data ?

Cheers,

Sachin