Needed: script to email a list of users in the Activity table

[tom12010]

Very simple script needed, so we can keep track of who's logging out and who's not...

Something like:

USE DYNAMICS

select * from dbo.activity

really only just the user names and login time

save results somehow

email the results to an email address

do this as an agent job or SProc during the evening

I am not a SQL expert or programmer...

With this information we can better know what/how people are doing things...

Thank you, Tom

[tom12010]

Forgot: we are on GP 2013.