Recently all of our users received new accounts, and their old accounts were saved and archived (ie: for each "user" there is now also "ARCHuser" for historical purposes). At least some of these accounts were instantiated yet never worked on any pages, and therefore do not need to be saved. Using RQL, is there a way to determine which users HAVE made changes to ANY page since the creation of their account? When you load a pages information ( <PAGE action="*load*" guid="* [!guid_page!]*"/> ) the "changeusername" provides the logon name of the person who edited the page, so if you ran a query for each page you would get a list of everyone who had edited pages. I was thinking you could then export the (very large) text response to Microsoft Excel, delimiting the data so that a Compare macro could be run on the "changeusername" field, comparing against a list of all of our users. Those that do not match would be the ones that have never made any edits. Would this work? I foresee a potential problem with running a query through every single page, is there a way to obtain this information by searching based on user info instead of page info? If this is a viable solution, how would I go about setting up a query to collect info from ALL pages rather than just one specific one at a time? Thanks for any ideas/help. -Brook
-- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/reddot-cms-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
