I had the same question, and finally today, decided to pursue it and found your forum post.
I used the “MetaSQL” Design under the Maintenance screen to type in this query and when the results came up I right-clicked inside the results and chose “Copy All”. Which I could then paste into MS Excel. You can change the criteria to fit your needs - I just happened to only want the item numbers created after a certain date. The “I” is for “Item”. I’m using xTuple 4.9.5. Hope it helps all these years later. The forums have been a great way to learn xTuple.
select comment_date, comment_user, item_number, item_descrip1, item_descrip2
from comment, item
where
comment.comment_source_id = item.item_id and
comment_date >= ‘2018-02-01’ and
comment_text = ‘Created’ and
comment_source = ‘I’
order by comment_user, comment_date, item_number;
You may have already figured this out. I’m learning from experimenting in “Test Mode” (menu option in the MetaSQL Editor) with simple SQL statements. Having a simple solution out there for other users might help someone. Thank you.