date:20100414

If the 7.1 prefetch pushes files to the client, I, too, would be surprised.
What I understand is similar to what you do - it pre-caches the file
definitions to the Mid-Tier server, so that if the client has to re-cache,
it doesn't have to wait for that first step of caching from the AR server
to the Mid-Tier servert to happen. You can configure how often it checks for
that, and force a re-cache on demand if you wish, but you can also leave the
client files alone if you wish, which would give the appearance that the
re-cache also improved performance down to the client level, even if
technically all it did was remove the requirement of a client re-cache with
a MT configuration setting that I think has been there since v6.  The
pre-cache in v7 simply gave more power to that option by precaching to the
MT server as well.  Perhaps that is what the sales people are saying.

So, pre-7.1, the Client (Browser) opens a Remedy form.  Browser checks MT
server to see if the hash on the client's cached copy of that form is equal
to that which is on the MT server.  Under the pre 7.1 MT config, the MT
server may or may not have a locally cached copy of that form, only getting
that copy on demand (i.e. the first person to request it forces the
re-cache).  So the MT server has to wait for the AR Server to at least
check, and possibly re-cache the form, and the client has to wait for the MT
server to do that so that it can go through the same process.

In 7.1, if the form is pre-cached to the MT server, the MT -- AR Server
wait time is removed (unless the form has been changed since the last
pre-cache).  The only check that has to be made is from the client to the MT
server.  If the client's cached copy is identical to that of the MT server,
no re-cache is necessary.

Rick
On Wed, Apr 14, 2010 at 6:44 AM, remedy lee haeyoon@gmail.com wrote:

 Hi,

 I'm confused on this prefetch 'feature' in midtier.
 The way I read it is that only when a server is restarted will the
 forms (on the web server) reload in order to save time when the first
 user logs in.
 So instead of loading HPD:Help Desk when a user first hits it, it will
 load by itself when restarted.
 Benefit is that the first user logging in won't get that 1-2 mins
 loading wait.

 Now sales people and certain consultants say that prefetch does more
 than that.
 It actually loads the forms into the clients computer and therefore
 speeds up the whole midtier itself.
 So they say that prefetch helps overall everyday midtier use such as
 the 50th person using HPD:Help Desk will notice better speeds with
 prefetch than without.
 They say it loads the forms to the clients computers preemptively and
 therefore improves performance.
 To me that doesn't make sense, how can the server know where to load
 the files.  Does it work by loading all the web forms when the person
 logs in?

 I really see no benefit to using prefetch if our server hardly restarts


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


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

Re: Extracting digits from a character field

2010-04-14 Thread Grooms, Frederick W

Depending on how the data is in the string (and since you are on Oracle) you 
can use the Regexp_REPLACE oracle function

In a Set Fields from SQL action set a field equal to $1$ from:

SELECT Regexp_REPLACE('$source field$ ', 
'([[:cntrl:][:punct:][:space:][:alpha:]])','') from DUAL

This will remove all control, punctuation, white space, and alpha characters 
from the string.  (Yes there is a space after the source field so in case the 
source field is null then the function will not error but will return null)

For Oracle REGEXP functions you can reference:  
http://psoug.org/reference/regexp.html

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 8:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field

I have a free form character field and need to extract digits from that field - 
may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of 
strstr??) Looks painful to me.

Help please

Atul

Re: Benefit of Prefetch Remedy midtier 7.1

2010-04-14 Thread Nicky Madjarov


Well,

I agree that the secong part is confusing, and it deffinitely does not 
happen the way you refered, have no idea where you got this info from, but 
generally a sales persons (even from bmc) are not a good source.


So, the benefits are, as you said, that the forms are pre-cached, especially 
helpfull when you run multiple mid-tiers. you can put a web in the mix and 
users won't see the difference (or a delay). For frequently used forms in 
busy environment you may have multiple users requesting them at the same 
time, so if 50 users wait for the help desk to cache at the same time that 
will kill the performance of your mid-tier, because you have 50 requests 
waiting.


Regards,

Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
- Original Message - 
From: remedy lee haeyoon@gmail.com

Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Wednesday, April 14, 2010 9:44 AM
Subject: Benefit of Prefetch Remedy midtier 7.1



Hi,

I'm confused on this prefetch 'feature' in midtier.
The way I read it is that only when a server is restarted will the
forms (on the web server) reload in order to save time when the first
user logs in.
So instead of loading HPD:Help Desk when a user first hits it, it will
load by itself when restarted.
Benefit is that the first user logging in won't get that 1-2 mins
loading wait.

Now sales people and certain consultants say that prefetch does more
than that.
It actually loads the forms into the clients computer and therefore
speeds up the whole midtier itself.
So they say that prefetch helps overall everyday midtier use such as
the 50th person using HPD:Help Desk will notice better speeds with
prefetch than without.
They say it loads the forms to the clients computers preemptively and
therefore improves performance.
To me that doesn't make sense, how can the server know where to load
the files.  Does it work by loading all the web forms when the person
logs in?

I really see no benefit to using prefetch if our server hardly restarts

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



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

Re: Benefit of Prefetch Remedy midtier 7.1

2010-04-14 Thread Marsh, Lee

For us the most significant part of the pre-fetch is that the form is
translated.  It is translated  to Java code and cached.   This cache of
Java code is available for any request for the form.   We found that the
translation takes significant server processing resources that impacts
the performance of requests.   Pre-fetching reduces these impacts for
most of the dominant forms.  

 

 

* 
Lee Marsh 
Remedy Administrator

BAE Systems Office Automation Systems Team
Antitrust Division, U.S. Department of Justice

Phone:  202-305-9725 

Cell:  202-528-1749
Email: lee.ma...@usdoj.gov 
*

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Rick Cook
Sent: Wednesday, April 14, 2010 10:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: Benefit of Prefetch Remedy midtier 7.1

 

** 

If the 7.1 prefetch pushes files to the client, I, too, would be
surprised.  What I understand is similar to what you do - it pre-caches
the file definitions to the Mid-Tier server, so that if the client has
to re-cache, it doesn't have to wait for that first step of caching from
the AR server to the Mid-Tier servert to happen. You can configure how
often it checks for that, and force a re-cache on demand if you wish,
but you can also leave the client files alone if you wish, which would
give the appearance that the re-cache also improved performance down to
the client level, even if technically all it did was remove the
requirement of a client re-cache with a MT configuration setting that I
think has been there since v6.  The pre-cache in v7 simply gave more
power to that option by precaching to the MT server as well.  Perhaps
that is what the sales people are saying.  

 

So, pre-7.1, the Client (Browser) opens a Remedy form.  Browser checks
MT server to see if the hash on the client's cached copy of that form is
equal to that which is on the MT server.  Under the pre 7.1 MT config,
the MT server may or may not have a locally cached copy of that form,
only getting that copy on demand (i.e. the first person to request it
forces the re-cache).  So the MT server has to wait for the AR Server to
at least check, and possibly re-cache the form, and the client has to
wait for the MT server to do that so that it can go through the same
process.

 

In 7.1, if the form is pre-cached to the MT server, the MT -- AR Server
wait time is removed (unless the form has been changed since the last
pre-cache).  The only check that has to be made is from the client to
the MT server.  If the client's cached copy is identical to that of the
MT server, no re-cache is necessary.

 

Rick

On Wed, Apr 14, 2010 at 6:44 AM, remedy lee haeyoon@gmail.com
wrote:

Hi,

I'm confused on this prefetch 'feature' in midtier.
The way I read it is that only when a server is restarted will the
forms (on the web server) reload in order to save time when the first
user logs in.
So instead of loading HPD:Help Desk when a user first hits it, it will
load by itself when restarted.
Benefit is that the first user logging in won't get that 1-2 mins
loading wait.

Now sales people and certain consultants say that prefetch does more
than that.
It actually loads the forms into the clients computer and therefore
speeds up the whole midtier itself.
So they say that prefetch helps overall everyday midtier use such as
the 50th person using HPD:Help Desk will notice better speeds with
prefetch than without.
They say it loads the forms to the clients computers preemptively and
therefore improves performance.
To me that doesn't make sense, how can the server know where to load
the files.  Does it work by loading all the web forms when the person
logs in?

