Drop Table AR0float

2011-10-04 Thread Joseph Kasell
Our environment - 
Application Server:
MS Windows 2003 SP 1
ARS 7.0.01, patch 001
ITSM 6
CMDB 1.1, patch 4

Database Server:
MS Windows 2003 SP 2
MS SQL 2005

Our Remedy service suddenly began to run very sluggishly with users reporting 
long wait times to bring up or to update a case, or to login.  This issue 
occurred for a couple of minutes (5 at most) before it cleared and users were 
able to access the system normally.

A check of the SQL logs at about the time of the slowness revealed the 
following:

  /* Tue Oct 04 
2011 11:25:37.1530 */DROP TABLE AR0int620
  /* Tue Oct 04 
2011 11:25:37.1530 */OK
  /* Tue Oct 04 
2011 11:25:37.1530 */UPDATE T28 SET 
C18255=NULL,C179='AG0019B9BBD70CSCWLTg9ArbDQr#cQ',C18254=5,C5='Remedy 
Application Service',C6=1317741937 WHERE C1 = '0508322'
  /* Tue Oct 04 
2011 11:25:37.1530 */OK
  /* Tue Oct 04 
2011 11:25:37.1530 */DELETE FROM T25 WHERE C1 = '8337604'
  /* Tue Oct 04 
2011 11:25:37.1530 */OK
  /* Tue Oct 04 
2011 11:25:37.1530 */OK
  /* Tue Oct 04 
2011 11:25:37.1530 */DELETE FROM H25 WHERE entryId = '8337604'
  /* Tue Oct 04 
2011 11:25:37.1530 */UPDATE T29 SET C18022 = 'placeholder' WHERE C1 = 
'3097234'
  /* Tue Oct 04 
2011 11:25:37.1530 */OK
  /* Tue Oct 04 
2011 11:25:37.1530 */COMMIT TRANSACTION
  /* Tue Oct 04 
2011 11:25:37.1680 */OK
  /* Tue Oct 04 
2011 11:25:37.1680 */SELECT T27.C1,T27.C1 FROM T27 WHERE (T27.C18032 = 
'00018333725') ORDER BY 1 ASC
  /* Tue Oct 04 
2011 11:25:37.1680 */OK
  /* Tue Oct 04 
2011 11:25:37.1680 */BEGIN TRANSACTION
  /* Tue Oct 04 
2011 11:25:37.1680 */OK
  /* Tue Oct 04 
2011 11:25:37.1680 */DELETE FROM T31 WHERE C1 = '00018333725'
  /* Tue Oct 04 
2011 11:25:37.1680 */OK
  /* Tue Oct 04 
2011 11:25:37.1680 */DELETE FROM H31 WHERE entryId = '00018333725'
  /* Tue Oct 04 
2011 11:25:37.1680 */*** ERROR ***  Cannot drop the table 'AR0int620', because 
it does not exist or you do not have permission. (SQL Server 3701)
  /* Tue Oct 04 
2011 11:25:37.1680 */DROP TABLE AR0float620


This message repeats with references to "drop table AR0float" or "drop table 
AR0char" or "drop table AR0decimal".  I've never seen this before and wonder 
what does this refer to? 

Joe Kasell
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"


Re: Random Email Recipient

2010-01-26 Thread Joseph Kasell

Lyle,

Thank you for the response.

We're tracking along the same lines about defining a group of managers to
select from.  My question is how to automate the selection of a random
alternate manager.  I was thinking about a separate form with a table from
which to use a filter guide to walk through the table and select a manager.
But then the question is making sure that the selection of a manager is
done equitably so that no one manager is inundated.  I may be making this
more difficult that I should, and wanted to know how others may have
approached this.

Joseph Kasell
Global IT Services
Information Services
Navy Federal Credit Union





|>
| From:  |
|>
  
>|
  |Lyle Taylor   
   |
  
>|
|>
| To:|
|>
  
>|
  |arslist@ARSLIST.ORG  
   |
  
>|
|>
| Date:  |
|>
  
>|
  |01/25/2010 07:41 PM  
   |
  
>|
|>
| Subject:   |
|>
  
>|
  |Re: Random Email Recipient   
   |
  
>|
|>
| Sent by:   |
|>
  
>|
  |"Action Request System discussion list(ARSList)"
   |
  
>|





--_000_D6A3C9D35C65C14D8E7B5487609CD2A2252F1891E9MBX01ldschurc_
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="ISO-8859-1"

One possibility might be to look at all the Assignee Manager login IDs on
t=
he tickets you have randomly selected and then randomly select one of the
o=
ther managers from that list.  So, for example, you select X number of
rand=
om tickets, and among those tickets, there are Y number of managers (where
=
Y is probably less than X, but must be greater than 1 to be valid).  The
id=
ea would be, for any given ticket, find any other manager in your set of Y
=
managers that is not the manager of the assignee for that particular
ticket.

Does that make sense?  The idea of using the set of assignee managers for
t=
he tickets you've picked is mainly to be an easy way to ensure that you're
=
picking a valid manager.  However, there may be other ways to do it,
includ=
ing maintaining a list of managers that can be chosen from, or finding a
wa=
y to determine that list automatically via the People form, etc.

Lyle

From: Action Request System discussion list(ARSList) [
mailto:arsl...@arslis=
T.ORG] On Behalf Of Joseph Kasell
Sent: Monday, January 25, 2010 2:13 PM
To: arslist@ARSLIST.ORG
Subject: Random Email Recipient

**

Hello listers!

Received a heads-up of a possible requirement from management.

They are emphasizing a quality review of help desk tickets and one idea
wou=
ld have workflow that would identify a random subset of help desk tickets,
=
then send an email with a link for each ticket to a manager so that the
tic=
ket could be reviewed. At first I thought that this would be easy as I
woul=
d use an idea published on this board previously to generate that ticket
su=
bset, and then have the email sent to the manager of the assignee, which
is=
 recorded in the Assignee Manager Login field 

Random Email Recipient

2010-01-25 Thread Joseph Kasell


Hello listers!

Received a heads-up of a possible requirement from management.

They are emphasizing a quality review of help desk tickets and one idea
would have workflow that would identify a random subset of help desk
tickets, then send an email with a link for each ticket to a manager so
that the ticket could be reviewed.  At first I thought that this would be
easy as I would use an idea published on this board previously to generate
that ticket subset, and then have the email sent to the manager of the
assignee, which is recorded in the Assignee Manager Login field of the Help
Desk form.  However, I was told that the email needs to go out to a random
manager who is not the manager of the ticket assignee - in other words, an
ID that does not match that recorded in the Assignee Manager Login field.
Does someone have an idea or suggestion as to how I might randomly select
another manager as an email recipient?  Appreciate the help.

BTW.we're using ARS 7.0.01 and ITSM 6, and MSSQL 2005.

Thank you!

Joseph Kasell
Global IT Services
Information Services
Navy Federal Credit Union
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Form Refresh Question

2009-08-21 Thread Joseph Kasell
Good morning!

Looking for help here on the following.

I have a form with a button which has an active link that performs an
Application-Delete-Entry on the displayed record.  That part works fine.
What I want is for a refresh of the query of the form so that I can see a
list of the remaining records following the delete.

The refresh was easy since it only was a matter of adding a second action
of an Open Window in Modify mode with the qualification of 1=1.  However,
the issue is that each time this active link is run, it opens up a new
window of the form rather than refreshing the current window, so when you
perform several deletes in succession, you end up with the same number of
open windows of that form for each delete.  How can I refresh the same
window?  I feel like I'm overlooking something obvious so I guess part of
my asking is a sanity check.

I'm using ARS 7.0.01 patch 001 on the server and the clients.

Appreciate the help!

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Re: Perl Question

2009-07-29 Thread Joseph Kasell
Carey,

Appreciate the info.  I knew about the ARSPerl site and went there for
assistance on the install and also to look at code examples.  That and this
board have been very helpful...especially of late.  We have an initiative
to push more people into using Remedy here, which is great.  The only bad
thing is that we also had a reorg and I lost one of my developers, so I
have been having to do more with less.  It's been quite the challenge.

Thanks again!

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union




   
 Carey Matthew 
 Black 
   arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussion list   Subject 
 (ARSList)"Re: Perl Question   
   
   
   
 07/28/2009 03:17  
 PM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




Joseph,

You will find some help for ARSPerl on ARSList.
However you may find more help on the ARSPerl mailing list(s) too.
  https://lists.sourceforge.net/lists/listinfo/arsperl-users

Hope that helps some in the future. :)

Just to be clear, if the question is ARS related then ARSList is a
good place to ask it.(Even if your actual problem is a Perl/Java
issue. If it is directly ARS related.. then bring in on. :) ) However
there are also more specialized places to ask detailed niche ARS
questions too. (ARSPerl's list is only one of the other more specific
ARS sites that I can think of.)

--=20
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP)
ARS =3D Action Request System(Remedy)

