A couple approaches come to mind:
1. Do it externaly. Use ARSPerl to query the data and walk the status history. You could build hashes with the user names and request ids as keys to prevent duplicates. If you are familiar with ARSPerl this is quick and easy to do.
2. Build a form (User Counts) with one row for each user and some date and scratch fields. Then you can loop over each row in the form and get a count for that user either by:
- Using filters to generate SQL based on the username and date you push in.
or
- Using a server side table field in the above User Counts form that uses an external qualification that you build with filters like the ones that you would use to build the sql.
or
-Using two table fields (one that looks at User Counts and one that looks at your ticket form). You could then use an active link guide to walk the User Counts table. On each row, you build a qualification for the second table field, get a count, then push it some where.
3. Push to a counting form (with username, ticket id, and date) everytime someone touches a ticket. Count this form.
In any of these cases you will need to push the results back somewhere, preferably into a stats form where you have one record per user per day.
All of these approaches have their advantages and disadvantages. The two table field approach is very portable, but requires manual intervention to get the data. The SQL approach can probably very efficient, but may not be as portable. The ARSPerl approach can be very flexible and only requires one query. And so on.
Joe
On 10/17/06, Myst3K <[EMAIL PROTECTED]> wrote:
Hey,
I am trying to come up with a way to tickets touched a day by each
user. The closest I can come up with is this macro.
('Status-History.Work In Progress.TIME' >= "$Start Date$" AND
' Status-History.Work In Progress.TIME' <= "$End Date$" AND
'Status-History.Work In Progress.USER' = "$Username$") OR
('Status-History.Assign.TIME' >= "$Start Date$" AND
'Status-History.Assign.TIME ' <= "$End Date$" AND
'Status-History.Assign.USER' = "$Username$") OR ('Status-History.Follow
Up.TIME' >= "$Start Date$" AND 'Status-History.Follow Up.TIME' <= "$End
Date$" AND ' Status-History.Follow Up.USER' = "$Username$") OR
('Status-History.Closed.TIME' >= "$Start Date$" AND
'Status-History.Closed.TIME' <= "$End Date$" AND
'Status-History.Closed.USER ' = "$Username$")
This works pretty well, because it excludes multiple touches, and only
pulls up for the day specified. The only problem is that I have 20
users I need to pull this up on. Is there a way to pull a list of
usernames from a file?
Such as this line:
('Status-History.Work In Progress.TIME' >= "$Start Date$" AND
'Status-History.Work In Progress.TIME' <= "$End Date$" AND
'Status-History.Work In Progress.USER' = "$Username$
c:\home\usernames.txt")
I am using Remedy User 6.03.
Thank You,
Myst3k
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