I really see no benefit to using prefetch if our server hardly restarts


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
attend wwrug10 www.wwrug.com http://www.wwrug.com/  ARSlist: Where
the Answers Are


_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 

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

Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field


I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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

Re: Extracting digits from a character field

2010-04-14 Thread Jim Fox

On MS-SQL, trying to replace one character with Null is not a good idea.

Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field

I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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

Sent from my Verizon Wireless BlackBerry

Re: Benefit of Prefetch Remedy midtier 7.1

2010-04-14 Thread Pargeter, Christie :CO IS

You can trigger the Prefetch by bouncing Tomcat.  You don't have to
reboot the whole server to trigger it. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of remedy lee
Sent: Wednesday, April 14, 2010 6:45 AM
To: arslist@ARSLIST.ORG
Subject: Benefit of Prefetch Remedy midtier 7.1

Hi,

I'm confused on this prefetch 'feature' in midtier.
The way I read it is that only when a server is restarted will the forms
(on the web server) reload in order to save time when the first user
logs in.
So instead of loading HPD:Help Desk when a user first hits it, it will
load by itself when restarted.
Benefit is that the first user logging in won't get that 1-2 mins
loading wait.

Now sales people and certain consultants say that prefetch does more
than that.
It actually loads the forms into the clients computer and therefore
speeds up the whole midtier itself.
So they say that prefetch helps overall everyday midtier use such as the
50th person using HPD:Help Desk will notice better speeds with prefetch
than without.
They say it loads the forms to the clients computers preemptively and
therefore improves performance.
To me that doesn't make sense, how can the server know where to load the
files.  Does it work by loading all the web forms when the person logs
in?

I really see no benefit to using prefetch if our server hardly restarts

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

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

ITSM consultants required for Immediate contract roles

2010-04-14 Thread Greg Park

I am looking for a number of ITSM consultants with experience of DSO and
CMDB, please contact me on the below details as soon as possible to
discuss your availability.

 

Greg Park

 

Business Development Manager

 

Fusion Business Solutions (UK) Ltd

Tel: +44 (0) 208 814 6194

Mob: +44 (0) 7815 576 613

www.fusion.co.uk http://www.fusion.co.uk/ 

 

Fusion is the largest consultancy in Europe that focuses exclusively on
BMC Software solutions

 

 


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

Re: ARX Files from MidTier

Lisa,

I highly doubt there is a limit like that.. Check your web server log files
to see if there is a web server level error that was reported at that time.
I'm inclined to think you might have encountered a out of memory error on
the web server that may have resulted in that. In which case adjusting your
heap size might be in order..

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Kemes, Lisa
  Sent: Monday, April 12, 2010 12:21 PM
  To: arslist@ARSLIST.ORG
  Subject: ARX Files from MidTier


  **
  Is there a limit to how many columns or characters you can save to an arx
file from the MidTier?  Looks like we are starting to get errors (Failed to
Perform Action) when we add more than 213 columns.  The Client is fine and
can handle much more than this..

  ARS 7.1 p7
  AR Midtier 7.5 p2
  Windows 2003

  Lisa Kemes
  AR System Developer
  Tyco Electronics
  717-810-2408 tel
  717-810-2124 fax
  lisa.ke...@tycoelectronics.com

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

Re: Extracting digits from a character field

Jim,

Just curious.. What are the limitations that you encountered replacing a
character or a string with NULL on MS-SQL.. And what version of MS-SQL??

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field


On MS-SQL, trying to replace one character with Null is not a good idea.

Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field


I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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

Re: Problems creating LDAP Vendor forms

Sergio,

One of the records from LDAP from the LDAP attribute that you have mapped to
the Request ID field on the vendor form has a null value. This is preventing
the ARS from displaying the information. Use an LDAP browser and try
locating that record and insert some unique piece of information in that
attribute... I am guessing you are probably on ARS 6.3 or below? I think the
newer version ignores blank values in the Request ID fields or duplicates
and still displays the information..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Sergio Tomillero
Sent: Wednesday, April 14, 2010 6:10 AM
To: arslist@ARSLIST.ORG
Subject: Problems creating LDAP Vendor forms


Hello,

Creating a vendor form,  I indicate the next in vendor properties:
//LDAP_DIRECTORY_SERVICE_HOST/BASE_DN??sub?(objectclass=OrganizationalPe
rson)

I get a list of fields and choose some of them. Once created the form, I
cannot see the results in Remedy.  When accessing to it, and doing a clic on
‘Search’ button,  I get the message:

- ARERR [100] Entry ID void parameter

It happens the same with any Vendor Form using LDAP that I create, instead
of the vendor properties.
Doing a plugging log, I do not see any relevant. Also If I indicate
something in Request ID field, for instance ‘1’ and do a search, I get the
error:

- LDAP : Bad search filter (LDAPERR 87) (ARERR 3377)

Any idea?
Thank you in advance,
Sergio Tomillero

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

Re: Extracting digits from a character field

2010-04-14 Thread Murnane, Phil

Atul:

Being an old-fashioned kind of guy, I'd loop through the source field one 
character at a time, and if a character is a digit, then append it to a 
temporary field.  When you reach the end of the source field, your temporary 
field will contain all the digits.  Maybe best built as a Filter Guide?

Just a Thought,
--Phil


Phil Murnane, Sr Consultant
Windward IT Solutions, Governance and Fulfillment Practice
Email:  pmurn...@windwardits.com
Mobile: 703-896-6435
Web:    www.WindwardITS.com



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 11:12
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

On MS-SQL, trying to replace one character with Null is not a good idea.

Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field


I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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


Sent from my Verizon Wireless BlackBerry

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

Re: Extracting digits from a character field

2010-04-14 Thread Jim Fox

Replaciing a character with Null is an oxymoron in MS-SQL. You would replace a 
character with a zero-length string. Null and  are not the same.

Fluxman
Sent from my Verizon Wireless BlackBerry

-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 11:42:21 
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

Jim,

Just curious.. What are the limitations that you encountered replacing a
character or a string with NULL on MS-SQL.. And what version of MS-SQL??

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

On MS-SQL, trying to replace one character with Null is not a good idea.

Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field

I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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

Re: Extracting digits from a character field

You are right, I just tried and it sets the whole column to NULL instead of
just replacing the specific characters in expression 2 to NULL.. It works
correctly in Oracle to the best of my knowledge..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 1:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field


Replaciing a character with Null is an oxymoron in MS-SQL. You would replace
a character with a zero-length string. Null and  are not the same.

Fluxman
Sent from my Verizon Wireless BlackBerry

-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 11:42:21 
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

Jim,

Just curious.. What are the limitations that you encountered replacing a
character or a string with NULL on MS-SQL.. And what version of MS-SQL??

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field


On MS-SQL, trying to replace one character with Null is not a good idea.

Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field


I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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

Discovery of Asset

2010-04-14 Thread Koyb P. Liabt

Hi,
 
We only have Discovery Foundation 1.6.  Is there any other (free) way  to 
discover storage devices on our network, and load them into the CMDB?
 
I can program so I am not sure if there is way thru programming scripts to  
gather this info that is part of our network.  Our company will not  spend 
the money for BMC Topology which I know covers storage devices.
 
 

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

Location data in 7.5

**
Hello,

I am building an application where menus
need to be provided for the Floor and Room fields of a CI. We are
currently using ITSM 7.0,3, but will be upgrading to a later version sometime
this year. We don't have ITSM 7.6 installed anywhere. In the
7.6 concepts guide, there is a note that  With version 7.5,
the following structures were moved from BMC Remedy ITSM to BMC Atrium
Core: Company (tenancy definition and external company definition), Location,
and Categorization (product categorization). I'm guessing that
means that 7.6 will make use of the PhysicalLocation class to store sites,
although the screen shots in the 7.6 config guide look like the same old
Site screens as in 7.0.3. As part of Asset Management, there is also
an InventoryStorage class for inventory locations.

So, keeping in mind future versions,
which class would be best to use (PhysicalLocation, InventoryStorage, something
else?) to store floor/room information?

Thad Esser
Remedy Developer

*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed.  If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited.  Nothing in this email, including any attachment, is intended to be a legally binding signature.
*

_attend WWRUG10 www.wwrug.com  ARSlist: "Where the Answers Are"_

Re: Extracting digits from a character field

2010-04-14 Thread Jim Fox