Love, then teach
Solution =3D People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Tue, Jul 28, 2009 at 1:40 PM, Joseph
Kasell wrote:
> Hello listers!
>
> I'm simultaneously diving into perl and arsperl for the first time and
I'=
m
> seeing a lot of possibilities at what one can do. =A0I'm also running
int=
o a
> bit of a headache in the following which, I'm sure, is a simple matter,
b=
ut
> I'd like some advice.
>
> The Perl script is as follows:
>
>
>
> #!/usr/local/bin/perl
> use ARS;
>
> ($c =3D ars_Login("servername", "user", "password")) || die "ars_Login:
> $ars_errstr";
> if (!$c) {print("Could not connect to ARS ($ars_errstr)\n");exit(1);}
>
> ($r =3D ars_SetEntry($c, "Joetest", "002", 0, "536870914",
> "Bob")) ||
> =A0 =A0 =A0 =A0 =A0 =A0die $ars_errstr;
>
>
>
>
> This works fine from the server console and from a run process within an
> active link. =A0My question has to do with the set entry command. =A0How
=
can I
> pass a variable from a Remedy field to field ID 536870914 on form Joetest
> in this script instead of the hard-coded value of "Bob?" =A0Again, I'm
su=
re
> this is a simple matter, but I'm new to this, and I'm very certain I'm
> overlooking something. =A0Appreciate the help!
>
> Joe
>
> Joseph Kasell
> Senior Systems Engineer
> Navy Federal Credit Union

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Re: Perl Question

2009-07-28 Thread Joseph Kasell
Fred,

That was exactly it!  Thank you for the quick response and help!

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union



   
 "Grooms,  
 Frederick W"  
 arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussion list   Subject 
 (ARSList)"Re: Perl Question   
   
   
   
 07/28/2009 01:49  
 PM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




I think you are looking for the shift() function in perl.

(Notice how I added in the $variable in your example to pull the data
from the command line)

Perl Help:   http://perldoc.perl.org/index-language.html

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joseph Kasell
Sent: Tuesday, July 28, 2009 12:41 PM
To: arslist@ARSLIST.ORG
Subject: Perl Question

Hello listers!

I'm simultaneously diving into perl and arsperl for the first time and
I'm
seeing a lot of possibilities at what one can do.  I'm also running into
a
bit of a headache in the following which, I'm sure, is a simple matter,
but
I'd like some advice.

The Perl script is as follows:



#!/usr/local/bin/perl
use ARS;

my $variable =3D shift();

($c =3D ars_Login("servername", "user", "password")) || die "ars_Login:
$ars_errstr";
if (!$c) {print("Could not connect to ARS ($ars_errstr)\n");exit(1);}

($r =3D ars_SetEntry($c, "Joetest", "002", 0, "536870914",
$variable)) ||
die $ars_errstr;




This works fine from the server console and from a run process within an
active link.  My question has to do with the set entry command.  How can
I
pass a variable from a Remedy field to field ID 536870914 on form
Joetest
in this script instead of the hard-coded value of "Bob?"  Again, I'm
sure
this is a simple matter, but I'm new to this, and I'm very certain I'm
overlooking something.  Appreciate the help!

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Perl Question

2009-07-28 Thread Joseph Kasell
Hello listers!

I'm simultaneously diving into perl and arsperl for the first time and I'm
seeing a lot of possibilities at what one can do.  I'm also running into a
bit of a headache in the following which, I'm sure, is a simple matter, but
I'd like some advice.

The Perl script is as follows:



#!/usr/local/bin/perl
use ARS;

($c = ars_Login("servername", "user", "password")) || die "ars_Login:
$ars_errstr";
if (!$c) {print("Could not connect to ARS ($ars_errstr)\n");exit(1);}

($r = ars_SetEntry($c, "Joetest", "002", 0, "536870914",
"Bob")) ||
die $ars_errstr;




This works fine from the server console and from a run process within an
active link.  My question has to do with the set entry command.  How can I
pass a variable from a Remedy field to field ID 536870914 on form Joetest
in this script instead of the hard-coded value of "Bob?"  Again, I'm sure
this is a simple matter, but I'm new to this, and I'm very certain I'm
overlooking something.  Appreciate the help!

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Re: Reservation/Scheduling in ARS

2009-07-01 Thread Joseph Kasell
Everybody,

Appreciate the responses and ideas!  Thad Esser noted that this is
deceptively simple, and it is (d**n brain-lock on my part).  Now, off to
the lab with some different approaches to try.

Thank you!

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union




   
 "Kemes, Lisa" 
 To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion list   
 (ARSList)"Subject 
   
   
   
 07/01/2009 08:53  
 AM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




--_000_46CDC1E68702E54387E9EAEDC0A02CA207C2FF1993us194mx002tyc_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I have an On Call system that I created that checks to make sure when
someo=
ne adds a person to the schedule that it does not conflict with what's
alre=
ady out there.

I have them fill out Start Date and an End Date (these are Date/Time
Fields=
).  Have them click on submit that kicks of an active link Guide that
loops=
 through the table of the On Call Schedule.

The first AL in the ALG sets the column Start Date and column End Date
fiel=
ds to temporary fields (from the on call schedule table) (tmp_StartDate
and=
 tmp_EndDate)

Then the second AL in the ALG simply makes sure that the Start Date and
End=
 Date fields do not over lap ( 'Start Date' < 'tmp_EndDate') AND ( 'End
Dat=
e' > 'tmp_StartDate')

If they do, I have a tmp_answer field that says "Allow" or "Not Allow"

The third AL in the ALG checks to see if that field (tmp_answer) equals
"No=
t Allow"   if at any time it does say "Not Allow" then an error message
pop=
s up and the ALG is exited.

Hope this helps


Lisa




From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslis=
T.ORG] On Behalf Of Joe DeSouza
Sent: Tuesday, June 30, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Reservation/Scheduling in ARS

**
Joseph,

I had done something similar once. Its not that hard. For something like a
=
reservation system you always invariably have an entity that you need to
re=
serve, be it a room, a car, a seat in an aircraft or a bus, whatever, for
a=
 blocked period of time during which no one should be allowed to be able
to=
 access it.

You need to check against both this entity and the start and end time
that=
 these do not clash with any combination of start and end time for the
same=
 entity.

You also might want to design a wait list or a preferential queue, for
cust=
omers requesting for the same entity, when it has already been booked in
th=
e event of a cancelation. And have this queue adjusted as and when they
adj=
ust their itenery, or the end date has passed whichever happens earlier.

Joe

From: Joseph Kasell 
To: arslist@ARSLIST.ORG
Sent: Tuesday, June 30, 2009 2:35:17 PM
Subject: Reservation/Scheduling in ARS

Hello!

I wanted to canvass the group for ideas on the following scenario.

One of our users is wanting to set up a scheduling/reservation system in
Re=
medy for an application he manages, which has a finite number of accounts.
=
 What he'd like is a means for a user to sign up for account access to the
=
app by blocking out a period of time.  Should another person sign up for
th=
at account during that time block, he/she would get a popup indicating a
co=
nflict.  I'm wondering if somebody out there has designed something which
a=
ccomplishes this.  Also, I don't have the funds to purchase a third-party
s=
olution, so that's out (things being what they are, our belts are tight
her=
e as well).  We're using ARS 7.0.01 and ITSM 6.
Appreciate the h

Reservation/Scheduling in ARS

2009-06-30 Thread Joseph Kasell
Hello!

I wanted to canvass the group for ideas on the following scenario.

One of our users is wanting to set up a scheduling/reservation system in
Remedy for an application he manages, which has a finite number of
accounts.  What he'd like is a means for a user to sign up for account
access to the app by blocking out a period of time.  Should another person
sign up for that account during that time block, he/she would get a popup
indicating a conflict.  I'm wondering if somebody out there has designed
something which accomplishes this.  Also, I don't have the funds to
purchase a third-party solution, so that's out (things being what they are,
our belts are tight here as well).  We're using ARS 7.0.01 and ITSM 6.
Appreciate the help!

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Re: Remedy and Mouse Scrollwheel Question

2009-04-16 Thread Joseph Kasell
Thank you David.  Currently, we're still wedded to the desktop client, but
I can see a day in the future where accessing Remedy via the web client
will become the standard.  It's not my decision, but I can certainly
encourage that approach.

Thank you again, everybody!

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union




   
 "Easter, David"   
   To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion list   
 (ARSList)"Subject 
   Question
   
   
 04/16/2009 03:33  
 PM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




BTW, the web client enables the use of the mouse wheel in both the Results
=
list and the Details pane.  If it's an option, you could encourage your
use=
r base to use the web client if they require this functionality.
=20
=20
-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.
=20
The opinions, statements, and/or suggested courses of action expressed in
t=
his E-mail do not necessarily reflect those of BMC Software, Inc.  My
volun=
tary participation in this forum is not intended to convey a role as a
spok=
esperson, liaison or public relations representative for BMC Software, Inc.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslis=
T.ORG] On Behalf Of Joseph Kasell
Sent: Thursday, April 16, 2009 12:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy and Mouse Scrollwheel Question

Fred,

Appreciate the response.  That makes a lot of sense.

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union




  =
=20
 "Grooms, =
=20
 Frederick W" =
=20
 arslist@ARSLIST.ORG=
=20
 Sent by: "Action   cc=
=20
 Request System   =
=20
 discussion list   Subject=
=20
 (ARSList)"Re: Remedy and Mouse Scrollwheel   =
=20
  =
=20
  =
=20
  =
=20
 04/16/2009 03:04 =
=20
 PM   =
=20
  =
=20
  =
=20
 Please respond to=
=20
 arsl...@arslist.o=
=20
RG=
=20
  =
=20
  =
=20




The scroll wheel will scroll the Results List or a multi-line text field.
=
I think the issue is that when you are on the Details pane you are always
i=
n a field or have object active (like a tab) and that is intercepting the
s=
croll command.=3D20

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslis=
T.ORG] On Behalf Of Joseph Kasell
Sent: Thursday, April 16, 2009 1:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy and Mouse Scrollwheel Question

