Conversion between Character fields and Date fields.

2008-03-07 Thread Jerry Niman
Dear listers, I have been having an issue where I was trying to read a value from a character field into a date field. Try as I might, I couldn't get correct behaviour for years in the early part of the century (this was necessary as I was trying to capture dates of birth). I tried setting

Re: Has any one used MS SQL Express edition 2005 on arserver 7.1?

2008-03-07 Thread brian . bishop
I have Version 7.1 installed on my laptop with MS SQL express 2005. It works fine. Only issue I had was with identifying the server. My install expected \SQLEXPRESS after my laptop name which is what I used when installing SQL. It was actually easier than using full blown SQL! Brian

CMDB 2.1 Custom Attribute Permission

2008-03-07 Thread Bhagawat, Prashanth
Hi Listers, Has any one tried of giving custom permissions to the attributes of the class in CMDB. I want to add couple of new attributes to class define custom permission to those attributes , such that any user who is accessing CI from the asset management console , should have

Remedy SSO Implementation - Help needed

2008-03-07 Thread Thivagar Sankaran
Hi List, I am into the process of implementing SSO. I have the architecture as below: ARS 6.3 Windows Server 2003 Web Server - Sun Apps Server Mid Tier 6.3 I wanted to create a custom SSO. When I read into the white paper from remedy, they have asked to create a java file. I created a

Re: LDAP arplugin failure problem

2008-03-07 Thread Heider, Stephen
Maria, Another option to get around the LDAP query limitation is to create a single SQL View comprised of multiple SELECTs that are UNIONed together. You can then query this view and retrieve all LDAP entries. See the email from January 9 entitled Re: LDAP Question. There is a script

Incoming Emails

2008-03-07 Thread John Kovalcik
Listers, Does anyone know how to re-parse and incoming email ? If the incoming email has an error and you want to re-parse it after the error is corrected, how do you do it ? Thanks, John M. Kovalcik

Remedy custom SSO Implementation - Help needed

2008-03-07 Thread remprof
Hi List, I am into the process of implementing SSO. I have the architecture as below: ARS 6.3 Windows Server 2003 Web Server – Sun Apps Server Mid Tier 6.3 I wanted to create a custom SSO. When I read into the white paper from remedy, they have asked to create a java file. I created a

Re: Output of field contents to file via a filter action

2008-03-07 Thread Heider, Stephen
Fred, That's cool. I did not know that about that part of the Notify command. For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page 524. In my testing this morning I am not sure if I can use it here. I see three challenges to overcome: 1. The first 8 lines and

Re: Output of field contents to file via a filter action

2008-03-07 Thread Carey Matthew Black
Stephen, I am certain that the design intent was that there would be a process that parses the file and does the right thing with what it finds in the file. So #2 and #3 are totally by design. Also the process was envisioned as a standing server process and not something that is invoked over and

Re: Output of field contents to file via a filter action

2008-03-07 Thread Heider, Stephen
Carey, Precisely. Thanks for the confirmation. I don't think I can make use of this command for the purpose of creating a file from the contents of an ARS field. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: LDAP arplugin failure problem

2008-03-07 Thread Maria C Delagarza
Thanks for the great advice! I knew I could count on smart people J As it turned out we did not have enough qualifications in the Vendor form table properties. When we limited the table properties to A-E etc as some of you suggested we were able to retrieve all of the records in 5 escalations.

Remove duplicate email address from a String

2008-03-07 Thread Darshana Jivan [MTN Network Solutions]
Hi, Please can someone assist me with the following. I want to remove duplicate email addresses in a string. I cannot create a view with the distinct values as I need the unique id's of the record therefore the only option I do have is to try and remove duplicate occurrences after the 1st

Re: Change Templates ITSM7

2008-03-07 Thread T. Dee
Don - on the Change Template there is the field Notes, which will populate Notes on the Change Form - will this be sufficient for their request? Ty On Thu, Mar 6, 2008 at 12:28 PM, Don Simmons [EMAIL PROTECTED] wrote: ** Has anyone attempted to or been requested to add Work Info information

Re: Remove duplicate email address from a String

2008-03-07 Thread Frank Caruso
Why don't you try checking for the occurrence of the new email address in the string BEFORE you concatenate it. If you find the email address is already in your string then do not add it and move to the next record in your table. On Fri, Mar 7, 2008 at 9:34 AM, Darshana Jivan [MTN Network

Re: Change Templates ITSM7

