tag:blogger.com,1999:blog-3160669066424815487.post2024172671171439732..comments2024-03-29T05:21:41.514-07:00Comments on Dynamics GP Essentials: User Activity Report - Idle and Login Details SQL ScriptMahmoud M. AlSaadihttp://www.blogger.com/profile/07632688723943735412noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-3160669066424815487.post-89159230227776652972020-06-11T15:15:34.897-07:002020-06-11T15:15:34.897-07:00Hello Mahmoud, maybe you have a script update, I a...Hello Mahmoud, maybe you have a script update, I am using GP2016 and 2018Erickhttps://www.blogger.com/profile/08265910669282163761noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-86895065531409437032016-03-25T14:13:27.923-07:002016-03-25T14:13:27.923-07:00Hello Angelo
Unfortunately, after GP 2013 R2, a n...Hello Angelo <br />Unfortunately, after GP 2013 R2, a new process was added which primarily checks for pending messages on each client, this means, that the idle details for users using the desktop client will always be 0, making this piece of information quite misleading. <br /><br />Thank to Tim Wappat for providing this insight. <br />I will make sure to update this post once an alternative solution is found. <br /><br />Never hesitate to share any further inquiries, <br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-41569287122012234552016-03-23T08:51:25.258-07:002016-03-23T08:51:25.258-07:00Hello Mahmoud - we currently use GP 2015 R2.Hello Mahmoud - we currently use GP 2015 R2.Anonymoushttps://www.blogger.com/profile/06354182620039400231noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-57083029545424283152016-03-22T04:51:22.145-07:002016-03-22T04:51:22.145-07:00Hello Angelo
What is your Dynamics GP version ?
B...Hello Angelo<br />What is your Dynamics GP version ?<br /><br />Best Regards <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-64880766388804565932016-03-21T12:44:40.891-07:002016-03-21T12:44:40.891-07:00Mahmoud - when a user in this report has a blank S...Mahmoud - when a user in this report has a blank SQL Last Batch and Idle Time, what does that mean? Sorry, our previous guy set us up this SSRS report. But he left. :(Anonymoushttps://www.blogger.com/profile/06354182620039400231noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-74150499248843145552016-03-01T00:30:06.789-08:002016-03-01T00:30:06.789-08:00If a user created a new batch at 10:00am and have ...If a user created a new batch at 10:00am and have started entering transfer entries. He keeps creating multiple transfer entries to different sites in the same batch. Lets say he finish his work in the same batch at 11:30am, he stopped doing transfer entries in the batch, did not posted the batch and have started some Internet surfing. You have run this script at 11:50am, what will this script show about the idle time of this user?adihttps://www.blogger.com/profile/05705009468585762557noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-65698252250162569222015-12-10T03:12:31.502-08:002015-12-10T03:12:31.502-08:00So far, there is no alternative solution. I will u...So far, there is no alternative solution. I will update this post once a valid solution is ready<br /><br />Best Regards, <br />Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-91020480410918219442015-12-09T08:17:10.580-08:002015-12-09T08:17:10.580-08:00Hello Mahmood. Were you able to update this to use...Hello Mahmood. Were you able to update this to use with GP 2013 R2. I understand that 2015 is out but have not yet upgraded and will not until mid 2016.Manny Vhttps://www.blogger.com/profile/06126340956824454112noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-72634533320248232272015-09-23T10:41:40.582-07:002015-09-23T10:41:40.582-07:00That's a valid point Tom ;)
Although, I am tr...That's a valid point Tom ;) <br />Although, I am trying to find out another alternative rather than omitting the idle time, it actually represents an essential piece of information for this specific report.<br /><br />Updates will be provided accordingly. <br />Thanks a lot Tom, Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-51897588266602521242015-09-23T05:42:56.255-07:002015-09-23T05:42:56.255-07:00Why don't you rewrite the script to NOT includ...Why don't you rewrite the script to NOT include idle time??<br />That should only take 5-10 minutes. :) :)<br />Don't procrastinate. :) :)<br />Thank you, Tomtom12010https://www.blogger.com/profile/15632565465598049872noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-85842385848442188592015-01-02T14:32:21.988-08:002015-01-02T14:32:21.988-08:00Hello Rick
I would need to revise and get back to ...Hello Rick<br />I would need to revise and get back to you. <br /><br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-62813765201975812782015-01-02T09:34:17.064-08:002015-01-02T09:34:17.064-08:00Great script that we've used in the past. But...Great script that we've used in the past. But we just upgraded to R2 of GP2013 and it no longer calculates idle time correctly. THe last_batch is getting constantly updated on our system when users are actually idle. Perhaps a background process is running that makes it appear that the user is active.<br /><br />Any thoughts on how to get it working correctly with R2???<br /><br />Thanks.<br />Rick SeaveyAnonymoushttps://www.blogger.com/profile/11373604234459935038noreply@blogger.com