Hi Marissa,
There's a few options available here
a. Query the database tables directly
e.g. to fetch the last logon details:
select IO_USR.USR2 username, IO_USR.USR3 fullname, cast(IO_USR.USR16
as datetime) lastlogin
from ioAdministration.dbo.IO_USR IO_USR
order by username
(page create/change info might be a bit tricky with a lot of joins and
obscure field names)
b. There is a Reporting Module available (obviously at additional cost
from Open Text) which can provide various user, project, page, status
type reports.
You could potentially work out some SQL queries to fetch the page
created and
c. Use RQL and some scripting (e.g. asp) logic
Perhaps, list all pages for the project
<IODATA loginguid="[!guid_login!]" sessionkey="[!key!]">
<PROJECT>
<PAGES action="list"/>
</PROJECT>
</IODATA>
Then loop and load the info for each and
<IODATA loginguid="[!guid_login!]" sessionkey="[!key!]">
<PAGE action="load" guid="[!guid_page!]"/>
</IODATA>
and look at the createdate, createusername/createuserguid, changedate,
changeusername/changeuserguid
Paul.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"RedDot CMS Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/reddot-cms-users?hl=en
-~----------~----~----~----~------~----~------~--~---