2008-03-07 Thread Don Simmons
No that would not work. They don't want to use Task. The want the get the Install Plan, etc. with attachments to be part of the templates. They have documents that are reused for hundreds of servers where the same change is being made multiple times. Date: Fri, 7 Mar 2008 09:36:23 -0500

For anyone using the aradmin.exe command

2008-03-07 Thread Scott Philben
We found out an interesting bit of information yesterday about the command line uasge of the aradmin.exe command. On page 557 of the 6.3 Advanced book Remedy claims the following: To parse an XML packing list, and export all the objects defined in that packing list, use the following command

Find a field by ID

2008-03-07 Thread SUBSCRIBE arslist Melissa
This may be a silly question, but how can I find a field by the ID number if it's not in the view? Looking for a field on HPD:HelpDesk by the Field ID and it's not in the FindID drop down. Thanks! Melissa ___

Re: Remove duplicate email address from a String

2008-03-07 Thread Opela, Gary L Contr OC-ALC/ITMA
Darshana, You are doing about what I was going to suggest whenever I read your original post. I was thinking something like the following though: Lets say that $MTNNS$ contains the following: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], Step 1: Set Fields:

Re: Find a field by ID

2008-03-07 Thread Seth Wrye
Check the admin view... Form - Select a View in the admin tool. Seth Wrye From: Action Request System discussion list(ARSList) on behalf of SUBSCRIBE arslist Melissa Sent: Fri 3/7/2008 10:04 AM To: arslist@ARSLIST.ORG Subject: Find a field by ID ** This may

Re: Find a field by ID

2008-03-07 Thread Ben Cantatore
Melissa, Just do the following: Go into the form you want to find the field on Select Form\current view\fields in view from the menu Highlight all the fields on the left and then click add this will push them all to the right side Click ok You'll have a mess in the upper left hand corner of

Re: Find a field by ID

2008-03-07 Thread Gidd
Melissa, Try this FREE utility from David Sanders' website: http://www.westoverconsulting.co.uk/utilities.html Form and Field Property Viewer Allows you to view database table names and field IDs from within the User tool HTH Regards...Gidd _ From: Action Request System

Re: Find a field by ID

2008-03-07 Thread Mary Dollus
Hi Melissa, I sort of do the same thing as Ben with one exception. I do a new view and pull all the fields into it. That way if something inadvertently crashes or messes up, I don't have to worry about it affecting the main form. Take care, Mary Dollus generationE Technologies

Re: Conversion between Character fields and Date fields

