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 reforma

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
stead of "mm", you will get > > If your field $Field With Month As A Number$ is not > an > integer, you will have to play around to get this to > work. > > Thad's idea is a supertb one for general CASE > functions, when you are dealing with values other >

Re: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
[EMAIL PROTECTED] 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 l

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: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
dy Skilled 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: > This does not work > > SELECT C53687

Re: Is a Case function possible in Remedy?

2007-11-15 Thread Joran, Peter P, CTR, OSD-CIO
M, Eric Cleereman (IT) > > <[EMAIL PROTECTED]> wrote: > > > Hi Pete, > > > > > > Here are a couple options: > > > > > > 1. If your DB supports Case, you can do a set > > fields using SQL. > > > 2. You can store th

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 ARS

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 was

Re: VOTE NOW! Don't skip this!! All relevant info in this post.

2007-10-04 Thread Joran, Peter P, CTR, OSD-CIO
> MVP Nominees: [choose one] > --- > > Frederick W. Grooms > > > 3rd party product [choose or not choose] > --- > Aeroprise > > > > 3rd party Utility-Freeware [choose or not choose] > - > RRR various free utilities > > >

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 frame

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 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, Si

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 anyo

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 Matth

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: Acti

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 Answer

Re: Full Time Remedy Developer - ATLANTA GA (U)

2007-03-20 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED ITIL aligned implies (ITIL is a best practice not a standard or a rule) that the custom application is a component of the business process architecture of the enterprise architecture and that the application has been defined by a detailed process flow chart and is needed in support of

Re: Full Time Remedy Developer - ATLANTA GA (U)

2007-03-20 Thread Joran, Peter P, CTR, OSD-CIO
UNCLASSIFIED ITIL is not certifiable as application nor can an organization be ITIL certified. Individuals can be certified. ITIL is the process model for ISO2 (an IT Service Standard), and as such an organization can be ISO2 certified. The ISO2 adds governance compliance controls and

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

2007-03-15 Thread Joran, Peter P, CTR, OSD-CIO
eep the bottom line from looking anemic. In the end, there's nothing left but the name and the dim memory of what used to be. "Will the last one out of the building please turn out the lights?" --Tim

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 the

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 6:3

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: Wednesd

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 To

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 server

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 h

Re: Filters not reading SHR:People

2006-11-01 Thread Joran, Peter P CTR OSD CIO
d look for SHR:People filters that fire on Get Entry.   If that's not the case, can you clarify the problem? Thad"Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Joran, Peter P CTR OSD CIO" <[EMAIL

Filters not reading SHR:People

2006-11-01 Thread Joran, Peter P CTR OSD CIO
Title: Message ** All There are filters that that read 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
the top of my head, anyway... > > Mike White > Office: 813-978-2192 > E-mail: [EMAIL PROTECTED] > > > > "Joran, Peter P > CTR OSD CIO" To: arslist@ARSLIST.ORG >

Re: Query question

2006-10-19 Thread Joran, Peter P CTR OSD CIO
results, probably in a table? In that case you could sort the records based on the timestamp and limit the chunk size to 5.. George On 10/19/06, Joran, Peter P CTR OSD CIO <[EMAIL PROTECTED]> wrote: > ** > > All > This seems like a very simple question but I'm stumped. >

Query question

2006-10-19 Thread Joran, Peter P CTR OSD CIO
Title: Message ** All This seems like a very simple question but I'm stumped. How can I return just the oldest 5 records from a query? It's a metric  that is almost useless but the customer is not budging.   Many Thanks! Pete __20060125___This posting was submitted with H

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 Serv

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, Sep