You mean works incorrectly. LOL.

F
Sent from my Verizon Wireless BlackBerry

-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 13:25:31 
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

You are right, I just tried and it sets the whole column to NULL instead of
just replacing the specific characters in expression 2 to NULL.. It works
correctly in Oracle to the best of my knowledge..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 1:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

Replaciing a character with Null is an oxymoron in MS-SQL. You would replace
a character with a zero-length string. Null and  are not the same.

Fluxman
Sent from my Verizon Wireless BlackBerry

-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 11:42:21 
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

Jim,

Just curious.. What are the limitations that you encountered replacing a
character or a string with NULL on MS-SQL.. And what version of MS-SQL??

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

On MS-SQL, trying to replace one character with Null is not a good idea.

Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field

I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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

Re: Service-now.com

2010-04-14 Thread Oracle4Me

I might check Service-now out.  And if I like it - I will  recommend this 
to my Clients.   With Remedy I can't get the free demo  license anymore, and 
I personally am not happy with Remedy's support.
 
 
In a message dated 3/22/2010 3:06:32 P.M. Eastern Daylight Time,  
robert.mole...@gmail.com writes:

Just  went to Service-now admin training as a partner - it is very
impressive -  highly customizable - and very clicky to administer -
however with that  said - so is Remedy in the Developer Studio / Admin
Tools. And being a  single-web-based-tool - no need for separate tools
to develop /  use.

Yes we are beginning to see major ground-shift in many  customers
changing from BMC to Service-Now due to the facts that:
* TCO  - and Licensing Model - plus SAAS cuts TCO as well - base
contracts contain  DEV-TEST-PROD without enterprise level contracts -
all MODULES are  available in the base contract as well!
* Desire to stay OOB - never  occurs in Reality - regardless of the product
* BMC ITSM product is quite  huge in the aspects and 'feature richness'
but adds to the deployment  complexity / end-user training /
maintenance costs long term.
* KISS -  is Service-Now - and it's ITIL Certified in 11 modules (3  
remaining)

Now with that said my **PERSONAL** feelings are that:
*  Service Now applications are a bit light compared to BMC ITSM -
however  how many customers use __ALL__ of the fields / functionality
in BMC  ITSM?
* Both Core Systems (Forget ITSM at this point) - are easy  to
develop on, build workflows on, control UI Events, Groups, Roles,  etc.
* However Service-Now wins on the fact that
1). Single tool (web  interface) to build / customize / use
2). No differences in client types  (Thick / Thin)
3). Client Rich Features - such as right click to report,  quick
exports to xyz format, print ticket to Word/PDF/xxx (without needing  a
report!)
4). Visualization of objects (CMDB) and Approval Process  Builder /
Approval Process Life Cycle are quite impressive and respond  much
faster than BMC ITSM
5). ...

So while I might slowly become  a Service-Now convert - I do realize that:
* 11+ Years experience in Remedy  ARS and Applications (since version
3) is highly still valuable
*  Service-Now is becoming a High-Demand Trend which means it is
foolish to  NOT expand my skill-sets
* having Service-Now AND Remedy ARS AND BMC ITSM  experience in real
world experiences is a valuable commodity
*  Customers will continue to require customizations / enhancements to
EITHER  product - and last time I checked I still need to pay the  bills
:)

If in doubt - go check their website - they have weekly  live-demos,
and actually a 'demo system' that is available for you to  play-in,
including as admin so you can develop. (they do refresh the  system
every night back to OOB)

And you can check out their own  words on the topic as  well:
http://www.service-now.com/relief-package-remedy/remedy-facts/

HTH  - and feel free to ask questions offline/online about this...
Robert  Molenda

On Mon, Mar 22, 2010 at 11:38 AM, Matt Worsdell  m...@worsy.co.uk wrote:
 The tool itself yes, I was referring  to customisations.

 Sent from my iPhone


  On 22 Mar 2010, at 18:35, Bing b...@itm3.com  wrote:

 Service-Now is primarily written in Java -- not  JavaScript.

 -- Bing

  -Original Message-
 From: Action Request System discussion  list(ARSList)
 [mailto:arsl...@arslist.org] On Behalf Of Matt  Worsdell
 Sent: Monday, March 22, 2010 11:14 AM
 To:  arslist@ARSLIST.ORG
 Subject: Re:  Service-now.com

 JavaScript predominantly although it  has it's own graphical workflow
 interface.

  Sent from my iPhone


 On 22 Mar 2010, at  18:06, Guillaume Rheault guilla...@dcshq.com  
wrote:

 Hey Bing,

  concerned quelled! :-)
 So what programming language(s) is  Service-Now is developed with?

  Guillaume

  
 From: Action Request  System discussion list(ARSList)
 [arsl...@arslist.org] on  behalf of Bing [b...@itm3.com]
 Sent: Monday, March 22, 2010  1:53 PM
 To: arslist@ARSLIST.ORG
 Subject: Re:  Service-now.com

 Have worked with Service-Now  and found it to be a perfectly viable
 software-as-a-service  (SaaS) solution for service desk activities, and
  more.

 To quell Guillaume's concern . . . yes,  Service-Now is definitely
  customizable.

 Better question is, are you  prepared to forgo software license
 ownership and embrace SaaS?  Perhaps you should be.  IT is supposed to
 provide  business services, not collect and manage company  assets.

 Suggest you speak with BMC Remedy and  Service-Now to hear a balanced
 argument for each approach.  If you don't already have a Service-Now
 contact, here's  the gentleman I started with:

   Tyson  Ricks
   Inside Sales - West
858-345-1926
tyson.ri...@service-now.com

 Tell him Bing sent  you.

 Disclaimer: Not saying Service-Now or any  other SaaS solution is
 better or worse than Remedy.  Only  suggesting you should get ALL the
 facts and

Re: DR Recovery

2010-04-14 Thread Zaayer, Ben (Information Technology)

We have an environment that is HA/DR.  All the ARS boxes are members of the 
server group and at least one is located elsewhere, they all have different 
hostnames / IPs.  If our primary datacenter is rendered unavailable for some 
reason the AR Server and MidTier are already running in our backup datacenter.

Our DBAs replicate our SQL Server DB to a separate cluster in our backup 
datacenter.  I believe they use VVR for this.  My understanding is that once 
failed over, the DB would have the same instance name, but the box it is 
running on would not have the same hostname / IP.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pat Zandi
Sent: Wednesday, April 14, 2010 6:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: DR Recovery

**
Not to be picky,  this is more ha than dr. Unless the other box in the group is 
in Dallas which is not recommended.

Just create a second box put oracle on it as well turn on and test.. Shutdown 
ars side dataguard oracle ship box to Dallas and have ready for standby... That 
is dr..

Ha is two ars boxes running at same time with maybe a load balencer in front

Sent from my iPhone

On Apr 13, 2010, at 4:26 PM, Lyle Taylor 
tayl...@ldschurch.orgmailto:tayl...@ldschurch.org wrote:
Well, I guess it depends on what you’re trying to accomplish.  I’m not sure if 
I see a benefit in doing that over having a server group, though…

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kathy Morris
Sent: Tuesday, April 13, 2010 2:22 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: DR Recovery

**
BMC told me there is a way to do mirroring with the same IP address, and the 
same Host name.  They said it is best that I do not change the Host name and IP 
so then config files do not need to be modified.

In a message dated 4/13/2010 3:30:35 P.M. Eastern Daylight Time, 
tayl...@ldschurch.orgmailto:tayl...@ldschurch.org writes:
**
A server group behind a load balancer can help you accomplish this.  If you 
want, direct all traffic to the primary server unless it’s down, then the LB 
can direct traffic to the backup server.  They can both be up at the same time, 
and the IP address doesn’t need to be the same, and you don’t need to replicate 
data.  You would just have a DNS alias for the load balancer that would be 
exposed to clients – they wouldn’t need to know the details about what’s behind 
the LB.

That doesn’t address database failure, but there are other options in that 
realm that are database specific.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kathy Morris
Sent: Tuesday, April 13, 2010 12:51 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: DR Recovery

**
Hi All,

If you have a DR box that is mirrored after Production.  Someone was telling me 
that there are DR tools that will allow you to have the same Hostname and IP 
address for Prod and the DR server, and allow synchronization between the two 
servers.