Doug,

That's exactly what I'm saying.

I'm

Re: Remedy and Mouse Scrollwheel Question

2009-04-16 Thread Joseph Kasell
Fred,

Appreciate the response.  That makes a lot of sense.

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union




   
 "Grooms,  
 Frederick W"  
 arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussion list   Subject 
 (ARSList)"Re: Remedy and Mouse Scrollwheel
   
   
   
 04/16/2009 03:04  
 PM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




The scroll wheel will scroll the Results List or a multi-line text
field.  I think the issue is that when you are on the Details pane you
are always in a field or have object active (like a tab) and that is
intercepting the scroll command.=20

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joseph Kasell
Sent: Thursday, April 16, 2009 1:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy and Mouse Scrollwheel Question

Doug,

That's exactly what I'm saying.

I'm very well aware of the page holders.  This situation has to do with
a
custom form built for one of our departments here which actually is a
user
agreement with "signature" blocks at the end.  Using page holders was
suggested but the customer wanted the agreement to be on one page, so to
speak.  They want to know why the mouse scrollwheel isn't working in the
user tool when this form appears.  What's curious is that if I were to
click down on the scrollwheel, the mouse pointer changes to a
double-arrow,
and I can move the mouse forward and back on the mousepad in order to
scroll up and down on the screen.  What would make that use of the
scrollwheel different in the user tool than the more common use that the
customer wants to see work?

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union

Have a Remedy issue or question?  Email your query to the
Remedy_Administrators mailbox in Notes.


-Original Message-
I believe he is just saying the mouse does not perform the vertical
scrolling of the form.
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L
Sent: Thursday, April 16, 2009 2:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy and Mouse Scrollwheel Question

Joel,

The form size is set by the view you see when you're looking at it in
the admin tool.  The user client assumes that whatever size your window
is is the size you want it to appear in the user client.  This is how
you make the little dialog boxes exactly the size you want them.

The flip side is that the largest the box can be is your screen size.
Remedy assumes anything outside the immediate window is supposed to be
hidden workflow.  To make your fields visible to your users, you'll have
to create a page holder and move your fields onto the tabs.  This is
also an excellent way to organize your fields.

Jennifer Meyer

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joseph Kasell
Sent: Thursday, April 16, 2009 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Remedy and Mouse Scrollwheel Question

Hello all!

I have a Remedy form that is long enough that one needs to scroll down
to
see the bottom.  I can easily use the scrollwheel of my mouse to scroll
up
and down while in the Admin Tool.  Why can't I do the same for that form
in
the User Tool?  We're running ARS 7.0.01 patch 001 on the server and
both
client tools are 7.0.01 patch 001 as well.

Appreciate the help!

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union

___

UNSUBSCRIBE or access ARSlist Archives at www.arslis

Re: Remedy and Mouse Scrollwheel Question

2009-04-16 Thread Joseph Kasell
Doug,

That's exactly what I'm saying.

I'm very well aware of the page holders.  This situation has to do with a
custom form built for one of our departments here which actually is a user
agreement with "signature" blocks at the end.  Using page holders was
suggested but the customer wanted the agreement to be on one page, so to
speak.  They want to know why the mouse scrollwheel isn't working in the
user tool when this form appears.  What's curious is that if I were to
click down on the scrollwheel, the mouse pointer changes to a double-arrow,
and I can move the mouse forward and back on the mousepad in order to
scroll up and down on the screen.  What would make that use of the
scrollwheel different in the user tool than the more common use that the
customer wants to see work?

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union

Have a Remedy issue or question?  Email your query to the
Remedy_Administrators mailbox in Notes.




   
 "Tanner, Doug"
To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion list   
 (ARSList)"Subject 
   Question
   
   
 04/16/2009 02:15  
 PM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




I believe he is just saying the mouse does not perform the vertical
scrolling of the form.
Doug

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L
Sent: Thursday, April 16, 2009 2:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy and Mouse Scrollwheel Question

Joel,

The form size is set by the view you see when you're looking at it in
the admin tool.  The user client assumes that whatever size your window
is is the size you want it to appear in the user client.  This is how
you make the little dialog boxes exactly the size you want them.

The flip side is that the largest the box can be is your screen size.
Remedy assumes anything outside the immediate window is supposed to be
hidden workflow.  To make your fields visible to your users, you'll have
to create a page holder and move your fields onto the tabs.  This is
also an excellent way to organize your fields.

Jennifer Meyer

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joseph Kasell
Sent: Thursday, April 16, 2009 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Remedy and Mouse Scrollwheel Question

Hello all!

I have a Remedy form that is long enough that one needs to scroll down
to
see the bottom.  I can easily use the scrollwheel of my mouse to scroll
up
and down while in the Admin Tool.  Why can't I do the same for that form
in
the User Tool?  We're running ARS 7.0.01 patch 001 on the server and
both
client tools are 7.0.01 patch 001 as well.

Appreciate the help!

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"


DISCLAIMER Important! This message is intended for the above named person
(s=
) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended
rec=
ipient of this e-mail and have received it in error, please immediately
not=
ify the sender by return email and then delete it from your mailbox. This
m=
essage may be protected by the attorney-client privilege and/or work
produc=
t doctrine.  Accessing, copyi

Remedy and Mouse Scrollwheel Question

2009-04-16 Thread Joseph Kasell
Hello all!

I have a Remedy form that is long enough that one needs to scroll down to
see the bottom.  I can easily use the scrollwheel of my mouse to scroll up
and down while in the Admin Tool.  Why can't I do the same for that form in
the User Tool?  We're running ARS 7.0.01 patch 001 on the server and both
client tools are 7.0.01 patch 001 as well.

Appreciate the help!

Joe Kasell
Senior Systems Engineer
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


Re: Upgrading to SQL 2005

2009-04-07 Thread Joseph Kasell
Rafael,

We're going through the same process now.  We recently upgraded our
development and test servers w/o issue, and plan to do the same on
production late this month.  No reinstall of the ARSystem is needed.  Like
anything else, it is strongly advised to perform a complete backup of your
system in the event something goes wrong.  And if you can perform the
upgrade in a lab environment, this will give you a good idea of how long
your outage time will be.  Based on what we've seen, we're budgeting about
a two-hour outage of our production server.  Your mileage may vary.

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union




   
 "Rodriguez,   
 Rafael J x23718"  
   arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussion list   Subject 
 (ARSList)"Re: Upgrading to SQL 2005   
   
   
   
 04/06/2009 06:23  
 PM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




This is a multi-part message in MIME format.

--_=_NextPart_001_01C9B706.5E70670E
Content-Type: multipart/alternative;
 boundary="_=_NextPart_002_01C9B706.5E70670E"


--_=_NextPart_002_01C9B706.5E70670E
Content-Type: text/plain;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Thanks, I did not think so either but just wanted to see if anyone had
any issues after upgrading.



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Monday, April 06, 2009 9:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Upgrading to SQL 2005


**=20
Rafael,
We are actually undergoing that upgrade at the moment without issue.
Remedy doesn't seem to notice a change at all...



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718
Sent: Saturday, April 04, 2009 9:27 AM
To: arslist@ARSLIST.ORG
Subject: Upgrading to SQL 2005


**=20
Hello, just wanted to see if any has encountered any issues upgrading
the backend SQL server from SQL 2000 to SQL 2005?
=20
My environment is:
ARS 7.0.1 Patch 6 in a server group environment.
WIN 2003 Server
Remote SQL 2000 Clustered Servers
=20
Also, does remedy need to be re-installed after the upgrade?
=20
Thanks in advance!
=20

Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial
Solutions

2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p

=20
=20
This message and any attachments are intended only for the use of the
addressee and
may contain information that is privileged and confidential. If the
reader of the=20
message is not the intended recipient or an authorized representative of
the
intended recipient, you are hereby notified that any dissemination of
this
communication is strictly prohibited. If you have received this
communication in
error, please notify us immediately by e-mail and delete the message and
any
attachments from your system.


__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
html___=20

This message and any attachments are intended only for the use of the add=
ressee and
may contain information that is privileged and confidential. If the reade=
r of the =

message is not the intended recipient or an authorized representative of =
the
intended recipient, you are hereby notified that any dissemination of thi=
s
communication is strictly prohibited. If you have received this communica=
tion in
error, please notify us immediately by e-mail and delete the message and =
any
attachments from your system.
=0D

___

Re: Popup Broadcast Messages

2009-03-23 Thread Joseph Kasell
Fred,

You're absolutely right.

I should restate...

Alert is installed along with the user tool and is located in the
c:\program files\AR System\User directory, and we could launch it easily.
However, the policy decision was made to not utilize it at the desktop
level.  In fact, the Prism package that we use that deploys Remedy to the
desktops here does not include the Alert tool as an item under
Start>Programs>etc in Windows.  This is the hand I have to work with.

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union


Have a Remedy issue or question?  Email your query to the
Remedy_Administrators mailbox in Notes.




   
 "Grooms,  
 Frederick W"  
 arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussion list   Subject 
 (ARSList)"Re: Popup Broadcast Messages
   
   
   
 03/23/2009 09:01  
 AM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




Since it is installed as part of the User tool it is already there

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joseph Kasell
Sent: Monday, March 23, 2009 7:10 AM
To: arslist@ARSLIST.ORG
Subject: Re: Popup Broadcast Messages

