How to partially mask a field

2007-12-10 Thread Joran, Peter P, CTR, OSD-CIO
All I need to mask the first two octets of our IP addresses. It gets a little complicated as an IP address length varies. For example an IP address could be 1.1.1.1 or 123.123.123.123. Is there a way to do a SUBSTR type of function that can start after the second .? I'm trying to avoid

Re: Trouble with external table qualification using != $NULL$ on enum field

2007-12-03 Thread Joran, Peter P, CTR, OSD-CIO
Have you tried using $/NULL$ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Albert Bihler Sent: Monday, December 03, 2007 12:27 PM To: arslist@ARSLIST.ORG Subject: Trouble with external table qualification using != $NULL$ on

Re: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joran, Peter P, CTR, OSD-CIO Sent: Tuesday, November 13, 2007 11:30 AM To: arslist@ARSLIST.ORG Subject: Is a Case function possible in Remedy? All Is there a way to do a case function

Re: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
possible in Remedy? Make your Where clause WHERE C1 = '$C1$' Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joran, Peter P, CTR, OSD-CIO Sent: Thursday, November 15, 2007 9:03 AM To: arslist@ARSLIST.ORG Subject: Re

Re: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Nov 15, 2007 10:02 AM, Joran, Peter P, CTR, OSD-CIO [EMAIL PROTECTED] wrote: snip This does not work SELECT C536870937, CASE WHEN

