I need to be able to identify the date when an object (user, group, folder, connection, universe, etc) was initially created and when it was last modified.
What repository tables and fields is this info, if available, stored in?
We are using BOXI SP2.
thanks
aardvarck 
(BOB member since 2007-09-17)
Use Query Builder…
Try this:
SELECT SI_KIND, SI_NAME, SI_CREATION_TIME FROM CI_SYSTEMOBJECTS
WHERE SI_KIND IN ('User', 'Group', 'Folder', 'Connection','Universe')Not sure if this suffice your needs.
BO_Chief 
(BOB member since 2004-06-06)
Thanks for that; that’s exactly what I’m after.
Is the same information available if I create a universe against all CI* tables and then query via the universe or only when I use the Query Builder.
Regards
aardvarck (BOB member since 2007-09-17)
Only via the SDK (Query Builder is a simple front-end to the SDK), not queried directly (like with a universe). For (an attempt at) a better explanation of why, see this post.
Dwayne Hoffpauir (BOB member since 2002-09-19)