Fred,

You're you're preaching to the choir, but the decision was made years
ago
(and before I came on board here) not to have the alert tool installed
on
the desktops.  I don't see that changing any time soon.

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union

Have a Remedy issue or question?  Email your query to the
Remedy_Administrators mailbox in Notes.




=20

 "Grooms,

 Frederick W"

 arslist@ARSLIST.ORG

 Sent by: "Action
cc=20
 Request System

 discussion list
Subject=20
 (ARSList)"Re: Popup Broadcast Messages

 

=20

=20

 03/20/2009 07:23

 PM

=20

=20

 Please respond to

 arsl...@arslist.o

RG

=20

=20





This is a multi-part message in MIME format.

--_=3D_NextPart_001_01C9A9B2.DAB0D3F5
Content-Type: text/plain;
 charset=3D"us-ascii"
Content-Transfer-Encoding: quoted-printable

Actually ... Wouldn't this just be the Alert Tool?

=3D20

All you have to do is to push to the Alert Events form the message for
each user.  Each user can set up the Alert Tool to pop up or display a
flashing cursor or play a sound.

=3D20

Fred

=3D20

=3D20

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Tony Worthington
Sent: Friday, March 20, 2009 8:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Popup Broadcast Messages

=3D20

** Think global field, active link on interval...




From:=3D20

Joseph Kasell =3D20

To:=3D20

arsl...@arslist.org=3d20

Date:=3D20

03/20/2009 07:38 AM=3D20

Subject:=3D20

Popup Broadcast Messages=3D20

Sent by:=3D20

"Action Request System discussion list(ARSList)" 

=3D20






Good morning everybody!

We're running ITSM 6 on an ARS 7.0.01 server.

I having a brainlock this morning thinking about this issue and am
wondering if this is something which is a lot simpler than what I'm
thinking it should be or if I'm missing the obvious.

Management here would like to have the ability to have a broadcast popup
message be sent to Remedy users to inform them of important activities,
changes in procedures, etc.  The message and the users who are the
target
of the message would change as appropriate and as circumstances dictate.

We currently are using emails for al

Re: Popup Broadcast Messages

2009-03-23 Thread Joseph Kasell
Fred,

You're you're preaching to the choir, but the decision was made years ago
(and before I came on board here) not to have the alert tool installed on
the desktops.  I don't see that changing any time soon.

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union

Have a Remedy issue or question?  Email your query to the
Remedy_Administrators mailbox in Notes.




   
 "Grooms,  
 Frederick W"  
 arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussion list   Subject 
 (ARSList)"Re: Popup Broadcast Messages
   
   
   
 03/20/2009 07:23  
 PM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




This is a multi-part message in MIME format.

--_=_NextPart_001_01C9A9B2.DAB0D3F5
Content-Type: text/plain;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Actually ... Wouldn't this just be the Alert Tool?

=20

All you have to do is to push to the Alert Events form the message for
each user.  Each user can set up the Alert Tool to pop up or display a
flashing cursor or play a sound.

=20

Fred

=20

=20

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Tony Worthington
Sent: Friday, March 20, 2009 8:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Popup Broadcast Messages

=20

** Think global field, active link on interval...




From:=20

Joseph Kasell =20

To:=20

arsl...@arslist.org=20

Date:=20

03/20/2009 07:38 AM=20

Subject:=20

Popup Broadcast Messages=20

Sent by:=20

"Action Request System discussion list(ARSList)" 

=20






Good morning everybody!

We're running ITSM 6 on an ARS 7.0.01 server.

I having a brainlock this morning thinking about this issue and am
wondering if this is something which is a lot simpler than what I'm
thinking it should be or if I'm missing the obvious.

Management here would like to have the ability to have a broadcast popup
message be sent to Remedy users to inform them of important activities,
changes in procedures, etc.  The message and the users who are the
target
of the message would change as appropriate and as circumstances dictate.

We currently are using emails for all notifications from Remedy.
However,
for this instance, I am asked to see if this can be done without the
need
to use email since they want to avoid users needing to constantly scan
their mail in the event they want a message sent out.

They also would like the user to click a button on the message to
acknowledge receipt of the message.

I'm thinking, OK, have a display-only form appear with a field to hold
the
message and a button with an active link to perform a close and
acknowledgement of receipt.  I'm trying to figure out how to get that
form
to appear on user A's screen while he is in Remedy whenever user B
decides
that there is a need to compose and broadcast such a message.

I know there is the bulletin board in ITSM 6, but it requires active
scanning on the part of the user.  We're looking for a popup.

Appreciate the help.

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union




=20


___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

--_=_NextPart_001_01C9A9B2.DAB0D3F5
Content-Type: text/html;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

**
http://schemas.microsoft.com/office/2004/12/omml"; =
xmlns=3D"http://www.w3.org/TR/REC-html40";>






<!--
 /* Font Definitions */
 @font-face

Popup Broadcast Messages

2009-03-20 Thread Joseph Kasell
Good morning everybody!

We're running ITSM 6 on an ARS 7.0.01 server.

I having a brainlock this morning thinking about this issue and am
wondering if this is something which is a lot simpler than what I'm
thinking it should be or if I'm missing the obvious.

Management here would like to have the ability to have a broadcast popup
message be sent to Remedy users to inform them of important activities,
changes in procedures, etc.  The message and the users who are the target
of the message would change as appropriate and as circumstances dictate.

We currently are using emails for all notifications from Remedy.  However,
for this instance, I am asked to see if this can be done without the need
to use email since they want to avoid users needing to constantly scan
their mail in the event they want a message sent out.

They also would like the user to click a button on the message to
acknowledge receipt of the message.

I'm thinking, OK, have a display-only form appear with a field to hold the
message and a button with an active link to perform a close and
acknowledgement of receipt.  I'm trying to figure out how to get that form
to appear on user A's screen while he is in Remedy whenever user B decides
that there is a need to compose and broadcast such a message.

I know there is the bulletin board in ITSM 6, but it requires active
scanning on the part of the user.  We're looking for a popup.

Appreciate the help.

Joe

Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"


Re: Mid-Tier Question - Passing Values

2009-01-15 Thread Joseph Kasell
Fred,

Appreciate the response.

But that's what I'm trying to determine: how DO you pass the catalog text
to that field if you don't hard code that particular text in the URL?  I
just want to have one universal URL to deal with which is used by all the
links but which accepts whatever service catalog text that needs to be
passed.

Joseph Kasell
Navy Federal Credit Union


Have a Remedy issue or question?  Email your query to the
Remedy_Administrators mailbox in Notes.




   
 "Grooms,  
 Frederick W"  
 arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussion list   Subject 
 (ARSList)"Re: Mid-Tier Question - Passing 
   
   
   
 01/15/2009 09:41  
 AM
   
   
 Please respond to 
 arsl...@arslist.o 
RG 
   
   




Sure... You could pass the catalog text into a field on the Mid-Tier and
then have an AL that runs on Window Loaded do a lookup in a back end
translation form to fill in the fields you want. =20

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joseph Kasell
Sent: Thursday, January 15, 2009 8:13 AM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier Question - Passing Values

Good morning listers!

Here's my situation.  A web-based service catalog is going to be
implemented in the next few weeks here at work.  It will have a laundry
list of links (i.e. - I need a phone, I need new software installed, I
need
a new monitor, etc.)  The goal is that when a link is clicked, it will
launch a mid-tier browser in a custom form I've developed that will have
certain fields pre-filled and one or two others where the end user can
free-type text.

I used the ability of using the Mid-Tier URL to pass data to one of the
pre-filled fields on that form.  This field is the one that contains the
name of the request as presented in the service catalog.  Here's an
example:

http:///arsys/forms//NFCUTestWeb?F536870913=3DI%20need%20a%20phone