During fail over it switches to the DR Box.  My question is if DR server is up, 
it cannot have the same host name and IP address.  If  the DR is down, then the 
synchronization of data will not take place.

Is there a way to have DR mirrored with the same IP and host name?
_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_


NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.

_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_
_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

Re: Location data in 7.5

Thad, I see fields for Room and Floor on the Physical Location CI form in
7.5/7.6.  However, the Location app config form does not have them.  So if
you want to add all that data for each CI, you could do that there.  In
addition, those fields are in the Base Element class, so you could add the
attributes to other classes that were necessary.  It appears that BMC is
trying to push more core data to the CMDB, which makes sense.

As to a Location menu, I don't see anything that references Floor or Room
there, or another source form for that data.

Rick
On Wed, Apr 14, 2010 at 10:59 AM, Thad K Esser tkes...@regence.com wrote:

 **
 Hello,

 I am building an application where menus need to be provided for the Floor
 and Room fields of a CI.  We are currently using ITSM 7.0,3, but will be
 upgrading to a later version sometime this year.  We don't have ITSM 7.6
 installed anywhere.  In the 7.6 concepts guide, there is a note that   With
 version 7.5, the following structures were moved from BMC Remedy ITSM to BMC
 Atrium Core: Company (tenancy definition and external company definition),
 Location, and Categorization (product categorization).  I'm guessing that
 means that 7.6 will make use of the PhysicalLocation class to store sites,
 although the screen shots in the 7.6 config guide look like the same old
 Site screens as in 7.0.3.  As part of Asset Management, there is also an
 InventoryStorage class for inventory locations.

 So, keeping in mind future versions, which class would be best to use
 (PhysicalLocation, InventoryStorage, something else?) to store floor/room
 information?

 *Thad Esser*
 Remedy Developer

 *IMPORTANT NOTICE: This communication, including any attachment, contains
 information that may be confidential or privileged, and is intended solely
 for the entity or individual to whom it is addressed. If you are not the
 intended recipient, you should delete this message and are hereby notified
 that any disclosure, copying, or distribution of this message is strictly
 prohibited. Nothing in this email, including any attachment, is intended to
 be a legally binding signature. *
 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

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

OT: RE:Strage issue

2010-04-14 Thread Jason Miller

I was curious myself so I looked up the difference.  Since regedit was
16-bit and MS is just about finished with the 32-bit OS (the next few years
anyways) I found it curious that they would still have a 16-bit registry
editor.

Here some info I found:

http://support.microsoft.com/kb/141377
Windows XP and Windows Server 2003Regedit.exeRegedit.exe is the
configuration editor for Windows XP and Windows Server 2003. Regedit.exe is
used tomodify the Windows NT configuration database, or the Windows NT
registry. This editor allows you to view or modify the Windows NT registry.
It supports setting security on registry keys, viewing and editing
REG_EXPAND_SZ and REG_MULTI_SZ, and saving and restoring hive files. On the
left side, there are folders that represent registry keys. On the right
side, there are the values associated with the selected registry key.
Regedit is a powerful tool. You must use extreme caution when you use it to
change registry values. Missing or incorrect values in the registry can make
theWindows installation unusable.Regedt32.exeIn Windows XP and Windows
Server 2003, Regedt32.exe is a small program that just runs Regedit.exe.

On Tue, Apr 13, 2010 at 10:29 AM, Joe D'Souza jdso...@shyle.net wrote:

 **
 You are welcome.

 If you need to recreate this for whatever reasons, make sure you create it
 as a multi reg key, and that you use regedt32 as a registry editor. Using
 regedit, will fail. Multi Reg keys cannot be created using regedit (at least
 for older versions of windows - I'm not sure about the newest ones..)

 And while creating this key, when you enter the dependent service name in
 the key value, make sure you enter a carriage return after the key name.
 Without the carriage return, the dependency will not work. A restart of a
 machine is in order when this key is created as without a restart the
 dependency will not be established.

 Joe

 -Original Message-
 *From:* Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org]*on Behalf Of *Daniel Condrea
 *Sent:* Tuesday, April 13, 2010 4:15 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Strage issue

 **
 Thank you very much Joe.

 Indeed it works OK.

 Daniel

  --
 *From:* Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] *On Behalf Of *Joe D'Souza
 *Sent:* Monday, April 12, 2010 9:37 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Strage issue

 **
 Try removing the dependency from the registry. There will be a key called
 DependOnService on the Remedy AR System Server key, that you would need to
 manually delete..

 Joe

 -Original Message-
 *From:* Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org]*on Behalf Of *Daniel Condrea
 *Sent:* Monday, April 12, 2010 9:30 AM
 *To:* arslist@ARSLIST.ORG
 *Subject:* FW: Strage issue

 **
 I have tryed  your sugestion and ARS generate an error is


 I have noticed  that 'AR System Portmapper' depeds on ARS service.

  I belive that 'AR System Portmapper' starts if ARS starts either:

 Register-With-Portmapper: T

 or

 Register-With-Portmapper: F

 Daniel

  --
 *From:* Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] *On Behalf Of *Frank Caruso
 *Sent:* Monday, April 12, 2010 4:05 PM
 *To:* arslist@ARSLIST.ORG
 *Subject:* Re: Strage issue

 ** My guess would be that portmapper is a separate process from arserver
 and that the flag just instructs arserver not utilize portmapper but does
 not prevent portmapper from starting. Disable portmapper as a service and
 restart arserver.


 On Mon, Apr 12, 2010 at 3:57 PM, Daniel Condrea 
 daniel.cond...@orange-ftgroup.com wrote:

 **
 Hello All,

 According to documentation if there is a need to start ARS without AR
 System Portmapper in the ar.cfg file must exist:

 Register-With-Portmapper: F

 After restart we get


 Can you help me with a sugestion?

 Daniel
 ARS 7.1 patch 008
 Oracle 10G

 *
 This message and any attachments (the message) are confidential and 
 intended solely for the addressees.
 Any unauthorised use or dissemination is prohibited.
 Messages are susceptible to alteration.
 France Telecom Group shall not be liable for the message if altered, changed 
 or falsified.
 If you are not the intended addressee of this message, please cancel it 
 immediately and inform the sender.
 

 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_


 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

 *
 This message and any attachments (the message) are confidential and 
 intended solely for the addressees.
 Any unauthorised use or dissemination is prohibited.
 Messages are susceptible to alteration.
 France Telecom Group shall not be liable for the message if altered, changed 
 or falsified.
 If you are not the intended addressee of this message, please

Re: Location data in 7.5

**
Ok, thanks. Do you know if creating
a site via the Location app config form pushes that data to
the PhysicalLocation class?

Thad Esser
Remedy Developer

From:
Rick Cook remedyr...@gmail.com

To:
arslist@ARSLIST.ORG

Date:
04/14/2010 11:19 AM

Subject:
Re: Location data in 7.5

Sent by:
Action Request System discussion
list(ARSList) arslist@ARSLIST.ORG

**
Thad, I see fields for Room and Floor on the Physical
Location CI form in 7.5/7.6. However, the Location app config form
does not have them. So if you want to add all that datafor
each CI, you could do that there. In addition, those fields are in
the Base Element class, so you could add the attributes to other classes
that were necessary. It appears that BMC is trying to push more core
data to the CMDB, which makes sense.

As to a Location menu, I don't see anything that references
Floor or Room there, or another source form for that data.

Rick
On Wed, Apr 14, 2010 at 10:59 AM, Thad K Esser tkes...@regence.com
wrote:
**
Hello,

I am building an application where menus need to be provided for the Floor
and Room fields of a CI. We are currently using ITSM 7.0,3, but will
be upgrading to a later version sometime this year. We don't have
ITSM 7.6 installed anywhere. In the 7.6 concepts guide, there is
a note that With version 7.5, the following structures were
moved from BMC Remedy ITSM to BMC Atrium Core: Company (tenancy definition
and external company definition), Location, and Categorization (product
categorization). I'm guessing that means that 7.6 will make
use of the PhysicalLocation class to store sites, although the screen shots
in the 7.6 config guide look like the same old Site screens as in 7.0.3.
As part of Asset Management, there is also an InventoryStorage class
for inventory locations.

