"Last Run By" for queries?

Steven Koplin

 

We have a couple of very old queries created by some folks who are long gone from this organization. Nevertheless, a few of these queries get run regularly. My attempts to encourage the Users of these queries to step forward has gone unheeded.

Really, I just want to make sure they are getting what they want from these queries, but if not, can I update them to be more helpful.



It's easy to see when these queries are run, but not by whom.



So, is there a way to see "Last Run By" for queries?



Steven

JoAnn Strommen

Steven Koplin:

 

We have a couple of very old queries created by some folks who are long gone from this organization. Nevertheless, a few of these queries get run regularly. My attempts to encourage the Users of these queries to step forward has gone unheeded.

Really, I just want to make sure they are getting what they want from these queries, but if not, can I update them to be more helpful.



It's easy to see when these queries are run, but not by whom.



So, is there a way to see "Last Run By" for queries?



Steven

I don't know of any way to show 'last run by' for a query.  If there's a way, someone will let us both know. [:O]

Beth Romano

JoAnn Strommen:

I don't know of any way to show 'last run by' for a query.  If there's a way, someone will let us both know. [:O]

in query, right click on the header row and select column, you should be able to select "last run"

JoAnn Strommen

Beth Romano:

in query, right click on the header row and select column, you should be able to select "last run"

Sorry, Beth.  That's the date.  Sounded like he's looking for user name who ran it.

Steven Koplin

JoAnn Strommen:

Sorry, Beth.  That's the date.  Sounded like he's looking for user name who ran it.

Thanks JoAnn.

Yes, I'm looking for the name of the User who ran it.

Joshua Bekerman bCLO bCRE

Steven Koplin:

Thanks JoAnn.

Yes, I'm looking for the name of the User who ran it.

It appears that the "Last modified by" also gets updated when the query is run, even though nothing has actually been modified by the user (although technically it is modifying the date it was last run).  I tested it by opening a query, clicking the results tab, then closing the query.  It updated both the last modified (to my username) and last modified date (to today).

Might also be worth checking with Blackbaud  to see if this is correct.

James Andrews

Josh Bekerman:

It appears that the "Last modified by" also gets updated when the query is run, even though nothing has actually been modified by the user (although technically it is modifying the date it was last run).  I tested it by opening a query, clicking the results tab, then closing the query.  It updated both the last modified (to my username) and last modified date (to today).

Might also be worth checking with Blackbaud  to see if this is correct.

[quote user="Josh Bekerman"]

It appears that the "Last modified by" also gets updated when the query is run, even though nothing has actually been modified by the user (although technically it is modifying the date it was last run).  I tested it by opening a query, clicking the results tab, then closing the query.  It updated both the last modified (to my username) and last modified date (to today).

Might also be worth checking with Blackbaud  to see if this is correct.

[/quote] I actually just checked this as well and I don't think that's the case. I had someone open up a query, run it and then close it, and I still show up as the last to modify it.