I would also very much like to have reports for this. It would be very useful! Thanks :)

Hilde Bøe
Digital samlingsforvalter | Digital Collection Manager
DIRECT +47 23 49 35 24
MOBILE +47 414 56 515
SWITCHBOARD +47 23 49 35 00

Munchmuseet
Tøyengata 53, postboks 2823, 0608 Oslo
www.munchmuseet.no<https://urldefense.proofpoint.com/v1/url?u=http://www.munchmuseet.no/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=OBbtZVbzN8rfbkXH3j%2B8ujoy1ljHoEsfJwpPQJyzRag%3D%0A&s=308bbd47f7ed306eaf04825dab93e72aac5d366a3d2feafdce271ae5572201c3>
www.stenersenmuseet.no<https://urldefense.proofpoint.com/v1/url?u=http://www.stenersenmuseet.no/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=OBbtZVbzN8rfbkXH3j%2B8ujoy1ljHoEsfJwpPQJyzRag%3D%0A&s=aaf3cf22515b554b9ee04ad2e7915d87dce109bcd1384cb81e92af7f535a3fa2>
www.emunch.no<https://urldefense.proofpoint.com/v1/url?u=http://www.emunch.no/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=OBbtZVbzN8rfbkXH3j%2B8ujoy1ljHoEsfJwpPQJyzRag%3D%0A&s=4a85dd09ffea75026589b1e8cd7ee139e52494e0a239875449341a8b162b9fdc>

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Parsell, David
Sent: Tuesday, April 08, 2014 6:00 PM
To: [log in to unmask]
Subject: Re: User Stats

Chad, thanks for clarification regarding the data base server. You are correct, it will cause more problems than it solves, but it does work in crucial situations when you need to free up a license for another user. I used that method occasionally before I could control user access with a TS.

I would like to see two reports;


1.       One that lists each user and groups their activity by day/date and time using TMS. Grouped to identify weekly and monthly usage by user.


2.       A summary report that groups by day/date and time, TMS usage, to pinpoint the average TMS busy times and slack times.


David

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Tuesday, April 08, 2014 10:29 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: User Stats

A remote application server that is set to log users out after 60 minutes of inactivity should result in a clean logout. However terminating TMS through the SQL Server, while at times necessary, is not a viable solution. This will not close the application at the user end or record a logout in the LoginRecords table. An open user interface with no database connection is a recipe for unpleasant support calls, as the application will crash, and can generally only be closed by terminating the museum.exe process in Task Manager.

David, What sort of data would you be looking to have tabulated by this data in a report?
Chad Petrovay | Project Manager
[log in to unmask]<mailto:[log in to unmask]> | 646.733.2239 x252
GallerySystems | www.gallerysystems.com<https://urldefense.proofpoint.com/v1/url?u=http://www.gallerysystems.com/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=KJ3gb3%2FJybEOa96gOIuyCU04D1n8g%2FIdoAuYW%2BHO29w%3D%0A&s=791c0ab3e8dc6dbbda3e329858c9f6938a2f07beaab219ac9b5eaa7316e55b2f>


On Tue, Apr 8, 2014 at 9:58 AM, Jennifer De Martino <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Sarah, could you share where you found it?  I am not having any luck on my own.


From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Sarah Gillis
Sent: Monday, April 07, 2014 9:54 AM

To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: User Stats

Never mind, I found it!

Best Regards,

Sarah Gillis | Assistant Registrar, Image Management


WORCESTER ART MUSEUM / www.worcesterart.org<https://urldefense.proofpoint.com/v1/url?u=http://www.worcesterart.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Ad2eGFrNjuW%2Bbc1IHJZjsltX0GZw9cU%2FFRqD0glKEIw%3D%0A&s=aae0f98a49a10fa33120ad8aafbd31961a9dc96e56e3ab304f510e246ff85fe9>
fifty-five salisbury street / worcester, massachusetts 01609
508.799.4406<tel:508.799.4406>/ direct 508.793.4427<tel:508.793.4427> / fax 508.799.8638<tel:508.799.8638>

