Query on user activity

Tristan Eastman · January 2020

Hi All,

I hope this message finds you all well. I'm interested in viewing user(s) activity within RE (i.e. how many and which records were accessed in a given time period, what was done while in those records) for specific user(s). Does anyone know if RE has this capability? If so, general how would one go about this?

Thank you,

Tristan

John Heizer · January 2020

You can query on "Last Changed By" and "Date Last Changed" for many record types, but exactly what was changed is not logged by RE.

Larry Wheeler · January 2020

I setup specific "Audit" queries and separate them as Run Monthly/Weekly/Daily. By specific, I mean NICKNAME is Blank, New Constituent Added, New Funds Created and so on. The output I include fields I want to see, including date last changed, last changed by.

Larry Wheeler · January 2020

Here are a couple of the older threads which helped me build my audit queries.
https://community.blackbaud.com/forums/viewtopic/147/26369?post_id=94229#p94229
https://community.blackbaud.com/forums/viewtopic/160/33931?post_id=126573#p126573

Of course, none of these would help you if no changes are made to the records.

Aaron Rothberg · January 2020

"how many and which records were accessed"

Unfortunately this information is not available. As John pointed out you can see who last saved a record, but you cannot see who accessed a record. I don't think even third party audit tools like Ziedman's Audit Trail offer this insight.

Tristan Eastman · January 2020

Wow! Thank you all for such helpful and insightful tips. I will first use the query John suggested and later peruse the audit queries you mentioned Larry.

Best,

Tristan

Query on user activity

Comments

Categories