The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Last login - SLX Network User
Posted: 14 Mar 06 5:49 PM
|
Is there any way to show the last time a Network user logged into SalesLogix?
My problem is that I know there are licenses that aren’t being used and I need to free a few up. This is an easy task to perform with the remote user accounts, so I am looking for suggestions to monitor Network user accounts for usage and last DB login date/time. |
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 12:08 AM
|
I do not believe there is a stock product feature that handles this. I suggest adding a Global Script and in the Application_LogonComplete event insert a record into a custom table with the currentuserid. You can then compare the active userids to the userids in your log table to identify "retireable" users.
Timmus |
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 1:14 AM
|
AFAIK there's no built in way. Timmus' suggestion is the way to go. However, that will only tell you what is what from now on, but won't help you with knowing how things have gone before now.
-Ryan |
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 2:41 AM
|
To follow from the earlier posts. The use of a table populated at logon and logoff is something I have done in the past.
I recorded to the table, the userid, the login time, the machine name and then the log off time.
Since a new record was created each time the user logged on, a complete history could be viewed and average login periods calculated. Maybe the next step will be count the number of keyclicks per session 
|
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 3:54 AM
|
| I believe that the USEROPTION table has this information in it, in the MODIFIEDDATE field. Must admit I'm completely unsure what this table does, but anecdotally - this is what I use and it seems to be perfectly accurate. |
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 7:30 AM
|
There is a small script that Mike Spragg has wroitten and disbursed quite freely that handles just what your looking for.. Send him an e-mail @ mike.spragg@gmail.com and ask him for the LoginTracking utility he built. I'm sure he'll share it with you.
Ryan, btw great improvement since you first put this site up.
Thanks
Rich |
|
|
| |
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 7:49 AM
|
buy sertraline canada buy sertraline online fluoxetine and alcohol vomiting fluoxetine and alcohol blackout |
|
|
| |
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 8:30 AM
|
| Though not exact, I check the last modified date and user for opportunities, activities, and history. This doesn't ctach the users that are just looking at other people's info but if someone is not enter/updating opportunities or scheduling and completing activities then that's a wasted license, in my opinion. Setup a Web Host and give them a cheap Web Viewer license. |
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 9:15 AM
|
Originally posted by Mike Spragg
Yes, I have a bundle for this (Ryan, do you want me to email this to you to put on this site ?)
mike.spragg@e1business.com
|
|
Yes Mike, that would be great. Send it over and I put it on the site! 
Thanks
-Ryan |
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 9:47 AM
|
lexapro and weed trip lexapro weed and alcohol read lexapro and weed naltrexone buy can you buy naltrexone over the counter
Thanks for writing it. I asked our partner for help on this one and didn't get an answer. -K |
|
|
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 10:35 AM
|
| Mike has done an EXCELLENT job on this. It even syncs to remotes! This is even better than what I was looking for!!!! |
|
|
| |
| |
|
Re: Last login - SLX Network User
Posted: 15 Mar 06 4:44 PM
|
cialis generico online italia consegna veloce pillola cialis controindicazioni msahin.net |
|
|
|
Re: Last login - SLX Network User
Posted: 26 Mar 06 2:10 PM
|
fiogf49gjkf0d We also run something similar to what Rob describes. It was built by a former employee from code he got from an SLX dev course in Scottsdale some years ago. The script fires on login and logout. I built an ASP.NET web app to show user login count and hours as well as some other key metrics. The ASP.NET app allows a user to filter on Department (from UserInfo) to see users under their purview. SLX needs to provide more managerial tools such as this as part of the out-of-the-box application!
One suggestion - the table name in our db is "BIGBROTHER"... when a recent hiccup caused an error writing to this table, users saw an error message about a problem writing to BIGBROTHER. I like "TIMELCLOCK" better. |
|
|
|
Re: Last login - SLX Network User
Posted: 26 Mar 06 9:04 PM
|
alcohol and antidepressants citalopram citalopram hbr and alcohol Originally posted by Rick Smith
when a recent hiccup caused an error writing to this table, users saw an error message about a problem writing to BIGBROTHER. I like "TIMELCLOCK" better. |
|
Hehe. Nice. I guess they all know big brother is watching now. |
|
|
| |
| |
|