2008-03-07 Thread Jerry Niman
Roy, Thanks, but I already have a work-round - I am looking for support to encourage BMC to provide the functionality as native. Jerry Jerry NimanTel+44 (0)161-247 1474 Head of Information and Communication Technology Services Email [EMAIL

7.1 Java api

2008-03-07 Thread Axton
Has anyone implemented mid-tier 7.1 or other j2ee apps based on the 7.1 java api in a load balanced environment? If so, can you comment on your successes/issues without using persistent sessions on the load balancer? Thanks, Axton Grams

Re: Find a field by ID

2008-03-07 Thread Ben Cantatore
Mary, good suggestion. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Mary Dollus [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/07/2008 10:32 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Find a

Re: Find a field by ID

2008-03-07 Thread Seth Wrye
Melissa, I would avoid the two suggestions because of the implications involved with the what if's. Since the form you are searching on (HPD:HelpDesk) is an OOTB form, all OOTB fields will be listed in the Administrator view. From there you can add the field to another view, but I would be

Re: Find a field by ID

2008-03-07 Thread Seth Wrye
Ahh, I miss arstruct. Seth Wrye From: Action Request System discussion list(ARSList) on behalf of Gidd Sent: Fri 3/7/2008 10:28 AM To: arslist@ARSLIST.ORG Subject: Re: Find a field by ID ** Melissa, Try this FREE utility from David Sanders'

Re: Find a field by ID

2008-03-07 Thread Opela, Gary L Contr OC-ALC/ITMA
Why not just run a def of the form, then search through it for the field ID? Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Seth Wrye

Re: Find a field by ID

2008-03-07 Thread SUBSCRIBE arslist Melissa
Acutally that's not true. There are many many fields that are not in the admin view on the HPD:HelpDesk. Seth Wrye [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/07/2008 09:50 AM Please respond to arslist@ARSLIST.ORG To

Re: Find a field by ID

2008-03-07 Thread Seth Wrye
As far as I know, If its an OOTB field it should be on the Admin View (that is unless the form has been modified). Otherwise, I would take Gary's advice and pull a deff. Either way, I would avoid creating new views or adding all fields to a view on a production environment (unless this is a

Re: UNSUBSCRIBE

2008-03-07 Thread Sanford, Claire
Susan like Pat Zandi can never leave us!!! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, March 06, 2008 7:52 PM To: arslist@ARSLIST.ORG Subject: Re: UNSUBSCRIBE ** Susan, I thought

Re: Change Templates ITSM7

2008-03-07 Thread T. Dee
What about adding the attachment to the task - you can add attachment to Tasks. Then when the Task is added to the Change they will see the attachment. Does that help? Ty On Fri, Mar 7, 2008 at 9:50 AM, Don Simmons [EMAIL PROTECTED] wrote: ** No that would not work. They don't want to use

Re: Find a field by ID

2008-03-07 Thread Mary Dollus
Hi Seth, I should have clarified it a bit. I don't actually save the view, it's rare I need to do that so I just create the new view but then do not save. Does that create performance issues too? - Mary P.S. I miss arstruct too!! I used it religiously it was my favorite tool

Re: Find a field by ID

2008-03-07 Thread Pierson, Shawn
If you just need to know the name and what views it is in, I would just run something like this in SQL: select f.fieldid, f.fieldname, s.[name] as formname, v.vuiname as viewname from field f inner join arschema s on s.schemaid = f.schemaid inner join vui v on

Re: Find a field by ID

2008-03-07 Thread Opela, Gary L Contr OC-ALC/ITMA
You beat me to it! I was milling through the database looking at Create Table statements trying to find which table linked the field ID up with the View ID, then I was going to compose something like what you did. Man, I was just too slow! I feel inferior now :\ I couldn't find field_dispprop soon

Re: Find a field by ID

2008-03-07 Thread Seth Wrye
Only if you hit save. But. there are times when we are working to resolve something, faster than we should and out of habit or just on accident hit save (I don't know many developers that haven't made that mistake). I try to avoid it all together unless I'm in a dev environment and

Issue with OpGetList web service

2008-03-07 Thread Ibrahim Akar
I have created three web services against CTM:People. OpCreate, OpGet and OpGetList. The web services work fine with the exception of OpGetList. It partially works in that it only returns one record instead of the dozens that I am expecting. I am thinking it might have to do with -

Re: Find a field by ID

2008-03-07 Thread Mary Dollus
Oh yep!! And I was also speaking of dev... but so true.. I try to avoid anything on prod if at all possible! :) ya just never know what can happen Thanks Seth - Mary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Seth

Multiple Hosts in Area Ldap

2008-03-07 Thread SUBSCRIBE arslist Melissa
How can I set up multiple hosts in Area Ldap configuration? We are using ARS 7.01 Thanks! Melissa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the

Re: UNSUBSCRIBE

2008-03-07 Thread Susan Palmer
lol ... sometimes I cannot skip a chance for a smarta*s response On Fri, Mar 7, 2008 at 10:11 AM, Sanford, Claire [EMAIL PROTECTED] wrote: ** *Susan like Pat Zandi can never leave us!!!* -- *From:* Action Request System discussion list(ARSList) [mailto:

Re: who can advice on new features of version 7

2008-03-07 Thread Michelle L
Hi, Serouche: You do not have to do a full blown upgrade to take advantage of this feature. One can remain on ARS 6.3 for example and use a 7.x Mid-Tier to take advantage of this. All you would need is for someone to send you the def file for saved searches and import it into your ARS 6.3

7.1 Thread weirdness

2008-03-07 Thread William Rentfrow
We defined multiple escalation threads in 7.1 - we added one thread. We have 1,000,000 people records in CTM:People in IM. We are testing our delete strategy which does the following: 1.) Escalation sets certain record status to Delete 2.) Filter deletes record with APPLICATION-DELETE-ENTRY Run

Re: who can advice on new features of version 7

2008-03-07 Thread Carey Matthew Black
Michelle, I have never tried that before so I wonder That may fix the v7.x web clients use of saved searches, but how does that effect the v6.3 User Tools use of saved searches? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach

Re: For anyone using the aradmin.exe command

2008-03-07 Thread Scott Philben
Yeah, we actually tried this little task with both a def file and an XML file created in the Admin tool from a packing list. No dice on either. It did work when I referenced a non-existent file at one point... But that just took a long time and then gave me a definition file with everything

Re: Remove duplicate email address from a String