Re: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
] On Behalf Of Joran, Peter P, CTR, OSD-CIO Sent: Thursday, November 15, 2007 9:21 AM To: arslist@ARSLIST.ORG Subject: Re: Is a Case function possible in Remedy? Tried that too Fred. Thanks for the thought Pete -Original Message- From: Action Request System discussion list(ARSList) [mailto

Re: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
. Thad's idea is a supertb one for general CASE functions, when you are dealing with values other than months. Very clever. --- Joran, Peter P, CTR, OSD-CIO [EMAIL PROTECTED] wrote: I thought I tried that, but evidently not. It works!! Many Thanks Fred! Pete -Original

Is a Case function possible in Remedy?

2007-11-13 Thread Joran, Peter P, CTR, OSD-CIO
All Is there a way to do a case function, or something like it, in remedy for a set fields action? For example: If 1 than January If 2 than February... Thanks Pete ARS 6.3 SQL Server 2000 ___ UNSUBSCRIBE or access

Re: Friday - Yes humor A Preschool Quiz.....are YOU smarter?

2007-10-12 Thread Joran, Peter P, CTR, OSD-CIO
Staying within the education theme... Remember when our grandparents, great-grandparents, and such stated that they only had an 8th grade education? Well, check this out. Could any of us have passed the 8th grade in 1895? This is the eighth-grade final exam from 1895 in Salina, KS, USA. It

Re: OT -- Sort Of: Computerworld reports on ITIL

2007-09-20 Thread Joran, Peter P, CTR, OSD-CIO
Common sense, simplicity and clarity rule or at least they should. Identify the problem or need, define the solution and keep it practical, simple, reliable, intuitive, scaleable and cheap! Buy or build is another topic. Part of working the solution is looking at frameworks (ITIL CMMI, COBIT,

Re: OT -- Sort Of: Computerworld reports on ITIL

2007-09-20 Thread Joran, Peter P, CTR, OSD-CIO
Sent w/o the signature this time Common sense, simplicity and clarity rule or at least they should. Identify the problem or need, define the solution and keep it practical, simple, reliable, intuitive, scaleable and cheap! Buy or build is another topic. Part of working the solution is looking

Re: OT -- Sort Of: Computerworld reports on ITI

2007-09-20 Thread Joran, Peter P, CTR, OSD-CIO
Third time is a charm :-\ Common sense, simplicity and clarity rule or at least they should. Identify the problem or need, define the solution and keep it practical, simple, reliable, intuitive, scaleable and cheap! Buy or build is another topic. Part of working the solution is looking at

Re: FAQ for Customer enforced licensing model in AR System 7.1.00 part I (U)

2007-08-15 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED Sweet!!! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Wednesday, August 15, 2007 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: FAQ for Customer enforced licensing model in AR System 7.1.00

Re: Solaris ARServer Installer - 7.0.1 patch 3 (U)

2007-08-06 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED Try using a 32 bit Oracle client. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Monday, August 06, 2007 10:39 AM To: arslist@ARSLIST.ORG Subject: Solaris ARServer Installer - 7.0.1 patch 3 Has

Re: BMC Rant (U)

2007-06-13 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED I think there was a Laura Esquibe that worked support. I think this is a login name of someone who must have passed it on internally. Just a guess. Pete -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey

Re: Goodbye - ALFRED (U)

2007-06-07 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED Alfred You lived and set the example of professionalism, on every occasion, for which I am very grateful!! Many, many thanks Alfred for all your help and patience and I wish you the very best in your retirement. Cheers to you Alfred Peter Joran -Original Message- From:

Max filters question (U)

2007-03-29 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED All If anyone can tell me get/log the number of filters executed per operation I would be grateful. Many Thanks! Pete ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the

Re: Who's in charge of support at BMC? (U)

2007-03-15 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED This has been going on long enough. There seems to be a lack of planning and stakeholder analysis. Perhaps the time is right for a signed petition listing the issues, demanding change and requiring that BMC address the problems at RUG. What a painful post. It's right there with

Re: Who's in charge of support at BMC? (U)

2007-03-15 Thread Joran, Peter P, CTR, OSD-CIO
and the dim memory of what used to be. Will the last one out of the building please turn out the lights? --Tim - Original Message From: Joran, Peter P, CTR, OSD-CIO [EMAIL PROTECTED] To: arslist

Re: RPC: Rpcbind failure - RPC: Timed out (U)

2007-03-14 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED Try restarting /etc/rpcbind stop|start (on solaris this is the correct path and name but for AIX I'm not sure) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, March 14, 2007

Remedy Position: Northern Virginia (U)

2007-01-11 Thread Joran, Peter P CTR OSD CIO
UNCLASSIFIED CACI has a need for a FT TS/SCI cleared Remedy developer in Reston/Herndon area of Northern Virginia. Knowledge of Solaris, Oracle and ITSM 6 are a plus. Please send resumes to Peter Joran at [EMAIL PROTECTED] Only cleared candidates will be considered. Many Thanks Pete

Re: Mid-Tier config question

2006-12-06 Thread Joran, Peter P CTR OSD CIO
You may want to consider going to patch 13 or better for your 6.3 mid-tier because caching problems (not all fields would display) were corrected. Pete -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent:

Re: Login issue after domain change

2006-12-05 Thread Joran, Peter P CTR OSD CIO
All Please excuse my late response. Adding the Authentication String field (118) worked. Many Thanks!! Pete -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joran, Peter P CTR OSD CIO Sent: Monday, November 27, 2006 4:30 PM

Login issue after domain change

2006-11-27 Thread Joran, Peter P CTR OSD CIO
All Users and their PCs that have been migrated to a different domain can no longer login to Remedy unless the new domain name is entered in the Authentication field of the Remedy login screen. We are not using LDAP but do have 'Cross Ref Blank Password' selected in server configuration. The

OT: Friday Humor

2006-11-17 Thread Joran, Peter P CTR OSD CIO
Old and not Remedy but still a lesson and still funny. Careless Coding Causes Killer Kangaroos The following apparently appeared in the June 15, 1999 Defence Science and Technology Organisation Lecture Series, Melbourne, Australia, and staff reports. The reuse of some object-oriented code

Filters not reading SHR:People

2006-11-01 Thread Joran, Peter P CTR OSD CIO
Title: Message ** All There are filters that thatread values from SHR:People and populate fields in another forms. No problems until last week. Nothing to my knowledge has changed. No filter will perform the function now, custom or OOB).I created a test form and test filter to no avail. An

Re: Query question

2006-10-20 Thread Joran, Peter P CTR OSD CIO
: 813-978-2192 E-mail: [EMAIL PROTECTED] Joran, Peter P CTR OSD CIO To: arslist@ARSLIST.ORG Peter.Joran.ctr@cc: OSD.MIL Subject: Re: Query question

email plug-in problem

2006-10-12 Thread Joran, Peter P CTR OSD CIO
Title: Message ** All Our email plug-in stops working and notifications don't go out. The work around is to stop and start the service.Restarting the service has no affect. Has anyone seen this? All thoughts and ideas gratefully accepted Many Thanks!! Pete ARS 601 P1380 Win 2003 Server

Re: HBR is back and a question on ServiceDesk 7. (U)

2006-10-02 Thread Joran, Peter P CTR OSD CIO
** UNCLASSIFIED Howard I was unaware you were no longer with Remedy. Thanks for your excellent help in the past and I wish all the best with CedarCrestone!! Pete From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richter, HowardSent: Friday,