Sounds like a deal! Thanks for the help On Monday, March 4, 2013 6:27:19 PM UTC-5, Jian Huang wrote:
> 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] <javascript:>> > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > 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.