2008-03-07 Thread Thad K Esser
Darshana, Along the lines of Frank's suggestion, how about the following: In your AL that does the looping: Set Fields, SQL: SELECT CONTACT_EMAIL FROM [EMAIL PROTECTED] WHERE CONTACT_ID = '$Col_C_ContactID$' MTNNS_primary_client_contact_email =

Re: Remove duplicate email address from a String

2008-03-07 Thread Thad K Esser
Darshana, I just realized I didn't actually answer your question. Your Set Fields 3: Set Fields 3: REPLACE($MTNNS_primary_client_contact_email$, SUBSTR($MTNNS_primary_client_contact_email$, $Val1$, $Val2$), ) doesn't work because $Val2$ is storing the length of the email

Re: UNSUBSCRIBE

2008-03-07 Thread Darrell Reading
Let me share with the list what I did a number of years ago in direct relationship to the subject above and trying to be a smarta*s. Please don't laugh at me too hard, but you can log this as Friday Humor is you like. As I stated, it was many years ago, and people were still trying to

Re: Users of Remedy Knowledge Management 7.1 Patch

2008-03-07 Thread Joe D'Souza
We have a development environment at this customer site but their policies do not let us 'try' a new version for the sake of trying it. So until they do decide they have the time (and money) to go upto 7.2, I cannot try it, unless we come across something that's a show stopper in 7.1, and that is

Re: Remove duplicate email address from a String

2008-03-07 Thread Thad K Esser
Sorry folks, OCD is kicking in. :-) Darshana, If you were to get the same email address for three or more iterations in a row, you'd end up with triple commas, which isn't accounted for in my original post. Its probably best to clean up the double commas as you go, thereby ensuring we never

Re: UNSUBSCRIBE

2008-03-07 Thread Warren Baltimore
Gee Darrell, Guantanomo is so nice this time of year! Warren On 3/7/08, Darrell Reading [EMAIL PROTECTED] wrote: ** *Let me share with the list what I did a number of years ago in direct relationship to the subject above and trying to be a smarta*s. Please don't laugh at me too hard, but

OT:Friday Befuddlement

2008-03-07 Thread J.T. Shyman
I ran across this one yesterday and it had me laughing. For those of you that have MS Word 2003.open a document, type the word information and ask it for synonyms or look them up in the built-in thesaurus. Then, realize that this fits perfectly with Microsoft's corporate vision. ---

Re: Friday Befuddlement

2008-03-07 Thread Opela, Gary L Contr OC-ALC/ITMA
Wow, that was funny. It took a guy sitting beside me to figure out why MS listed the list they listed.. I just caught that it didn't make any sense. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System

Re: Remedy SSO Implementation - Help needed

2008-03-07 Thread Tim Richardson
Hello Thivagar, Yes, I am doing this for version 7 and while I don't have everything working yet, I did run into this problem and solved it. Try adding MidTier.jar to your classpath. My execution looks like this: javac -classpath arapi71.jar:MidTier.jar:.

Daylight Saving Time - in AR

2008-03-07 Thread Andrew Fremont
Hi, Since the DST is coming this weekend, I'm not sure if there is any affect/change we need to do on the AR server? I think AR just relies on the OS to fix it out, but want to double check. We have two servers with AR 6.3 patch 20 7.0.1 patch5. Thanks, AF

Re: Daylight Saving Time - in AR

2008-03-07 Thread Nall, Roger
That should have been done last year as this is year two of the new dates. If you did not have any problems in the fall you should be okay. That means you are patched. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM

Re: Daylight Saving Time - in AR

2008-03-07 Thread Easter, David
Tech Bulletins on DST are posted at Support Central: 7.0.01: http://www.bmc.com/supportu/documents/87/89/68789/68789.pdf 6.3: http://www.bmc.com/supportu/documents/87/90/68790/68790.pdf The only issue not addressed at your present patch level is this: The following defect is a known issue in

Re: Find a field by ID

2008-03-07 Thread strauss
Be careful when you get to ITSM 7 (where HPD:HelpDesk becomes HPD:Help Desk). There is no administrator view, and the closest thing to it is the Default User View, from which you can see that over 400 fields in the form are not instantiated in ANY view!! Christopher Strauss, Ph.D. Call Tracking

Re: OT:Friday Befuddlement