This works beautifully.  However, I am thinking ahead about the other
requests we have now and the need to encode a new URL for each and any
for
the future (in other words, field id 536870913 would need to say "I need
new software installed" or "I need a new monitor")  Not that hard to do
but
it could be an admin headache.

My question is this: instead of having a hard-coded URL for each service
catalog request, is there any way to build a "generic" URL so that the
text
in that service catalog link is passed to that field I referenced ?

We're running Mid-Tier 7.0.01 patch 001.  The service catalog page is
external to our mid-tier server.

Appreciate the help.

Joseph Kasell
Navy Federal Credit Union

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"


Mid-Tier Question - Passing Values

2009-01-15 Thread Joseph Kasell
Good morning listers!

Here's my situation.  A web-based service catalog is going to be
implemented in the next few weeks here at work.  It will have a laundry
list of links (i.e. - I need a phone, I need new software installed, I need
a new monitor, etc.)  The goal is that when a link is clicked, it will
launch a mid-tier browser in a custom form I've developed that will have
certain fields pre-filled and one or two others where the end user can
free-type text.

I used the ability of using the Mid-Tier URL to pass data to one of the
pre-filled fields on that form.  This field is the one that contains the
name of the request as presented in the service catalog.  Here's an
example:

http:///arsys/forms//NFCUTestWeb?F536870913=I%20need%20a%20phone

This works beautifully.  However, I am thinking ahead about the other
requests we have now and the need to encode a new URL for each and any for
the future (in other words, field id 536870913 would need to say "I need
new software installed" or "I need a new monitor")  Not that hard to do but
it could be an admin headache.

My question is this: instead of having a hard-coded URL for each service
catalog request, is there any way to build a "generic" URL so that the text
in that service catalog link is passed to that field I referenced ?

We're running Mid-Tier 7.0.01 patch 001.  The service catalog page is
external to our mid-tier server.

Appreciate the help.

Joseph Kasell
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"


Re: OT: BBQ tour

2008-06-16 Thread Joseph Kasell
Rick,

I'm a native of Goldsboro, NC (not too far from Wilson) and can recommend
Parker's as well.  Like David says, pork IS the only real BBQ.

You could also travel the 20 or so miles to Goldsboro and try Wilbur's BBQ
on Highway 70 near Seymour Johnson AFB.  Keep a look out for low-flying
planes since it's not too far from the end of the runway!

Congrats to your son!

Joe

Joseph Kasell
Network Management Integrator
Global Telcom Services
Navy Federal Credit Union



   
 "David.M Clark"   
 <[EMAIL PROTECTED] 
 ATE.TN.US> To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: OT: BBQ tour
 ORG>  
   
   
 06/13/2008 02:20  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




Since you're going to drive all the way over to North Carolina (which you =
of course just HAVE to do if you're on a legitimate barbecue tour), I =
recommend Bob Melton's BBQ in Rocky Mount... although I'm not sure that =
they rebuilt since one of the hurricanes flooded them out.  If that place =
is gone, you'll have to make do with Jim Gardner's BBQ on Hwy 301 where =
that town is concerned.  Since you're on Hwy 301 in Rocky Mount anyway, =
drive twenty miles or so south to Wilson, NC for Parker's BBQ. Order =
"family style".  Highly recommended, and there hasn't been a President =
through there in years who hasn't stopped to eat.  (The Secret Service =
agents leave with bags of takeout.)  You can't go wrong with any of those =
three, so long as you realize that pork BBQ is the only REAL BBQ... a fact
=
no one will tell you until you get past Louisiana.  Have fun on the trip.

-D

P.S.  Since you're that close, you might as well get over to Nags Head for
=
the beach.

David M Clark
Remedy Programmer/Analyst


>>> Rick Cook <[EMAIL PROTECTED]> 6/13/2008 10:46 AM >>>
My son just graduated from HS, and will leave for the Marines in October.
Sometime between now and then, he and I are going to drive cross-country =
on
a BBQ tour.  We'll start and end in Seattle, but we intend to hit all of =
the
areas of the country famous for BBQ:  Texas, Louisiana, the rest of the
South, North Carolina, Memphis, Chicago, and Kansas City.

We're still planning the specifics, and here's where all y'all come in:

I would love to know THE places to go in your part of the country =
(assuming
it's one I mentioned above - this will be almost entirely SOUTH of the
Mason-Dixon line) for outstanding BBQ, whether they're famous or a
hole-in-the-wall.  We'll stay away from big chains for the most part (we
have Famous Dave's up here), unless it is a local/regional one with a good
local reputation.

Thanks in advance for sharing!

Rick

___=


UNSUBSCRIBE or access ARSlist Archives at www.arslist.org=20
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Flashboards Question

2008-05-07 Thread Joseph Kasell
Good morning listers!

First off, thank you to those who responded to my question a couple of
weeks ago regarding CTI management.  Your input was very helpful.

Secondly, I have a Flashboards question which probably has an easy answer
which I am overlooking.  The environment here is:

ARS 7.0.1, Patch 001
Flashboards 7.0.1
ITSM 6
OS: Windows 2003
DB: MSSQL 2000

On the Remedy Support form in the ITSM suite there are several flashboards
located on the lower right-hand side.  Of particular interest here is the
flashboard displaying cases by category.  Management here is asking if that
flashboard can display cases by Item (easily done by modifying the OOB
flashboard variable by changing the Group By from "Category" to "Item").
The issue is that by doing so, with all the Items that we have defined,
there would be many bars in the bar graph for each Item, making the
flashboard useless.  Is there any way that this could be limited to the top
10 Items in use rather than all Items in use?  I can do a SQL query which
will provide that answer but translating that to a custom flashboard is
proving to be difficult, and the powers-that-be here are looking for the
graphical representation.  I'm curious if I am missing something obvious.
Appreciate the help.

Joe

Joseph Kasell
Network Management Integrator
Global Telcom Services
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Re: CTI Management Question

2008-04-23 Thread Joseph Kasell
Rick,

We're using ITSM 6.

I like your phrase "where the theoretical meets the practical..."  There is
obviously a fine line, or tipping point, that needs to be found to balance
those two concepts.

Joe

Joseph Kasell
Network Management Integrator
Global Telcom Services
Navy Federal Credit Union
12851 Worldgate Drive, 7th Floor
Herndon, Virginia  20170



   
 Rick Cook 
 <[EMAIL PROTECTED] 
 .COM>  To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: CTI Management Question 
 ORG>  
   
   
 04/23/2008 02:42  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




--=_Part_17655_31672132.1208976163570
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Joseph, CTIs are the main place where the theoretical meets the practical
in
a Remedy application.  Can you tell us what version of Help Desk/ITSM you
are using?  It makes a big difference in terms of what you are practically
able to accomplish.

Rick

On Wed, Apr 23, 2008 at 11:35 AM, Joseph Kasell <
[EMAIL PROTECTED]> wrote:

> I don't know if this has been discussed previously but I wanted to find
> out
> how others on this board approached the management of CTI's.  In our Help
> Desk application alone, we have 811 defined CTI's.  To me that seems
likes
> a lot but it's relative and another organization may not think of that
> number as too high.  I know that it has gotten this way because of quick
> replies to requests like "we need a CTI for this" or "we need a CTI for
> that", all of which are arising from a metrics requirements.  I know also
> that as this number has increased, it becomes very easy from a
> front-line-support standpoint to get lost when attempting to classify a
> ticket with the appropriate CTI, or from an administrative standpoint
with
> respect to seeing that the need driving a new CTI may already be answered
> by an existing CTI.
>
> I spoke to Support on this and they really had no resource they could
> point
> me to for guidance.  They did say that the software should have no
> problems
> handling a large number of CTI's.  I've heard of a rule of thumb where
you
> shouldn't have more than 10 Categories, 10 Types for each Category, and
10
> Items for each Type, which seems like a good starting point.  I just
would
> like to get ideas from others out there as to how they handle this.
>
> I appreciate the help.
>
> Joe
>
> Joseph Kasell
> Network Management Integrator
> Global Telcom Services
> Navy Federal Credit Union
> 12851 Worldgate Drive, 7th Floor
> Herndon, Virginia  20170
>
>
>
___

> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

--=_Part_17655_31672132.1208976163570
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

**
Joseph, CTIs are the main place where the theoretical meets the practical
in a Remedy application.  Can you tell us what version of Help
Desk/ITSM you are using?  It makes a big difference in terms of what
you are practically able t

CTI Management Question

2008-04-23 Thread Joseph Kasell
I don't know if this has been discussed previously but I wanted to find out
how others on this board approached the management of CTI's.  In our Help
Desk application alone, we have 811 defined CTI's.  To me that seems likes
a lot but it's relative and another organization may not think of that
number as too high.  I know that it has gotten this way because of quick
replies to requests like "we need a CTI for this" or "we need a CTI for
that", all of which are arising from a metrics requirements.  I know also
that as this number has increased, it becomes very easy from a
front-line-support standpoint to get lost when attempting to classify a
ticket with the appropriate CTI, or from an administrative standpoint with
respect to seeing that the need driving a new CTI may already be answered
by an existing CTI.

I spoke to Support on this and they really had no resource they could point
me to for guidance.  They did say that the software should have no problems
handling a large number of CTI's.  I've heard of a rule of thumb where you
shouldn't have more than 10 Categories, 10 Types for each Category, and 10
Items for each Type, which seems like a good starting point.  I just would
like to get ideas from others out there as to how they handle this.

I appreciate the help.

Joe

Joseph Kasell
Network Management Integrator
Global Telcom Services
Navy Federal Credit Union
12851 Worldgate Drive, 7th Floor
Herndon, Virginia  20170

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


Re: BMC Remedy - Copy to Archive and Delete from Source

2008-03-26 Thread Joseph Kasell
Thad,

You bring up an excellent point regarding tables.  Case in point in the
Requester's Cases table under the Requester Information tab on the Help
Desk form.  Along with tickets reported by end-users we also have tickets
generated from Patrol, and all those tickets have the same Requester.
Needless to say there are a lot more of those tickets than those called-in
by our regular (i.e. - "human") users.  So when a ticket for that
particular Requester is opened from the Support Console, there is quite the
lag due to the query used to populate the Requester's Cases table.  The
client SQL and API logs were a real eye-opener insofar as that was
concerned.

Joe

Joseph Kasell
Navy Federal Credit Union




   
 Thad K Esser  
 <[EMAIL PROTECTED] 
 COM>   To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
 ORG>  and Delete from Source  
   
   
 03/26/2008 02:42  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




This is a multipart message in MIME format.
--=_alternative 0066B95B88257418_=
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: 7bit

Joe,

Properly indexed and tuned 400,000 tickets on a form shouldn't be a
problem.  To expand on what Susan indicated, nine times out of ten, the
biggest cause of slowness when opening forms is table fields that are
needlessly being refreshed.  Watch out for tables being refreshed on
hidden tabs.  Have an active link that fires on Gain Focus (of that tab)
AND also on Display, with a run if of ('Page Holder' = "Tab Name').  The
one action would be the table refresh.

Of course there are other causes for slowness on opening of forms, but
I've found this is the most common, and typically the easiest to fix. (oh,
and be suspect of any active link that fires on all three of Window Open,
Window Loaded, and Display - its probably running three times when you
display a ticket).

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach



"Susan Palmer" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"

03/26/2008 08:27 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: BMC Remedy - Copy to Archive and Delete from Source






**
Mel,

I have found that for 'us' keeping less than 100k Help Tickets or Tasks in
those forms keeps performance at an acceptable level.  You have to
remember that all workflow is affected by the number of records in the
form and keep in mind any table fields that are refreshed.

We generally keep 13 months of or closed records.

Since we upgraded to v7.0.1P3 last year I was excited about the 'archive'
option.  In the last month I've used it on HTs, Tasks and email messages.
For us it appears to require a huge amount of disk space for the
copy/delete option.  That needs to be planned for and it was greater than
1 for 1 which is logical since another table is now holding the same
record.  For us it was quite a bit more than that infact we nearly brought
the server down.

I only archive in the lowest of production hours (night) when minimal
users are on the system.

I was also notified yesterday that it is not recommended to archive system
email messages, there is some unusal result related to it.  Sorry did not
get more info.

I found the actual archiving to go fairly quick, was doing about 70k
records both times.  I liked the fact I didn't have to manually delete the
records afterwards.

hth,
Susan

ShopperTrak

On Wed, 

Re: BMC Remedy - Copy to Archive and Delete from Source

2008-03-26 Thread Joseph Kasell
Mel,

We didn't measure that specifically before and after archiving, but our
users are telling us that the response for that activity is better.

Joe

Joseph Kasell
Navy Federal Credit Union



   
 Melanie Snayer
 <[EMAIL PROTECTED] 
 MAIL.COM>  To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
 ORG>  and Delete from Source  
   
   
 03/26/2008 09:28  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




--=_Part_7293_11795538.1206538125823
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Joe

Thanks so much for this information. Would you perhaps be able to tell me
whether there was a delay on saving Help Desk tickets before you archived?

Regards
Mel


On 3/26/08, Joseph Kasell <[EMAIL PROTECTED]> wrote:
>
> Mel,
>
> We're running 7.0.1 with ITSM 6.  We instituted archiving a little over a
> month ago, it was sorely needed, and it certainly has made a difference.
> Since Remedy was put into production back in the summer of 2004, approx
> 390,000 tickets had been submitted.  The amount of tickets had not been a
> problem until recently when we began to see performance lags performing
> various actions in Remedy.  Opening an existing Help Desk ticket from the
> Remedy Support console alone was taking anywhere from 1 to 5 seconds
> depending on the ticket (API and SQL logs were very helpful here).
>
> We decided to archive all Help Desk tickets with a status of Closed that
> were older than 13 months.  We considered using Remedy's archiving
> feature,
> but eventually went with Misi Mladoniczky's rrrchive utility.  Since our
> lab testing indicated that the archiving of an estimated 250,000 tickets
> would take about 6 to 7 hours (and slow the system down tremendously), we
> decided to archive in chunks of 40,000 which limited the performance pain
> to about an hour.  We did this for 7 nights in a row.  I can tell you
that
> since, performance has improved tremendously (max time to open an
existing
> ticket is about a second).  Archiving is done nightly now.  It takes a
> minute to archive the 400 to 500 tickets that meet the archive
> criteria.  I
> know that my users are happy.
>
> Joe
>
> Joseph Kasell
> Navy Federal Credit Union
>
>
>
>
> Melanie Snayer
> <[EMAIL PROTECTED]
> MAIL.COM>  To
> Sent by: "Action  arslist@ARSLIST.ORG
> Request System cc
> discussion
> list(ARSList)"Subject
> <[EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
> ORG>  and Delete from Source
>
>
> 03/26/2008 05:45
> AM
>
>
> Please respond to
> [EMAIL PROTECTED]
>RG
>
>
>
>
>
>
> --=_Part_6872_1105761.1206524742321
> Content-Type: text/plain; charset=WINDOWS-1252
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: inline
>
> Hey Thivagar
>
> We are in a 7.01 environment but I'm glad to know that this improved on
> performance. Could you perhaps give me a rough indication of the
> following information:
>
>   - what your database size is
>   - number of re

Re: BMC Remedy - Copy to Archive and Delete from Source

2008-03-26 Thread Joseph Kasell
Mel,

We're running 7.0.1 with ITSM 6.  We instituted archiving a little over a
month ago, it was sorely needed, and it certainly has made a difference.
Since Remedy was put into production back in the summer of 2004, approx
390,000 tickets had been submitted.  The amount of tickets had not been a
problem until recently when we began to see performance lags performing
various actions in Remedy.  Opening an existing Help Desk ticket from the
Remedy Support console alone was taking anywhere from 1 to 5 seconds
depending on the ticket (API and SQL logs were very helpful here).

We decided to archive all Help Desk tickets with a status of Closed that
were older than 13 months.  We considered using Remedy's archiving feature,
but eventually went with Misi Mladoniczky's rrrchive utility.  Since our
lab testing indicated that the archiving of an estimated 250,000 tickets
would take about 6 to 7 hours (and slow the system down tremendously), we
decided to archive in chunks of 40,000 which limited the performance pain
to about an hour.  We did this for 7 nights in a row.  I can tell you that
since, performance has improved tremendously (max time to open an existing
ticket is about a second).  Archiving is done nightly now.  It takes a
minute to archive the 400 to 500 tickets that meet the archive criteria.  I
know that my users are happy.

Joe

Joseph Kasell
Navy Federal Credit Union



   
 Melanie Snayer
 <[EMAIL PROTECTED] 
 MAIL.COM>  To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
 ORG>  and Delete from Source  
   
   
 03/26/2008 05:45  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




--=_Part_6872_1105761.1206524742321
Content-Type: text/plain; charset=WINDOWS-1252
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hey Thivagar

We are in a 7.01 environment but I'm glad to know that this improved on
performance. Could you perhaps give me a rough indication of the
following information:

   - what your database size is
   - number of records before the archive
   - time taken to save a call before the archive
   - number of records after the archive
   - time taken to save a call after the archive

Anyone else like to share a bit of their archiving info with me?

Regards
Mel

On 3/26/08, Thivagar Sankaran <[EMAIL PROTECTED]> wrote:

> **
>
> Hi Mel,
>
>
>
> Recently I have archived the data in my 6.3 environment. I have done this
> to improve the performance and I observe the performance has been
improve=
d
> considerably. But the issue was, the Copy to Archive and Delete from
> Source option was not working in my environment. Hence I went for Copy to
> Archive Option and deleted the data manually. I have raised this issue
wi=
th
> BMC. But as usual I didn't get a proper response.
>
>
>
> Thanks & Regards,
>
> Thivagar Sankaran
>
> ITIL =96 Foundataion Certified
>
> Remedy Developer
>
>
>  --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer
> *Sent:* Wednesday, March 26, 2008 2:44 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* BMC Remedy - Copy to Archive and Delete from Source
>
>
>
> **
>
> Hi Listeners
>
>
>
> We're experiencing performance issues especially when submitting
> incidents. Our initial plan was to archive calls that have been closed
fo=
r
> more than 5 years but as a result of the performance issues we're having
=
t

Re: Status History....

2007-11-20 Thread Joseph Kasell
I had a similar issue a few weeks ago while developing an escalation.
There was a discussion about this on this board which referenced an
arswiki.org entry.  Bottom line is that I downloaded and installed 7.0.01
patch 5 of the Admin Tool.  The issue cleared up and haven't had a problem
since.

Joseph Kasell
Network Management Integrator
Global Telcom Services
Navy Federal Credit Union




   
 "Kemes, Lisa" 
 <[EMAIL PROTECTED] 
 LECTRONICS.COM>To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: Status History  
 ORG>  
   
   
 11/20/2007 02:52  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




This is a multi-part message in MIME format.

--_=_NextPart_001_01C82BAE.D37F3686
Content-Type: text/plain;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I finally found it.  The status on this defect is "non reproducible" =20
=20
I'll reproduce it for them!!
=20
Lisa



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, November 20, 2007 2:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Status History


**=20
Why am I not able to search on a defect number on the BMC website?




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, November 20, 2007 2:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Status History


**=20
I see that there is a documented bug on this one: SW00260084=20



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, November 20, 2007 2:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Status History


**=20
My environment is:
=20
AR Server Windows 2003 7.0.1 Patch 3
User Tool 7.0.1 patch 3



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, November 20, 2007 2:26 PM
To: arslist@ARSLIST.ORG
Subject: Status History


**=20
I have a status field with "Active" "Inactive" and "Delete" attributes.
I would like to capture when the record was changed to Inactive on
another form.  I'm setting a character field to $Status
History.Inactive.TIME$ on a filter, but when I save the filter it
changes to $Status History.Active.TIME$.
=20
Does anyone know why this would be?
=20
Lisa
__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with
HTML in it___ __20060125___This posting was
submitted with HTML in it___ __20060125___This
posting was submitted with HTML in it___=20

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

--_=_NextPart_001_01C82BAE.D37F3686
Content-Type: text/html;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

**

Export Form Data to =
Excel on Button Action



I finally found it.  The status on this =
defect is "non=20
reproducible"  
 
I'll reproduce it for =
them!!
 
Lisa


From: Action Request System =
discussion=20
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes,=20
LisaSent: Tuesday, November 20, 2007 2:45 PMTo:=20
arslist@ARSLIST.ORGSubjec

Re: Transaction log is full.

2007-07-12 Thread Joseph Kasell
Also, when you truncate a transaction log, all this does is to remove
committed database transactions from that log.  It does not shrink the
physical size of the transaction log file.  That's where SHRINKFILE comes
in.

Here's a link to Microsoft's support site with more info
http://support.microsoft.com/kb/873235

Over a long course of time, if you are using Remedy with all the add-ons
you list, that transaction log can grow quite large.

Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union
820 Follin Lane
Vienna, Virginia  22180
703/206-2007


   
 Kaiser Norm E CIV 
 USAF 96 CS/SCCE   
 <[EMAIL PROTECTED]  To 
 N.AF.MIL> arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussionSubject 
 list(ARSList)"Re: Transaction log is full.
 <[EMAIL PROTECTED] 
 ORG>  
   
   
 07/12/2007 10:52  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




This is a multi-part message in MIME format.

--_=_NextPart_001_01C7C494.39F6FAB3
Content-Type: text/plain;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

If you don't have a good SQL maintenance plan in place, the transaction
log just grows and grows and grows over time.  The transaction log can
grow quite a bit if you run, say, an escalation or filter that modifies
1000s of records.  Then do that a few days a week, and in no time the
transaction log is huge.

=20



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of DJHuang
Sent: Thursday, July 12, 2007 9:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: Transaction log is full.

=20

** Hi,

   Regarding to this transaction log full issue, it is not how you
truncate the transaction log file but how the transaction log file=20
   got full that interests me. We have a v7 ARS server with IM, PM, CM,
SLM, CMDB, EIE for SQL installed.=20
   After about 6 months running, we hit the same situation. There are
about 2 incident tickets in the db and=20
  2000 contact information replicated/updated nightly. It end up with a
more than 100GB transaction log file. =20
   Does anyone know what kind of behavior would generate a log file so
large?
  Thank you.

DJHuang

2007/7/12, Broyles Robert K Mr CTR USAF 96 CS/SCCE <
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>:

Thanks Joe.  I went back and reread the SQL books online and say that my

syntax was wrong.  I didn't need to specify TRUNCATEONLY if I pass it a
file size.

Rob


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"


__20060125___This posting was submitted with HTML in
it___=20


___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

--_=_NextPart_001_01C7C494.39F6FAB3
Content-Type: text/html;
 charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

**
http://www.w3.org/TR/REC-html40";>







<!--
 /* Font Definitions */
 @font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal,
li.MsoNormal, div.MsoNormal
   {margin:0in;
  margin-bottom:.0001pt;
font-size:12.0pt;
 font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
  text-decoration:underline;}
a:visited,
span.MsoHyperlinkFollowed
 {color:blue;

Re: Transaction log is full.

2007-07-12 Thread Joseph Kasell
Welton,

We have a script that runs nightly on our database that contains the
following:

backup log ARSystem with truncate_only

dbcc shrinkfile(ARSystem_log)

This script follows our nightly database backup job.

HTH,

Joe

Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union



   
 Welton Bryant 
 <[EMAIL PROTECTED] 
 S-SHAREDSERVICES.  To 
 COM>  arslist@ARSLIST.ORG 
 Sent by: "Action   cc 
 Request System
 discussionSubject 
 list(ARSList)"Transaction log is full.
 <[EMAIL PROTECTED] 
 ORG>  
   
   
 07/12/2007 09:25  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




This is a multi-part message in MIME format.


--_=_NextPart_001_01C7C488.1F8D7B7B
Content-Type: text/plain;
 charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

=20
Hello,
=20
Can any SQL guru's tell me how to fix this? Thanks
=20
=20
The transaction log for database 'ARSystemdev' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc column in
sys.databases

=20
Welton Bryant MCSE,MCP=09
Sr. Business Applications Analyst=09
CareTech Solutions Inc.=09
248-823-0341 Office=09
313-408-5188 Cell=09
800-428-4781 Pager=09
[EMAIL PROTECTED] =09
www.caretechsolutions.com <http://www.caretechsolutions.com/> =09
=20

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

--_=_NextPart_001_01C7C488.1F8D7B7B
Content-Type: text/html;
 charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

**





 
Hello,
 
Can any SQL=20
guru's tell me how to fix this? Thanks
 
 
The=20
transaction log for database 'ARSystemdev' is full. To find out why =
space in the=20
log cannot be reused, see the log_reuse_wait_desc column in=20
sys.databases
 


  
  

  Welton Bryant=20
  MCSE,MCP
  

  Sr. Business=20
  Applications Analyst
  

  CareTech=20
  Solutions Inc.
  

  248-823-0341 Office
  

  313-408-5188 Cell
  

  800-428-4781=20
  Pager
  

  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]
aredservices.com=20
  
  

  http://www.caretechsolutions.com/";>www.caretechsolutions.com=20
  
 
__20060125___This posting was submitted with HTML in
it___

--_=_NextPart_001_01C7C488.1F8D7B7B--

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


Server Logging

2007-07-11 Thread Joseph Kasell
Hello listers,

I have a question which I cannot find an answer to.

One of the features touted in ARS version 7 is the ability to use workflow
to turn on and off logging on the server side.  But there's no
documentation on this that I can find.

On our test server I approached this issue in what I saw was the obvious
method: create an escalation that modified a record in the AR System
Administration: Server Information form.  That didn't work.  I haven't had
luck with support as I was referred to a KB article (KM-00010172) which
dates back to the version 5 days and which offers one of two solutions:
swapping ar.cfg files or using a utility called driver.  Maybe I'm wrong
but to me this KB doesn't address what I am asking.  Can anybody shed some
light on this?  I'm missing something.  Appreciate the help.

Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


Re: ARERR 9093

2007-06-26 Thread Joseph Kasell
Claire,

Your syntax is correct but that config option will suppress server warnings
and notes only (this from the Configuring AR System reference).  We use it
to suppress a warning message, which is great, but I guess errors are still
meant to get through.

HTH,

Joe

Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union



   
 Shawn Rosenberry  
 <[EMAIL PROTECTED] 
 IL.COM>To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: ARERR 9093  
 ORG>  
   
   
 06/26/2007 03:34  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




--=_Part_8496_21957072.1182886485047
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Claire,

Its been a while but shouldn't the entry read "Suppress-Error: 9093"?

Regards,

Shawn


On 6/26/07, Sanford, Claire <[EMAIL PROTECTED]> wrote:
>
> Is there any way to stop this from filling up my arerror.log ???
>
> 390620 : User is currently connected from another machine (ARERR 9093)
>
> I tried adding "Suppress-warnings: 9093" to my ar.cfg file, but it still
> happens.
>
> Thanks!
>
>
> ARS 6.3 Patch 18
> HD 6.0
> Oracle 10 w/9 libraries
> Oracle lives on a remote server
> Windows 2003 4 gig on app server and 8 gig on DB server
>
>
>
> Claire Sanford
> Information Systems Division
> Memorial Hermann Healthcare System
> Phone: 713 448 6035
> [EMAIL PROTECTED]
>
>
>
___

> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>

___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

--=_Part_8496_21957072.1182886485047
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

**
Claire,
Its been a while but shouldn't the entry
read "Suppress-Error: 9093"?
 
Regards,
 
Shawn 
On 6/26/07, Sanford, Claire <mailto:[EMAIL PROTECTED]
">[EMAIL PROTECTED]> wrote:
Is there any way to stop this from
filling up my arerror.log ???390620 : User is currently connected
from another machine (ARERR 9093)
I tried adding "Suppress-warnings: 9093" to my ar.cfg
file, but it stillhappens.Thanks!ARS 6.3 Patch
18HD 6.0Oracle 10 w/9 librariesOracle lives on a remote
server
Windows 2003 4 gig on app server and 8 gig on DB
serverClaire SanfordInformation Systems
DivisionMemorial Hermann Healthcare SystemPhone: 713 448 6035mailto:[EMAIL PROTECTED]">
[EMAIL 
PROTECTED]___UNSUBSCRIBE
 or access ARSlist Archives at http://www.arslist.org";>www.arslist.org
 ARSlist:"Where the Answers Are"
__20060125___This posting was submitted with HTML in
it___

--=_Part_8496_21957072.1182886485047--

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


Re: BMC Rant

2007-06-13 Thread Joseph Kasell
This isn't an ad either, but I echo the sentiments regarding Column
support.  I have been very happy with them from the start.  They are much
more responsive and helpful than what I saw coming out of BMC recently.
>From my conversations with the support staff, the attitude and feel I
received was more of working and listening to the customer to find a
solution rather than just to issue a canned answer or "send us your logs"
response.

We also have had some of their developers on-site for 1 to 2 month
projects.  They've been pretty solid and diligent in their work.

I haven't had training from them so I cannot comment.  I will say that a
class I took from BMC last year on the CMDB seemed to be straight from the
book with little additional info.  Then again, at the time there was
probably little anecdotal info from the field that could have been thrown
in to supplement the classroom instruction.  Can't say it was a waste of
time but I usually would leave Remedy training with more info than
expected.

Overall, we've been satisfied with Column.

Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union



   
 Dan Caissie   
 <[EMAIL PROTECTED] 
 M> To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: BMC Rant
 ORG>  
   
   
 06/13/2007 09:00  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




We use Column support and when I put a support request in I will get a
call the same day and most times if I call there support center I will
talk to someone right then and there. Now there have been times when I
did get a call back by someone that was not up to par and I did talk to
there support lead and he did note down my concerns and even one time he
jumped on a call to make sure everything went smoothly.

One time I was in training at there main office and our system had a
major problem and they were dealing with my backup that had very little
knowledge with Remedy but they worked with him and they let me go into
there support center during lunch to help out, they were on the call all
day long to correct the problem and with multiple people.

I have also worked with there onsite developers and they are great
people (Mario)
=20
I would have to agree partly with the training as it was for the most
part just out of the book and a few calls were made anytime there was a
question.

This is not an AD :)

Dan Caissie
UNFI


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Philip, Saji L
Sent: Tuesday, June 12, 2007 10:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Rant

Dave,

=20

Same situation here.  Went to a RUG meeting sponsored by
Column and it seemed it was mostly a sales pitch for SRM and Remedy 7.x.
Really no collaboration of sorts.  They should re-name it RPG( Remedy
Promotion Group ).  I guess, if the sponsor is a Column per se, then its
mostly a sales presentation.  Basically, it was a waste of time for me
as well. =20

=20

I feel that support is an abbreviated notion for these guys.
6 months back I submitted a couple of requests to our third-partyr
support line and to this day, I have not gotten any response, and we're
paying these guys.  Nice ' gig ' I thought.

=20

=20

=20

=20



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David
Sent: Tuesday, June 12, 2007 8:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Rant

=20

I know o

Re: Diary Field Issue

2007-06-08 Thread Joseph Kasell
Mike,

We had this happen the other day.  Turned out that the vertical size of
pop-up window containing the Diary Editor and Diary History fields was too
small...we could see the labels Diary Editor and Diary History, but that
was it.  Apparently the end-user reporting the problem somehow resized the
vertical settings of the window in a previous session to where both fields
"disappeared" and had the same problem you report in a subsequent session.
I can't see your screen shots but I'll bet that click-dragging with your
mouse to increase the vertical size of the pop-up will solve the problem.

Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union




   
 Bruce Scott   
 <[EMAIL PROTECTED] 
 ART.COM>   To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: Diary Field Issue   
 ORG>  
   
   
 06/08/2007 10:32  
 AM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




This is a multi-part message in MIME format.

--_=_NextPart_001_01C7A9D9.D7A0D903
Content-Type: text/plain;
 charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

I've seen things like this before where the .arf files have become
corrupt.  try deleting the *.arf and *.arv files from the system used
for the demonstration, especially if no one else is seeing that issue.
=20
Bruce
=20

=20 _ =20

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kendhammer, Mike
Sent: Friday, June 08, 2007 7:24 AM
To: arslist@ARSLIST.ORG
Subject: Diary Field Issue


**=20

Happy Friday!

=20

A user of mine traveling overseas was trying to do a demonstration of
our custom help desk app.  When she clicked on the button to expand the
diary field (Activity Log) to the dialog box, neither the Diary History
nor the Diary Editor fields were visible.  I have never seen this happen
before.

=20

I have attached screen shots of both the Diary Field dialog box in
question and a normal view. =20

=20

The user was using the 7.0.1 patch 002 User Tool.  I don't have the OS
info yet, but believe it is Windows XP.

=20

Other specs...

ARS 6.3.0 patch 20

Oracle 9i

HP-UX 11i

=20

Any ideas what maybe causing this?

=20

Thanks!

Mike

__20060125___This posting was submitted with HTML in
it___=20

#=

The information contained in this electronic mail message, including atta=
chments, if any, is PetSmart confidential information.  It is intended on=
ly for the use of the person(s) named above.  If the reader of this messa=
ge is not the intended recipient, or has received this message in error, =
you are hereby notified that any review, dissemination, distribution or c=
opying of this communication is strictly prohibited.  If you are not the =
intended recipient or have received this message in error, please notify =
the sender via e-mail and promptly delete the original message.
#=


___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

--_=_NextPart_001_01C7A9D9.D7A0D903
Content-Type: text/html;
 charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

**





<=
SPAN=20
class=3D302403014-08062007>I've seen things like this before where the .a=
rf files=20
have become corrupt.  try deleting th

Re: New Support Policy?

2007-04-19 Thread Joseph Kasell
Here's another endorsement...but for ColumnIT.  We switched to them late
last year and I have to say that the change has been noticeable from our
end.  In the last year we had support from BMC, the quality of assistance
had been uneven at best: sometimes getting support staff who was pretty
knowledgeable, and other times getting support staff who seemed to have
been a recent "grad" of the Admin class that would provide what appeared to
be canned responses to questions (in one case the response did not directly
answer the question posed...after repeated attempts for a response on point
I had to go to management to get the information I was seeking).
Naturally, I had no idea what we were getting into by engaging Column.  I
have to say I've been pretty pleased.  They have been responsive; they
don't rely on the crutch of "send us your log files"; they call back; if
need be they will set up a WebEx session and walk through various steps to
troubleshoot a problem (I had them on for an hour and a half in one
instance...they were very patient in their approach).  Overall, we've been
happy.

Joseph Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union
Vienna, Virginia



   
 Susan Palmer  
 <[EMAIL PROTECTED] 
 L.COM> To 
 Sent by: "Action  arslist@ARSLIST.ORG 
 Request System cc 
 discussion
 list(ARSList)"Subject 
 <[EMAIL PROTECTED] Re: New Support Policy? 
 ORG>  
   
   
 04/19/2007 02:57  
 PM
   
   
 Please respond to 
 [EMAIL PROTECTED] 
RG 
   
   




--=_Part_58343_509886.1177009053768
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Now that is a 'customer' endorsement.  The kind that counts.  Not only are
they paying, but they are using!  Don't get caught up in the partner sell
jobs.  This is the type of information you need to base your choices on.

Susan


On 4/19/07, Ben Cantatore <[EMAIL PROTECTED]> wrote:
>
> **
> I would recommend TuringSMI support at this point and time.  I've been
> working with them since October 2006.  My first opinion of them was what
=
the
> hell did my boss get us into.  I was used to the excellent support I
used=
 to
> get from BMC, coupled with the fact that ITSM was (and still is) buggy
an=
d
> relatively few people were familiar, much less expert in it.  Since those
> early days, Turing has hired some quality individuals (many familiar
name=
s
> from ARSlist) and I believe worked on their internal communications.  I
> still think they have a bit more growing pains to work out but they've
do=
ne
> an execellent job of turning around their support.
>
>
>
>
>
>
>   *"Wilson, Bruce B" <[EMAIL PROTECTED]>*
> Sent by: "Action Request System discussion list(ARSList)" <
> arslist@ARSLIST.ORG>
>
> 04/18/2007 02:10 PM   Please respond to
> arslist@ARSLIST.ORG
>
>To
> arslist@ARSLIST.ORG  cc
>   Subject
> New Support Policy?
>
>
>
>
> **
> The trail is becoming more twisted=85
>
> Apparently, when you now call the BMC support center with a new issue,
yo=
u
> no longer speak to a support technician.
> Instead, you speak to someone who takes some cursory notes and creates a
> ticket for you.
> Basically, it is the same thing as if you were to go online via Remedy
> support and create your own ticket.
>
> I remember previous to this, you got someone who could not speak very
goo=
d
> English and would attempt to solve

Post 7.0.01 Upgrade Problem

2007-03-28 Thread Joseph Kasell
Here is our environment:

Server OS: Windows 2003
ARS Version: 7.0.01 patch 001

On 3/18, we upgraded from version 6.3, patch 20.  These first two weeks in
production of the new server software we've been experiencing degradation
of server performance.  At first, it was barely noticeable as we perform
actions such as submits, queries, and making changes to an active link or
filter.  But the gradual degradation eventually reached the point where
twice last week and once this week (3/21, 3/23, and 3/27) the Remedy server
service crashed and we were forced to reboot the server.

Several observations:

1.  There hasn't been any critical changes to any workflow.  The reference
above to changing an active link or filter was merely turning it on or off
to test response times upon saving.

2.  Just before the 3/21 crash, the memory used by the ARServer service was
in the high 400 MBs and for the ARPlugin service it was in the 120MB range.
Following a restart of the ARService it shrunk down to 382 MB and 23 MB,
respectively.  In the time that followed both services began to grab more
and more memory with similar memory usage levels just before the other two
crashes.  We did not see this in our production environment before the
upgrade.  Additionally, our test and dev environments, which are duplicates
of production, are also stable.

3.  The arerror.log is recording the following at crash time:

"Fri Mar 23 08:38:41 2007  390695 : AR System server terminated -- fatal
error encountered (ARNOTE 21)
Fri Mar 23 08:38:41 2007  390695 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
Fri Mar 23 08:38:41 2007 0xe06d7363"

4.  Additionally, the MS Server Event Logs for our production server has a
recurring Application Error message, which varies a bit, but is relatively
consistent in language, and has persisted since the upgrade to 7.  An
example of the message is as follows:

"Faulting application arplugin.exe, version 7.0.1.1, faulting module
arfcbdata.dll, version 5.6.0.0, fault address 0x56ea.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.";

We have been in contact with support on this.  We have a temporary fix in
place that will automatically recycle the arserver process during the
overnight hours.  Has anybody else run into this?  I appreciate your help.

Joe Kasell
Network Management Integrator
Telecommunications Division
Navy Federal Credit Union

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"