So, keeping in mind future versions, which class would be best to use (PhysicalLocation,
InventoryStorage, something else?) to store floor/room information?

Thad Esser
Remedy Developer
*IMPORTANT NOTICE: This communication, including any attachment,
contains information that may be confidential or privileged, and is intended
solely for the entity or individual to whom it is addressed. If you are
not the intended recipient, you should delete this message and are hereby
notified that any disclosure, copying, or distribution of this message
is strictly prohibited. Nothing in this email, including any attachment,
is intended to be a legally binding signature. *
_attend WWRUG10 www.wwrug.com
ARSlist: Where the Answers Are_

_attend WWRUG10 www.wwrug.com
ARSlist: Where the Answers Are_

*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.
*

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

Re: Location data in 7.5

It doesn't seem to. 

Rick

-Original Message-
From: Thad K Esser tkes...@regence.com
Date: Wed, 14 Apr 2010 11:38:56 
To: arslist@ARSLIST.ORG
Subject: Re: Location data in 7.5

** 
Ok, thanks.  Do you know if creating a site via the Location app config form 
pushes that data to the PhysicalLocation class? 

 Thad Esser
 Remedy Developer 

 From: Rick Cook remedyr...@gmail.com 
 To: arslist@ARSLIST.ORG 
 Date: 04/14/2010 11:19 AM 
 Subject: Re: Location data in 7.5 
 Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG 

** 
Thad, I see fields for Room and Floor on the Physical Location CI form in 
7.5/7.6.  However, the Location app config form does not have them.  So if you 
want to add all that data for each CI, you could do that there.  In addition, 
those fields are in the Base Element class, so you could add the attributes to 
other classes that were necessary.  It appears that BMC is trying to push more 
core data to the CMDB, which makes sense. 

As to a Location menu, I don't see anything that references Floor or Room 
there, or another source form for that data. 

Rick 
On Wed, Apr 14, 2010 at 10:59 AM, Thad K Esser tkes...@regence.com wrote: 
** 
 Hello, 

 I am building an application where menus need to be provided for the Floor and 
Room fields of a CI.  We are currently using ITSM 7.0,3, but will be upgrading 
to a later version sometime this year.  We don't have ITSM 7.6 installed 
anywhere.  In the 7.6 concepts guide, there is a note that   With version 7.5, 
the following structures were moved from BMC Remedy ITSM to BMC Atrium Core: 
Company (tenancy definition and external company definition), Location, and 
Categorization (product categorization).  I'm guessing that means that 7.6 
will make use of the PhysicalLocation class to store sites, although the screen 
shots in the 7.6 config guide look like the same old Site screens as in 7.0.3.  
As part of Asset Management, there is also an InventoryStorage class for 
inventory locations. 

 So, keeping in mind future versions, which class would be best to use 
(PhysicalLocation, InventoryStorage, something else?) to store floor/room 
information? 

 Thad Esser
 Remedy Developer 
*IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed. If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited. 
Nothing in this email, including any attachment, is intended to be a legally 
binding signature. * 
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 

 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 

*IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed. If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited. 
Nothing in this email, including any attachment, is intended to be a legally 
binding signature. * _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers 
Are_

Re: Strage issue

I had a problem with NT 4 while creating dependencies - where regedit.exe
would not allow me to create a multi size key(or I think it did allow me to
create it but it wouldn't work), and had found a tech note about registry
maintenance back then that said I should be using regedt32 to do what I
needed to do. Since then I have always used regedt32 for that. This may have
changed with the newer versions of windows...

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jason Miller
  Sent: Wednesday, April 14, 2010 2:22 PM
  To: arslist@ARSLIST.ORG
  Subject: OT: RE:Strage issue


  ** I was curious myself so I looked up the difference.  Since regedit was
16-bit and MS is just about finished with the 32-bit OS (the next few years
anyways) I found it curious that they would still have a 16-bit registry
editor.

  Here some info I found:

  http://support.microsoft.com/kb/141377

  Windows XP and Windows Server 2003
  Regedit.exe
  Regedit.exe is the configuration editor for Windows XP and Windows Server
2003. Regedit.exe is used tomodify the Windows NT configuration database, or
the Windows NT registry. This editor allows you to view or modify the
Windows NT registry. It supports setting security on registry keys, viewing
and editing REG_EXPAND_SZ and REG_MULTI_SZ, and saving and restoring hive
files. On the left side, there are folders that represent registry keys. On
the right side, there are the values associated with the selected registry
key. Regedit is a powerful tool. You must use extreme caution when you use
it to change registry values. Missing or incorrect values in the registry
can make theWindows installation unusable.
  Regedt32.exe
  In Windows XP and Windows Server 2003, Regedt32.exe is a small program
that just runs Regedit.exe.


  On Tue, Apr 13, 2010 at 10:29 AM, Joe D'Souza jdso...@shyle.net wrote:

**
You are welcome.

If you need to recreate this for whatever reasons, make sure you create
it as a multi reg key, and that you use regedt32 as a registry editor. Using
regedit, will fail. Multi Reg keys cannot be created using regedit (at least
for older versions of windows - I'm not sure about the newest ones..)

And while creating this key, when you enter the dependent service name
in the key value, make sure you enter a carriage return after the key name.
Without the carriage return, the dependency will not work. A restart of a
machine is in order when this key is created as without a restart the
dependency will not be established.

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Daniel Condrea

  Sent: Tuesday, April 13, 2010 4:15 AM
  To: arslist@ARSLIST.ORG

  Subject: Re: Strage issue


  **
  Thank you very much Joe.

  Indeed it works OK.

  Daniel



--
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
  Sent: Monday, April 12, 2010 9:37 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Strage issue


  **
  Try removing the dependency from the registry. There will be a key
called DependOnService on the Remedy AR System Server key, that you would
need to manually delete..

  Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Daniel Condrea
Sent: Monday, April 12, 2010 9:30 AM
To: arslist@ARSLIST.ORG
Subject: FW: Strage issue


**
I have tryed  your sugestion and ARS generate an error is



I have noticed  that 'AR System Portmapper' depeds on ARS service.

I belive that 'AR System Portmapper' starts if ARS starts either:

Register-With-Portmapper: T

or

Register-With-Portmapper: F

Daniel




From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Monday, April 12, 2010 4:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Strage issue


** My guess would be that portmapper is a separate process from
arserver and that the flag just instructs arserver not utilize portmapper
but does not prevent portmapper from starting. Disable portmapper as a
service and restart arserver.



On Mon, Apr 12, 2010 at 3:57 PM, Daniel Condrea
daniel.cond...@orange-ftgroup.com wrote:

  **
  Hello All,

  According to documentation if there is a need to start ARS without
AR System Portmapper in the ar.cfg file must exist:

  Register-With-Portmapper: F

  After restart we get



  Can you help me with a sugestion?

  Daniel
  ARS 7.1 patch

Re: Extracting digits from a character field

I do not have access to an Oracle instance at the moment to try it, but I'm
quite sure that

update tablename set columnname = REPLACE('Does work', 'Does ', NULL);
commit;

would update the column to 'work'. Which is ideally what you would want it
to..

With MS-SQL it sets the column to NULL.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field


You mean works incorrectly. LOL.

F
Sent from my Verizon Wireless BlackBerry

-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 13:25:31 
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

You are right, I just tried and it sets the whole column to NULL instead of
just replacing the specific characters in expression 2 to NULL.. It works
correctly in Oracle to the best of my knowledge..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 1:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field


Replaciing a character with Null is an oxymoron in MS-SQL. You would replace
a character with a zero-length string. Null and  are not the same.

Fluxman
Sent from my Verizon Wireless BlackBerry

-Original Message-
From: Joe D'Souza jdso...@shyle.net
Date: Wed, 14 Apr 2010 11:42:21 
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field

Jim,

Just curious.. What are the limitations that you encountered replacing a
character or a string with NULL on MS-SQL.. And what version of MS-SQL??

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Jim Fox
Sent: Wednesday, April 14, 2010 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Extracting digits from a character field


On MS-SQL, trying to replace one character with Null is not a good idea.

Fluxman
--Original Message--
From: Joe D'Souza
Sender: Action Request System discussion list(ARSList)
To: arslist@ARSLIST.ORG
ReplyTo: arslist@ARSLIST.ORG
Sent: Apr 14, 2010 11:07
Subject: Re: Extracting digits from a character field

If you are in an Oracle database, use the function TRANSLATE to replace all
Alpha characters with either NULL or space or whatever else you wish to..
This will leave the string with only special characters and numerical
characters..

I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
MS-SQL is your underlying database.

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 9:42 AM
To: arslist@ARSLIST.ORG
Subject: Extracting digits from a character field


I have a free form character field and need to extract digits from that
field - may be in a filter? Am on v7.1, oracle.

Any one has some function they used (like in sql or may be combination of
strstr??) Looks painful to me.

Help please

Atul

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

Re: Service-now.com

Do you have a problem when you request for TRIAL licenses?
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of oracle...@aol.com
  Sent: Wednesday, April 14, 2010 2:11 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Service-now.com

  **
  I might check Service-now out.  And if I like it - I will recommend this
to my Clients.   With Remedy I can't get the free demo license anymore, and
I personally am not happy with Remedy's support.

  In a message dated 3/22/2010 3:06:32 P.M. Eastern Daylight Time,
robert.mole...@gmail.com writes:
Just went to Service-now admin training as a partner - it is very
impressive - highly customizable - and very clicky to administer -
however with that said - so is Remedy in the Developer Studio / Admin
Tools. And being a single-web-based-tool - no need for separate tools
to develop / use.

Yes we are beginning to see major ground-shift in many customers
changing from BMC to Service-Now due to the facts that:
* TCO - and Licensing Model - plus SAAS cuts TCO as well - base
contracts contain DEV-TEST-PROD without enterprise level contracts -
all MODULES are available in the base contract as well!
* Desire to stay OOB - never occurs in Reality - regardless of the
product
* BMC ITSM product is quite huge in the aspects and 'feature richness'
but adds to the deployment complexity / end-user training /
maintenance costs long term.
* KISS - is Service-Now - and it's ITIL Certified in 11 modules (3
remaining)

Now with that said my **PERSONAL** feelings are that:
* Service Now applications are a bit light compared to BMC ITSM -
however how many customers use __ALL__ of the fields / functionality
in BMC ITSM?
* Both Core Systems (Forget ITSM at this point) - are easy to
develop on, build workflows on, control UI Events, Groups, Roles, etc.
* However Service-Now wins on the fact that
1). Single tool (web interface) to build / customize / use
2). No differences in client types (Thick / Thin)
3). Client Rich Features - such as right click to report, quick
exports to xyz format, print ticket to Word/PDF/xxx (without needing a
report!)
4). Visualization of objects (CMDB) and Approval Process Builder /
Approval Process Life Cycle are quite impressive and respond much
faster than BMC ITSM
5). ...

