Brook, I...I think I have the solution, but it will cost you karma.
I will post it tomorrow morning. Your cost: if you are buying coffee, pay for the guy in line behind you as well. Sent from my iPhone On Mar 4, 2013, at 3:20 PM, Brook <[email protected]> wrote: > 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. > > -- 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.
