All,

I am trying to get some ideas for a server specification. Can you help?
Below are the details of what we will have:

120 licenses -- 40 fixed 80 floating. About 100-105 concurrent users
ARS 4.5.2
HelpDesk 4.0.3
Change Management
The AR Server must be an WINNT/WIN2K box.

The database will be an oracle 8.0.6 database on AIX Unix (unless anyone
has a reason to go with SQL Server and NT/2000).



We are also geographically dispersed across the midwest and north east.
Would you all have a single server? Would you use multiple servers and
dso?

Thanks for the help.

Matt

_____________________________

Just one minor note I'm sure you are already aware of.....Oracle is case sensitive. That can be a pain in doing certain kinds of searches. We are on Oracle here, and there are several instances where case sensitivity really hurts.

Lisa Bryant
Compass Bank

>>> mjmaxson@NISOURCE.COM 12/28/01 01:39PM >>>
**

All,

I am trying to get some ideas for a server specification. Can you help?
Below are the details of what we will have:

120 licenses -- 40 fixed 80 floating. About 100-105 concurrent users
ARS 4.5.2
HelpDesk 4.0.3
Change Management
The AR Server must be an WINNT/WIN2K box.

The database will be an oracle 8.0.6 database on AIX Unix (unless anyone
has a reason to go with SQL Server and NT/2000).



We are also geographically dispersed across the midwest and north east.
Would you all have a single server? Would you use multiple servers and
dso?

Thanks for the help.

Matt

_____________________________



_____________________________

You can also do sql searches instead.
Just do select from

where upper() like upper()
|| '%'
This will cause a case insensitive search.

Plus I find sql searches are much quicker and pull less data. If you create
a search menu in remedy and put a sort on it, you pull 4 fields of data.
Where as in a sql menu you only pull one or two fields of data.

-----Original Message-----
From: Lisa Bryant [mailto:Lisa.Bryant@COMPASSBNK.COM]
Sent: Friday, December 28, 2001 4:59 PM
Subject: Re: Server Specifications


**

Just one minor note I'm sure you are already aware of.....Oracle is case
sensitive. That can be a pain in doing certain kinds of searches. We are
on Oracle here, and there are several instances where case sensitivity
really hurts.

Lisa Bryant
Compass Bank

>>> mjmaxson@NISOURCE.COM 12/28/01 01:39PM >>>
**

All,

I am trying to get some ideas for a server specification. Can you help?
Below are the details of what we will have:

120 licenses -- 40 fixed 80 floating. About 100-105 concurrent users
ARS 4.5.2
HelpDesk 4.0.3
Change Management
The AR Server must be an WINNT/WIN2K box.

The database will be an oracle 8.0.6 database on AIX Unix (unless anyone
has a reason to go with SQL Server and NT/2000).



We are also geographically dispersed across the midwest and north east.
Would you all have a single server? Would you use multiple servers and
dso?

Thanks for the help.

Matt

________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________

Brian:

I'll test this as we need to pull back information on a particular form. This may prove very helpful. Have you tried this with a user selectable list field to provide input?

James Mckenzie

Original Message:
-----------------
From: Brian Goralczyk Brian.Goralczyk@VERIZONWIRELESS.COM
Date: Mon, 31 Dec 2001 09:12:56 -0500
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Server Specifications


**

You can also do sql searches instead.
Just do select from where upper() like upper()
|| '%'
This will cause a case insensitive search.

Plus I find sql searches are much quicker and pull less data. If you create
a search menu in remedy and put a sort on it, you pull 4 fields of data.
Where as in a sql menu you only pull one or two fields of data.

-----Original Message-----
From: Lisa Bryant [mailto:Lisa.Bryant@COMPASSBNK.COM]
Sent: Friday, December 28, 2001 4:59 PM
Subject: Re: Server Specifications


**

Just one minor note I'm sure you are already aware of.....Oracle is case
sensitive. That can be a pain in doing certain kinds of searches. We are
on Oracle here, and there are several instances where case sensitivity
really hurts.

Lisa Bryant
Compass Bank

>>> mjmaxson@NISOURCE.COM 12/28/01 01:39PM >>>
**

All,

I am trying to get some ideas for a server specification. Can you help?
Below are the details of what we will have:

120 licenses -- 40 fixed 80 floating. About 100-105 concurrent users
ARS 4.5.2
HelpDesk 4.0.3
Change Management
The AR Server must be an WINNT/WIN2K box.

The database will be an oracle 8.0.6 database on AIX Unix (unless anyone
has a reason to go with SQL Server and NT/2000).



We are also geographically dispersed across the midwest and north east.
Would you all have a single server? Would you use multiple servers and
dso?

Thanks for the help.

Matt

________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________



--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .

_____________________________