NOW ON VIEW
[cid:image001.jpg@01CF53D5.EB95B470]

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll
Sent: Monday, April 07, 2014 10:44 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: User Stats

Many thanks, Chad and Jeffrey!

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Monday, April 07, 2014 9:30 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: User Stats

You can also check the entries in the LoginRecords table. This tracks the LoginID, the computer name, and date/time of their login and logout (Please note that unclean logouts may not be registered in this table).
Chad Petrovay | Project Manager
[log in to unmask]<mailto:[log in to unmask]> | 646.733.2239 x252<tel:646.733.2239%20x252>
GallerySystems | www.gallerysystems.com<https://urldefense.proofpoint.com/v1/url?u=http://www.gallerysystems.com/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=96iVwCXIvTukb6%2FdjwcxxdJhmA3XiQEiWpn4Ap0a64Y%3D%0A&s=22aafa61379c5baf6f056507a7c59e9bee86607966c330ace17588b374ebd1c4>


On Mon, Apr 7, 2014 at 10:23 AM, Christine Droll <[log in to unmask]<mailto:[log in to unmask]>> wrote:
I, too, would like to know how to ascertain such information from my users!

Christine

Christine Droll
Collections Database Administrator
The Nelson-Atkins Museum of Art
4525 Oak Street
Kansas City, MO  64111-1873
T: 816-751-1333<tel:816-751-1333>
F: 816-751-0499<tel:816-751-0499>
[log in to unmask]<mailto:[log in to unmask]>



From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Sarah Gillis
Sent: Monday, April 07, 2014 9:21 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: User Stats

Hello List-Serv,

I was wondering if there is a way to obtain user stats in TMS.  We’re facing a log-on mini-crisis and I need to see who is using the database, how often, for how long.

My instincts tell me this is possible to obtain, but I haven’t done it before.

Le Help?

Best Regards,

Sarah Gillis | Assistant Registrar, Image Management


WORCESTER ART MUSEUM / www.worcesterart.org<https://urldefense.proofpoint.com/v1/url?u=http://www.worcesterart.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Ysd7AsBqL1lvBLEvCQW1%2B4Pu0BSZS6OPYQNOFF%2FVqZo%3D%0A&s=68b294949ae2440ba856f29cb09ffd31f0b7c45811dd5b1c6a6a1a301bc6107d>
fifty-five salisbury street / worcester, massachusetts 01609
508.799.4406<tel:508.799.4406>/ direct 508.793.4427<tel:508.793.4427> / fax 508.799.8638<tel:508.799.8638>

NOW ON VIEW
[cid:image001.jpg@01CF53D5.EB95B470]

*****************************************************************************
Our image reproduction application is now available online!
Image Reproduction Request<https://urldefense.proofpoint.com/v1/url?u=http://www.worcesterart.org/Collection/collection_information.html&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Ysd7AsBqL1lvBLEvCQW1%2B4Pu0BSZS6OPYQNOFF%2FVqZo%3D%0A&s=5f75ff518a18a4b47a7ea9fd44514a70386f9044cbc3523e39ef2be79c35fc94>

Want to own your own custom reproduction of a Worcester Art Museum masterpiece? Visit our partner Rudinec & Assoc. today!
RequestAPrint<https://urldefense.proofpoint.com/v1/url?u=http://www.requestaprint.net/worcester/index.php&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Ysd7AsBqL1lvBLEvCQW1%2B4Pu0BSZS6OPYQNOFF%2FVqZo%3D%0A&s=7b735ac086aae028f6eb70e7f0d6960ffc0d09affa4e8aff7bdc1343e67cd6d7>
Introducing: Zazzle! Our online museum shop where you can purchase custom merchandise containing images from our permanent collection!  Check it out today!
Worcester Art Museum - Zazzle Shop<https://urldefense.proofpoint.com/v1/url?u=http://www.zazzle.com/worcesterartmuseum&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Ysd7AsBqL1lvBLEvCQW1%2B4Pu0BSZS6OPYQNOFF%2FVqZo%3D%0A&s=2a783be68f8aa2ccd0bb1d75ed22a3946f78727f08123589561487ef75e6610e>


To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.