So while I might slowly become a Service-Now convert - I do realize
that:
* 11+ Years experience in Remedy ARS and Applications (since version
3) is highly still valuable
* Service-Now is becoming a High-Demand Trend which means it is
foolish to NOT expand my skill-sets
* having Service-Now AND Remedy ARS AND BMC ITSM experience in real
world experiences is a valuable commodity
* Customers will continue to require customizations / enhancements to
EITHER product - and last time I checked I still need to pay the bills
:)

If in doubt - go check their website - they have weekly live-demos,
and actually a 'demo system' that is available for you to play-in,
including as admin so you can develop. (they do refresh the system
every night back to OOB)

And you can check out their own words on the topic as well:
http://www.service-now.com/relief-package-remedy/remedy-facts/

HTH - and feel free to ask questions offline/online about this...
Robert Molenda

On Mon, Mar 22, 2010 at 11:38 AM, Matt Worsdell m...@worsy.co.uk
wrote:
 The tool itself yes, I was referring to customisations.

 Sent from my iPhone

 On 22 Mar 2010, at 18:35, Bing b...@itm3.com wrote:

 Service-Now is primarily written in Java -- not JavaScript.

 -- Bing

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell
 Sent: Monday, March 22, 2010 11:14 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Service-now.com

 JavaScript predominantly although it has it's own graphical workflow
 interface.

 Sent from my iPhone

 On 22 Mar 2010, at 18:06, Guillaume Rheault guilla...@dcshq.com
wrote:

 Hey Bing,

 concerned quelled! :-)
 So what programming language(s) is Service-Now is developed with?

 Guillaume

 From: Action Request System discussion list(ARSList)
 [arsl...@arslist.org] on behalf of Bing [b...@itm3.com]
 Sent: Monday, March 22, 2010 1:53 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: Service-now.com

 Have worked with Service-Now and found it to be a perfectly viable
 software-as-a-service (SaaS) solution for service desk activities,
and
 more.

 To quell Guillaume's concern . . . yes, Service-Now is definitely
 customizable.

 Better question is, are you prepared to

Re: Location data in 7.5

2010-04-14 Thread Guillaume Rheault

The alternative, or in addition to, is to relate the computer system CIs (or 
any other CIs) to the Physical Location CI.
There is a relationship type called Element Location

Guillaume


From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Rick Cook [remedyr...@gmail.com]
Sent: Wednesday, April 14, 2010 2:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Location data in 7.5

**
Thad, I see fields for Room and Floor on the Physical Location CI form in 
7.5/7.6.  However, the Location app config form does not have them.  So if you 
want to add all that data for each CI, you could do that there.  In addition, 
those fields are in the Base Element class, so you could add the attributes to 
other classes that were necessary.  It appears that BMC is trying to push more 
core data to the CMDB, which makes sense.

As to a Location menu, I don't see anything that references Floor or Room 
there, or another source form for that data.

Rick
On Wed, Apr 14, 2010 at 10:59 AM, Thad K Esser 
tkes...@regence.commailto:tkes...@regence.com wrote:
**
Hello,

I am building an application where menus need to be provided for the Floor and 
Room fields of a CI.  We are currently using ITSM 7.0,3, but will be upgrading 
to a later version sometime this year.  We don't have ITSM 7.6 installed 
anywhere.  In the 7.6 concepts guide, there is a note that   With version 7.5, 
the following structures were moved from BMC Remedy ITSM to BMC Atrium Core: 
Company (tenancy definition and external company definition), Location, and 
Categorization (product categorization).  I'm guessing that means that 7.6 
will make use of the PhysicalLocation class to store sites, although the screen 
shots in the 7.6 config guide look like the same old Site screens as in 7.0.3.  
As part of Asset Management, there is also an InventoryStorage class for 
inventory locations.

So, keeping in mind future versions, which class would be best to use 
(PhysicalLocation, InventoryStorage, something else?) to store floor/room 
information?

Thad Esser
Remedy Developer

*IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed. If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited. 
Nothing in this email, including any attachment, is intended to be a legally 
binding signature. *

_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the 
Answers Are_

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

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

Re: Location data in 7.5

**
I had considered that, but its overkill
for what I need right now The Region/Site Group/Site/Floor/Room attributes
are adequate for specifying the location of a CI. I was just looking
for the best place to put my list of possible floors and rooms to use as
a data source for lookups and menus.

Thanks,
Thad Esser
Remedy Developer





From:
Guillaume Rheault guilla...@dcshq.com

To:
arslist@ARSLIST.ORG

Date:
04/14/2010 12:53 PM

Subject:
Re: Location data in 7.5

Sent by:
Action Request System discussion
list(ARSList) arslist@ARSLIST.ORG




** 
The alternative, or in addition to, is to
relate the computer system CIs (or any other CIs) to the Physical Location
CI.
There is a relationship type called Element Location

Guillaume
 


From: Action Request System discussion
list(ARSList) [arsl...@arslist.org] on behalf of Rick Cook [remedyr...@gmail.com]
Sent: Wednesday, April 14, 2010 2:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Location data in 7.5

** 
Thad, I see fields for Room and Floor on
the Physical Location CI form in 7.5/7.6. However, the Location app
config form does not have them. So if you want to add all that data
for each CI, you could do that there. In addition, those fields are
in the Base Element class, so you could add the attributes to other classes
that were necessary. It appears that BMC is trying to push more core
data to the CMDB, which makes sense.

As to a Location menu, I don't see anything
that references Floor or Room there, or another source form for that data.

Rick
On Wed, Apr 14, 2010 at 10:59 AM, Thad K
Esser tkes...@regence.com
wrote:
** 
Hello, 

