Date/Time Fields

2010-04-14 Thread Coleman, Gavin
Hi List - I've got a question that I hope is really simple! We have had several users complaining that when they click on the ellipsis (the three dots) on a Date/Time field, the Date/Time dialog box opens up and the time portion is displayed as 00:00:00. Other people have said that when they

Re: Date/Time Fields

2010-04-14 Thread Konrad Banasiak
Hi, If you want to be sure, create active-link with set-field action, where date will be changed to present time. Cheers Konrad TopPositions Really only one secure Plugin SSO for BM Remedy AR System. Http://www.remedy-sso.com From: Action Request System discussion

Problems creating LDAP Vendor forms

2010-04-14 Thread Sergio Tomillero
Hello, Creating a vendor form, I indicate the next in vendor properties: //LDAP_DIRECTORY_SERVICE_HOST/BASE_DN??sub?(objectclass=OrganizationalPerson) 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

Re: DR Recovery

2010-04-14 Thread Pat Zandi
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

Re: incoming mail not working properly

2010-04-14 Thread Nair, Rajesh IN BOM SISL
Hi After lot of modification system atlast started except the mails. But now i am getting this error in the log Apr 14, 2010 5:01:10 PM com.remedy.arsys.emaildaemon.LoggingModule doWork SEVERE: You must have a Help Desk Fixed License to modify case information. Apr 14, 2010 5:07:15 PM

Re: Remedy Developer Plus

2010-04-14 Thread Warren Baltimore
That sounds right! On Tue, Apr 13, 2010 at 7:35 PM, Joe D'Souza jdso...@shyle.net wrote: ** Are you referring to the minimum startup and max memory that java heap would be using? Joe -Original Message- *From:* Action Request System discussion list(ARSList) [mailto:

Extracting digits from a character field

2010-04-14 Thread Atul Vohra
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

Benefit of Prefetch Remedy midtier 7.1

2010-04-14 Thread remedy lee
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

Re: Extracting digits from a character field

2010-04-14 Thread Misi Mladoniczky
Hi, I would probably loop through the whole string. There are several ways to do this, and if the text is not too big, this could be a way to do it using three filters in a filter-guide. run-if() set-fields tmpStr = $string$ tmpStrDigits = $NULL$ #loop runif('tmpStr' LIKE [0-9]%) #

Re: Benefit of Prefetch Remedy midtier 7.1

2010-04-14 Thread Rick Cook
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

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

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,

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

Re: Extracting digits from a character field

2010-04-14 Thread Joe D'Souza
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

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

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:

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)

Re: ARX Files from MidTier

2010-04-14 Thread Joe D'Souza
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

Re: Extracting digits from a character field

2010-04-14 Thread Joe D'Souza
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:

Re: Problems creating LDAP Vendor forms

2010-04-14 Thread Joe D'Souza
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

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

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

Re: Extracting digits from a character field

2010-04-14 Thread Joe D'Souza
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)

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

Location data in 7.5

2010-04-14 Thread Thad K Esser
** 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

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

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

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

Re: Location data in 7.5

2010-04-14 Thread Rick Cook
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

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

Re: Location data in 7.5

2010-04-14 Thread Thad K Esser
** 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:

Re: Location data in 7.5

2010-04-14 Thread Rick Cook
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

Re: Strage issue

2010-04-14 Thread Joe D'Souza
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

Re: Extracting digits from a character field

2010-04-14 Thread Joe D'Souza
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

Re: Service-now.com

2010-04-14 Thread Joe D'Souza
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:

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

Re: Location data in 7.5

2010-04-14 Thread Thad K Esser
** 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.

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.

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)

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

Re: TR vs DB sanity check please

2010-04-14 Thread Tommy Morris
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:

Re: TR vs DB sanity check please

2010-04-14 Thread Rick Cook
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

Re: TR vs DB sanity check please

2010-04-14 Thread Thad K Esser
** 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

Re: TR vs DB sanity check please

2010-04-14 Thread Tommy Morris
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

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

Re: TR vs DB sanity check please

2010-04-14 Thread Tommy Morris
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

Re: TR vs DB sanity check please

2010-04-14 Thread Thad K Esser
** 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

Re: TR vs DB sanity check please

2010-04-14 Thread Tommy Morris
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

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

Re: TR vs DB sanity check please

2010-04-14 Thread Thad K Esser
** The TR value is also NULL if the field on the form was cleared. So in that case, the TR value is null, and the value has changed. There's just too many variations and gotchas to make using the TR value worthwhile. IMO. :-) Thad Esser Remedy Developer From: Grooms, Frederick W

Re: TR vs DB sanity check please

2010-04-14 Thread Drew Shuller
Oops. I typed the email wrong. I've tried the Run If as been both 'TR.AssignedToTech' != 'DB.AssignedToTech' and without the TR in the first instance. I'm running a Notify action. I do get inconsistent results. drew ___

Re: Date/Time Fields

2010-04-14 Thread Dennis Ruble
Gavin, We ran into this some months ago as we were upgrading to aruser 7.5. I just wrote it off to a new feature of 7.5. I'd be interested too if there's a fix for it. Thanks, Dennis Coleman, Gavin gavin.cole...@computacenter.com Sent by: Action Request System discussion list(ARSList)

Tool suggestion

2010-04-14 Thread lakhes
Hi Listners, I needed some Tool recommendations to slove the problem that we are having We use Remedy 6.3 ARS and Customer support module 5.6. We have asset which we track with issues and we can relate asset to issue. Now our eng usually log on to customer site via SHS and try to solve problem

KB tool

2010-04-14 Thread lakhes
Hi listners, Does anyone intergrated any KB tool with remedy ? Any recommendations? Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Tool suggestion

2010-04-14 Thread Roger Justice
CMDB can do this. The problem you will have is that you would need to upgrade to ARS 7.1 or 7.5 to get a supported version of CMDB. -Original Message- From: lakhes lak...@gmail.com To: arslist@ARSLIST.ORG Sent: Wed, Apr 14, 2010 7:33 pm Subject: Tool suggestion ** Hi Listners, I

Re: KB tool

2010-04-14 Thread Roger Justice
There were a couple that could be integrated with 6.3. Since you already asked about Assets being viewed with dependencies if you go to a later version of ARS you could review if Remedy Knowledge Management could be itegrated with a customization. -Original Message- From: lakhes

Re: KB tool

2010-04-14 Thread David Drake
Remedy's RKM is the best From: Action Request System discussion list(ARSList) on behalf of lakhes Sent: Wed 4/14/2010 4:35 PM To: arslist@ARSLIST.ORG Subject: KB tool ** Hi listners, Does anyone intergrated any KB tool with remedy ? Any recommendations?

Re: incoming mail not working properly-update

2010-04-14 Thread Nair, Rajesh IN BOM SISL
Hi After lot of modification system atlast started except the mails. But now i am getting this error in the log Apr 14, 2010 5:01:10 PM com.remedy.arsys.emaildaemon.LoggingModule doWork SEVERE: You must have a Help Desk Fixed License to modify case information. Apr 14, 2010 5:07:15 PM

Re: TR vs DB sanity check please

2010-04-14 Thread Misi Mladoniczky
Hi, ('AssignedToTech' != 'DB.AssignedToTech') will allways detect a change. ('AssignedToTech' != 'DB.AssignedToTech' AND 'AssignedToTech' != $NULL$) when you want to check for a change to a non-null-value. The execution order of your filters, and filter phasing, may play tricks with you. A