2008-03-07 Thread Joanne Mansur
FYI - Does the same thing in Word 2007. Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] J.T. Shyman [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/07/2008 02:17 PM Please

Re: Friday Befuddlement

2008-03-07 Thread Joe D'Souza
I have Word 2000... does it work with that? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Friday, March 07, 2008 2:24 PM To: arslist@ARSLIST.ORG Subject: Re: Friday Befuddlement Wow, that

Re: OT:Friday Befuddlement

2008-03-07 Thread John Atherly
For us with different version what does it say? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Joanne Mansur [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/07/2008 03:49 PM Please

Re: OT:Friday Befuddlement

2008-03-07 Thread Darrell Reading
Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]

Re: OT:Friday Befuddlement (U)

2008-03-07 Thread Hennigan, Sandra H CTR OSD-CIO
UNCLASSIFIED Word provides the synonym for in formation Meaning - in order With suggested replacements: In order In sequence In turn In rank In a row Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x248 Apparently, there is nothing that cannot happen today. Mark

Re: OT:Friday Befuddlement

2008-03-07 Thread J.T. Shyman
Probably the same thing. I just think its quite funny that technology can be so smart and yet so brainless at the same time. Providing synonyms for In Formation (instead of Information) does sort of follow Microsoft's view of the world, doesn't it?: You'll do it our way and like it. ---

Re: OT:Friday Befuddlement (U)

2008-03-07 Thread [EMAIL PROTECTED]
Lists the same words for Word 2002. Technically correct but functionally unusable. Dave Hennigan, Sandra H CTR OSD-CIO [EMAIL PROTECTED] wrote: UNCLASSIFIED Word provides the synonym for in formation Meaning - in order With suggested replacements: In order In sequence In turn In rank In a

Using employee ID to log into Remedy (instead of name)

2008-03-07 Thread Rick Westbrock
Happy Friday, hopefully someone out there has run into this issue already and can offer some advice. Our company is getting close to implementing ITIM (IBM Tivoli Identity Management) for the enterprise which means that instead of logging in with my name (rickw) I will be forced to log into the

Re: Using employee ID to log into Remedy (instead of name)

2008-03-07 Thread Carey Matthew Black
Rick, Maybe. ARS lets use authenticate as a different user name than what the user enters in the Login Name field via the 'Authentication Login Name' field on the User form. So you could use that feature to set the employee ID number as the authentication user name and leave the ARS 'Login Name'

Re: Using employee ID to log into Remedy (instead of name)

2008-03-07 Thread Rick Westbrock
Thanks Carey, I consider the user experience very important and if I can pull this off it will go a long way towards resolving my problems. The users won't have any choice but to key in their number when logging into the domain and Remedy but if they can see actual names once within Remedy that

Re: Users of Remedy Knowledge Management 7.1 Patch

2008-03-07 Thread strauss
Good news! Support sent me patch 1610 to debug with, since it has higher resolution logging. I was able to determine that it was a access control group error, not an authentication problem, and fix it. We had added a named access control group of 'UNT Customers' to the access control list

Re: Users of Remedy Knowledge Management 7.1 Patch

2008-03-07 Thread Joe D'Souza
Chris, You could still keep your indexes and your RKM access control group with the name UNT Customers.. But map that to a Role instead of a group and map that Role to the ID 16. What I would do is create a Role with Role ID -16 and the Role Name as UNT Customers To have this new

Problems with AR System Server 7.1 installation

2008-03-07 Thread Masha Bench
Hi Everyone, I am, what you would say, brand new to Remedy and excited to get 7.1 working sometime soon. :) Currently we are running Remedy 6.x, that is doing its job fine but I am having problems with brand new installation of 7.1 and BMC Support is not being very helpful. Here is the deal:

Re: 7.1 Java api

2008-03-07 Thread LJ Longwing
Well...I haven't personally experienced this, but based on the reading that I have done on load balancing, and client connections, you can't do it reliably without persistent sessions (sticky bits) because the server expects you to already have a session active, so you can't just issue a command

Re: For anyone using the aradmin.exe command

2008-03-07 Thread LJ Longwing
Carey, I'm actually working on a VERY SIMPLE program that could do just what your looking for, the API parsing of a packing list is absurdly easy, so if you wanted with a very small modification to my program, you could specify packing list on server 1, and export the objects from server2, and

Re: Problems with AR System Server 7.1 installation

2008-03-07 Thread LJ Longwing
is your ARAdmin account password the default? If not, have the DBA change it to the default, and try again, ensure that you don't have anything in our ar.conf/ar.cfg file regarding the DB password, once connected you can set the password in the DB through the admin tool/admin console in the user