That is perfect. Thank you SO much. I can't believe that Epicor didn't tell me about that.
--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Since you are Progress you will have to stick with BAQ's. Create yourself a Dashboard and look primarily at the SysTask table. With a little creativity you can create a comprehensive dashboard monitoring all the ongoing tasks.
>
> Here's the SQL query and you can at least get an idea. I made this a view in SQL and hit it from the intranet with ASP and I just keep it up on my monitor all day. It's a little fancy, but you'll get the idea.
>
>
> select
> top 500
> systasknum as 'Task ID',
> (case datepart(dw,startdate)
> when 1 then 'SUN '
> when 2 then 'MON '
> when 3 then 'TUE '
> when 4 then 'WED '
> when 5 then 'THR '
> when 6 then 'FRI '
> when 7 then 'SAT '
> end ) +
> Upper(convert(varchar(15),startdate,107)) as 'Start Date',
> right(('00' + convert(varchar(2),(((starttime)/60)/60))),2) + ':' +
> right(('00' + convert(varchar(2),convert(int,60*(((convert(decimal(15,10),starttime)/60)/60) - ((starttime/60)/60))))),2)
> as 'Start Time',
> case endtime
> when 0 then (datediff(s, convert(varchar(10),getdate(),1)+ ' ' + '00:00:00.000', getdate())) - starttime
> else endtime - starttime
> end as 'Seconds Elapsed',
> Upper(taskdescription) as 'Task',
> taskstatus as 'Status',
> Replace(Upper(submituser), '.', ' ') as 'User',
> Case lastactivitytime
> when 0 then ' N/A '
> else
> Upper(
> right(('00' + convert(varchar(2),(((lastactivitytime)/60)/60))),2) + ':' +
> right(('00' + convert(varchar(2),convert(int,60*(((convert(decimal(15,10),lastactivitytime)/60)/60) - ((lastactivitytime/60)/60))))),2)
> + ' @ ' + convert(varchar(15),lastactivitydate,107)
> )
> end as 'Last Activity Stamp',
> from systask
> order by systasknum desc
>
>
>
>
>
>
> Vic Drecchio
> ERP Administrator
> TIMCO Aviation Services
> Greensboro, NC
> Email:Â Â vic.drecchio@...
> Mobile:Â 704.530.3092
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of lapulsifer
> Sent: Friday, July 31, 2009 3:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: How can I monitor user activity in Vantage?
>
> I have asked Epicor the same question lots of times. The support staff thinks it would be helpful to have such a tool also.
>
> There are tools in SQL server, but it would be nice if Epicor would provide something easy to use.
>
> We previously used a VMS application. You could easily see the processes that users were running to the screen level in the application. You could also easily see server process usage by user.
>
> --- In vantage@yahoogroups.com, "dardelano" <ddelano@> wrote:
> >
> > What tools are available for me to monitor user activity in Vantage (8.03.305, Progress)?
> >
> > We occaisionally have processes that appear to be "stuck", when in fact they are probably waiting in a queue to run. How can I see that? I previously used an AS/400 and was able to run commands to see what users were doing, adjust their CPU or job priority, re-arrange work in a work queue, etc.
> >
> > Thanks,
> > Darlene
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>