I am building an application where menus need to be provided for the Floor
and Room fields of a CI. We are currently using ITSM 7.0,3, but will
be upgrading to a later version sometime this year. We don't have
ITSM 7.6 installed anywhere. In the 7.6 concepts guide, there is
a note that  With version 7.5, the following structures were
moved from BMC Remedy ITSM to BMC Atrium Core: Company (tenancy definition
and external company definition), Location, and Categorization (product
categorization). I'm guessing that means that 7.6 will make
use of the PhysicalLocation class to store sites, although the screen shots
in the 7.6 config guide look like the same old Site screens as in 7.0.3.
As part of Asset Management, there is also an InventoryStorage class
for inventory locations. 

So, keeping in mind future versions, which class would be best to use (PhysicalLocation,
InventoryStorage, something else?) to store floor/room information?


Thad Esser
Remedy Developer 
*IMPORTANT NOTICE: This communication, including
any attachment, contains information that may be confidential or privileged,
and is intended solely for the entity or individual to whom it is addressed.
If you are not the intended recipient, you should delete this message and
are hereby notified that any disclosure, copying, or distribution of this
message is strictly prohibited. Nothing in this email, including any attachment,
is intended to be a legally binding signature. * 
_attend WWRUG10 www.wwrug.com
ARSlist: Where the Answers Are_ 

_attend WWRUG10 www.wwrug.com
ARSlist: Where the Answers Are_ 
_attend WWRUG10 www.wwrug.com
ARSlist: Where the Answers Are_ 



*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed.  If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited.  Nothing in this email, including any attachment, is intended to be a legally binding signature.
*

_attend WWRUG10 www.wwrug.com  ARSlist: "Where the Answers Are"_

PeopleSoft Purchasing to Remedy 6.3 AM Module

2010-04-14 Thread Dan

Has anyone out there successfully integrated People Soft Purchasing to
Remedy 6.3 AM Module?  I am looking for a relatively simple way to connect
the 2 systems so when an asset is received thru PS an asset record is sent
to Remedy Asset Manager automatically.  Surely we aren't the first.

 

Thanks in advance, Dan


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

Re: Location data in 7.5

2010-04-14 Thread Guillaume Rheault

I guess that's fine for now.

Keep in mind that a lot of foundational data (people, groups, locations) will 
eventually end up in the CMDB, since for ITIL pretty much anything is a CI...

Guillaume



From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Thad K Esser [tkes...@regence.com]
Sent: Wednesday, April 14, 2010 4:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Location data in 7.5

**
I had considered that, but its overkill for what I need right now  The 
Region/Site Group/Site/Floor/Room attributes are adequate for specifying the 
location of a CI.  I was just looking for the best place to put my list of 
possible floors and rooms to use as a data source for lookups and menus.

Thanks,
Thad Esser
Remedy Developer


From:   Guillaume Rheault guilla...@dcshq.com
To: arslist@ARSLIST.ORG
Date:   04/14/2010 12:53 PM
Subject:Re: Location data in 7.5
Sent by:Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG





**
The alternative, or in addition to, is to relate the computer system CIs (or 
any other CIs) to the Physical Location CI.
There is a relationship type called Element Location

Guillaume



From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Rick Cook [remedyr...@gmail.com]
Sent: Wednesday, April 14, 2010 2:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Location data in 7.5

**
Thad, I see fields for Room and Floor on the Physical Location CI form in 
7.5/7.6.  However, the Location app config form does not have them.  So if you 
want to add all that data for each CI, you could do that there.  In addition, 
those fields are in the Base Element class, so you could add the attributes to 
other classes that were necessary.  It appears that BMC is trying to push more 
core data to the CMDB, which makes sense.

As to a Location menu, I don't see anything that references Floor or Room 
there, or another source form for that data.

Rick
On Wed, Apr 14, 2010 at 10:59 AM, Thad K Esser 
tkes...@regence.commailto:tkes...@regence.com wrote:
**
Hello,

I am building an application where menus need to be provided for the Floor and 
Room fields of a CI.  We are currently using ITSM 7.0,3, but will be upgrading 
to a later version sometime this year.  We don't have ITSM 7.6 installed 
anywhere.  In the 7.6 concepts guide, there is a note that   With version 7.5, 
the following structures were moved from BMC Remedy ITSM to BMC Atrium Core: 
Company (tenancy definition and external company definition), Location, and 
Categorization (product categorization).  I'm guessing that means that 7.6 
will make use of the PhysicalLocation class to store sites, although the screen 
shots in the 7.6 config guide look like the same old Site screens as in 7.0.3.  
As part of Asset Management, there is also an InventoryStorage class for 
inventory locations.

So, keeping in mind future versions, which class would be best to use 
(PhysicalLocation, InventoryStorage, something else?) to store floor/room 
information?

Thad Esser
Remedy Developer
*IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed. If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited. 
Nothing in this email, including any attachment, is intended to be a legally 
binding signature. *

_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the 
Answers Are_

_attend WWRUG10 www.wwrug.comUrlBlockedError.aspx ARSlist: Where the Answers 
Are_
_attend WWRUG10 www.wwrug.comUrlBlockedError.aspx ARSlist: Where the Answers 
Are_


*IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed. If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited. 
Nothing in this email, including any attachment, is intended to be a legally 
binding signature. *

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

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

TR vs DB sanity check please

2010-04-14 Thread Drew Shuller

Hello all,

I've got one filter that checks for a change in a field called
AssignedToTech that seems to be running even though the field didn't
change. I ran a SQL log but didn't see any kind of insert statement
that referenced that field. My Runif: 'AssignedToTech' !=
'AssignedToTech'

Sometimes the filter fires, sometimes it doesn't! I've got the run if
right, don't I?

-- 
Drew

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

Re: TR vs DB sanity check please

Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Drew Shuller
Sent: Wednesday, April 14, 2010 3:27 PM
To: arslist@ARSLIST.ORG
Subject: TR vs DB sanity check please

Hello all,

I've got one filter that checks for a change in a field called
AssignedToTech that seems to be running even though the field didn't
change. I ran a SQL log but didn't see any kind of insert statement
that referenced that field. My Runif: 'AssignedToTech' !=
'AssignedToTech'

Sometimes the filter fires, sometimes it doesn't! I've got the run if
right, don't I?

-- 
Drew

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

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

Re: TR vs DB sanity check please

Drew, TR is implied as the current transaction value, and does not need to
be explicitly mentioned.  DB is not implied, and must be specified for
consistent behavior.  So the better Run If qual would be  'AssignedToTech'
!= 'DB.AssignedToTech'
 Rick
On Wed, Apr 14, 2010 at 1:27 PM, Drew Shuller d...@io.com wrote:

 Hello all,

 I've got one filter that checks for a change in a field called
 AssignedToTech that seems to be running even though the field didn't
 change. I ran a SQL log but didn't see any kind of insert statement
 that referenced that field. My Runif: 'AssignedToTech' !=
 'AssignedToTech'

 Sometimes the filter fires, sometimes it doesn't! I've got the run if
 right, don't I?

 --
 Drew


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


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

Re: TR vs DB sanity check please

**
Tommy,

In some situations, your version will
evaluate to true, even though nothing changed.

To truly detect if a value changed,
its best to use:
'AssignedToTech' != 'DB.AssignedToTech'


Thad Esser
Remedy Developer





From:
Tommy Morris tommy.mor...@radioshack.com

To:
arslist@ARSLIST.ORG

Date:
04/14/2010 01:39 PM

Subject:
Re: TR vs DB sanity check please

Sent by:
Action Request System discussion
list(ARSList) arslist@ARSLIST.ORG




Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)
_attend WWRUG10 www.wwrug.com  ARSlist: "Where the Answers Are"_

Re: TR vs DB sanity check please

I understand how Rick put it that the TR is implied so you don't have to
specify it but why would including the identifier cause an erroneous
result? 

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Thad K Esser
Sent: Wednesday, April 14, 2010 3:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

 

** 
Tommy, 

In some situations, your version will evaluate to true, even though
nothing changed. 

To truly detect if a value changed, its best to use: 
 'AssignedToTech' != 'DB.AssignedToTech'   

Thad Esser
Remedy Developer 



From: 

Tommy Morris tommy.mor...@radioshack.com 

To: 

arslist@ARSLIST.ORG 

Date: 

04/14/2010 01:39 PM 

Subject: 

Re: TR vs DB sanity check please 

Sent by: 

Action Request System discussion list(ARSList) arslist@ARSLIST.ORG

 






Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 


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

Re: TR vs DB sanity check please

2010-04-14 Thread Grooms, Frederick W

If the field's value has not changed then the TR value is NULL while the DB 
value may not be NULL

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Tommy Morris
Sent: Wednesday, April 14, 2010 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

**
I understand how Rick put it that the TR is implied so you don't have to 
specify it but why would including the identifier cause an erroneous result?

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Thad K Esser
Sent: Wednesday, April 14, 2010 3:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

**
Tommy,

In some situations, your version will evaluate to true, even though nothing 
changed.

To truly detect if a value changed, its best to use:
 'AssignedToTech' != 'DB.AssignedToTech'

Thad Esser
Remedy Developer
From:

Tommy Morris tommy.mor...@radioshack.com

To:

arslist@ARSLIST.ORG

Date:

04/14/2010 01:39 PM

Subject:

Re: TR vs DB sanity check please

Sent by:

Action Request System discussion list(ARSList) arslist@ARSLIST.ORG




Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)



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

Re: TR vs DB sanity check please

Ahh, so without the TR specified it looks to the true current value
instead of looking for an actual transaction?

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, April 14, 2010 3:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

 

** 

If the field's value has not changed then the TR value is NULL while the
DB value may not be NULL

 

Fred

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Tommy Morris
Sent: Wednesday, April 14, 2010 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

 

** 

I understand how Rick put it that the TR is implied so you don't have to
specify it but why would including the identifier cause an erroneous
result? 

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Thad K Esser
Sent: Wednesday, April 14, 2010 3:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

 

** 
Tommy, 

In some situations, your version will evaluate to true, even though
nothing changed. 

To truly detect if a value changed, its best to use: 
 'AssignedToTech' != 'DB.AssignedToTech'   

Thad Esser
Remedy Developer 

From: 

Tommy Morris tommy.mor...@radioshack.com 

To: 

arslist@ARSLIST.ORG 

Date: 

04/14/2010 01:39 PM 

Subject: 

Re: TR vs DB sanity check please 

Sent by: 

Action Request System discussion list(ARSList) arslist@ARSLIST.ORG

 




Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)

 

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 


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

Re: TR vs DB sanity check please

**
All fields that are specified in a push
fields action are part of the TRansaction, and will therefore have a TR
value, regardless of whether or not the value has changed.

Thad Esser
Remedy Developer





From:
Tommy Morris tommy.mor...@radioshack.com

To:
arslist@ARSLIST.ORG

Date:
04/14/2010 01:48 PM

Subject:
Re: TR vs DB sanity check please

Sent by:
Action Request System discussion
list(ARSList) arslist@ARSLIST.ORG




** 
I understand how Rick put
it that the TR is implied so you dont have to specify it but why would
including the identifier cause an erroneous result? 

From: Action Request System discussion
list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Thad K Esser
Sent: Wednesday, April 14, 2010 3:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

** 
Tommy, 

In some situations, your version will evaluate to true, even though nothing
changed. 

To truly detect if a value changed, its best to use:

 'AssignedToTech' != 'DB.AssignedToTech' 


Thad Esser
Remedy Developer 




From:

Tommy Morris tommy.mor...@radioshack.com


To:

arslist@ARSLIST.ORG


Date:

04/14/2010 01:39 PM


Subject:

Re: TR vs DB sanity check please


Sent by:

Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG







Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)
_attend WWRUG10 www.wwrug.com
ARSlist: Where the Answers Are_ 
_attend WWRUG10 www.wwrug.com
ARSlist: Where the Answers Are_ 



*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed.  If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited.  Nothing in this email, including any attachment, is intended to be a legally binding signature.
*

_attend WWRUG10 www.wwrug.com  ARSlist: "Where the Answers Are"_

Re: TR vs DB sanity check please

Ok, makes sense now. Thanks for the clarification.

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Thad K Esser
Sent: Wednesday, April 14, 2010 3:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

** 
All fields that are specified in a push fields action are part of the
TRansaction, and will therefore have a TR value, regardless of whether
or not the value has changed. 

Thad Esser
Remedy Developer 

From: 

Tommy Morris tommy.mor...@radioshack.com 

To: 

arslist@ARSLIST.ORG 

Date: 

04/14/2010 01:48 PM 

Subject: 

Re: TR vs DB sanity check please 

Sent by: 

Action Request System discussion list(ARSList) arslist@ARSLIST.ORG

** 
I understand how Rick put it that the TR is implied so you don't have to
specify it but why would including the identifier cause an erroneous
result? 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of
Thad K Esser
Sent: Wednesday, April 14, 2010 3:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please 

** 
Tommy, 

In some situations, your version will evaluate to true, even though
nothing changed. 

To truly detect if a value changed, its best to use: 
'AssignedToTech' != 'DB.AssignedToTech'   

Thad Esser
Remedy Developer 

From: 

Tommy Morris tommy.mor...@radioshack.com 

To: 

arslist@ARSLIST.ORG 

Date: 

04/14/2010 01:39 PM 

Subject: 

Re: TR vs DB sanity check please 

Sent by: 

Action Request System discussion list(ARSList) arslist@ARSLIST.ORG

Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 

*IMPORTANT NOTICE: This communication, including any attachment,
contains information that may be confidential or privileged, and is
intended solely for the entity or individual to whom it is addressed. If
you are not the intended recipient, you should delete this message and
are hereby notified that any disclosure, copying, or distribution of
this message is strictly prohibited. Nothing in this email, including
any attachment, is intended to be a legally binding signature. * 

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 

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

Re: TR vs DB sanity check please

2010-04-14 Thread Grooms, Frederick W

All fields in a Push Fields action are part of the push transaction yes, but 
for a standard modify of a form if they are not changed then the TR value is 
NULL.

From the Workflow Objects PDF

- Transaction Only-References the value of the field in the current transaction 
only. If the value is not changed in the transaction, it is considered to be 
$NULL$. If the operation is a delete, it is considered to be $NULL$. To specify 
a check of the transaction only, use the format 'TR.field' when you enter the 
field name in the Run If field.

- Database Only-References the value of the field in the database only. No 
check is made of the value in the current transaction. If the operation is a 
create operation, it is considered to be $NULL$. To specify a reference of the 
database only, use the format 'DB.field' when you enter the field name in the 
Run If field.

- Transaction and Database-References the value of the field in the current 
transaction and uses that value if changed. If not changed in the current 
transaction, references the value of the field in the database. To specify a 
reference of both the transaction and the database (in this order), use the 
format 'field' when you enter the field name in the Run If field.



From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Thad K Esser
Sent: Wednesday, April 14, 2010 3:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

**
All fields that are specified in a push fields action are part of the 
TRansaction, and will therefore have a TR value, regardless of whether or not 
the value has changed.

Thad Esser
Remedy Developer

From:

Tommy Morris tommy.mor...@radioshack.com

To:

arslist@ARSLIST.ORG

Date:

04/14/2010 01:48 PM

Subject:

Re: TR vs DB sanity check please

Sent by:

Action Request System discussion list(ARSList) arslist@ARSLIST.ORG





**
I understand how Rick put it that the TR is implied so you don't have to 
specify it but why would including the identifier cause an erroneous result?

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Thad K Esser
Sent: Wednesday, April 14, 2010 3:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: TR vs DB sanity check please

**
Tommy,

In some situations, your version will evaluate to true, even though nothing 
changed.

To truly detect if a value changed, its best to use:
'AssignedToTech' != 'DB.AssignedToTech'

Thad Esser
Remedy Developer
From:

Tommy Morris tommy.mor...@radioshack.com

To:

arslist@ARSLIST.ORG

Date:

04/14/2010 01:39 PM

Subject:

Re: TR vs DB sanity check please

Sent by:

Action Request System discussion list(ARSList) arslist@ARSLIST.ORG




Instead of Runif: 'AssignedToTech' != 'AssignedToTech'

Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech'

-Original Message-
From: Action Request System discussion list(ARSList)



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

Re: TR vs DB sanity check please