Re: SLA to measure response did not FIRE
Dear ARSlister , Can anyone assist. Need your advice pls. I had created an SLA to measure the response time. If it fails, it will set value to a field and trigger an email out. However all these action in the SLA milstone did not work. Kindly assist why this is so. I had inserted the screen capture of my SLA . It's qualification and milestone. Pls see attached screen. P.S I actually had done a screen shot of this SLA but unable to submit thru here. How can it be sent to you guys? AR System : ARS 6.3 Helpdesk :6.0 SLA :6.0 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ UOB EMAIL DISCLAIMER Any person receiving this email and any attachment(s) contained, shall treat the information as confidential and not misuse, copy, disclose, distribute or retain the information in any way that amounts to a breach of confidentiality. If you are not the intended recipient, please delete all copies of this email from your computer system. As the integrity of this message cannot be guaranteed, neither UOB nor any entity in the UOB Group shall be responsible for the contents. Any opinion in this email may not necessarily represent the opinion of UOB or any entity in the UOB Group. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Weird field ID issue
It's been a while since I attempted to change or modify that field, but if memory serves, the last time I modified it, everything worked (I had to make a modification to make those stored procedures run again). I checked a couple more things in enterprise manager and I can't figure out how to get rid of that Z. If I open the field table, the field ID doesn't have the z appended to the end. If I open the table and return all rows, it also doesn't have the Z. The only place I can see it, is when I generate the SQL script for that particular table. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH DSN: 596-6472 / Comm: 334-416-6472 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, April 03, 2008 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: Weird field ID issue ** I had that issue once many years ago.. I do not know why it was caused but I am guessing it happened at the time I tried to delete that field and it wasn't successfully deleted.. it was not seen from the Admin tool but I could still see it in the T table and there was a row in the fields table referring to it. Luckily I didn't have any workflow attached to that field so my cleanup process was simple at db level.. If you didn't attempt deleting that field, maybe you did attempt modifying it, and the operation was not complete due to a timeout? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Thursday, April 03, 2008 1:47 PM To: arslist@ARSLIST.ORG Subject: Weird field ID issue ** Listers, I'm not entirely sure if this is an ARS issue or a SQL issue but we're having problems with one of our stored procedures. Back before any of us had any idea what we were doing in Remedy, one of our guys created a stored procedure to handle archiving. Basically just a select insert then drop. He also created an unarchive stored procedure in case anyone wanted to get an incident out of the archive form. One of my analysts tried to unarchive a ticket today and encountered the following error: ARERR [552] Failure during SQL operation to the database : Insert Error: Column name or number of supplied values does not match table definition. (SQL Server 213) I opened enterprise manager and generated a SQL script for the archive_incident and incident forms to make sure they matched up (my normal course of action when one of these operations fails) and everything appeared to match up, but at the bottom of the scripts, this is what I saw. On the incident script: [C536870918] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULLOn the Archive_Incident script: [C536870918Z] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL I'm at a total loss where that Z came from. This stored procedure has worked on several occasions with the only issue being a need for reordering of the columns if someone made a change to one form but not the other. I've never seen the name of a column change however. When I log into the administrator tool, and click on the field in question, the Database ID matches on both forms. I tried googling for help, but apparently my googlefu is weak. Anyone encountered something like this before or have an idea of how to fix it? Thanks much, Michael A. McManus, SSgt, USAF __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Error when saving ar.cfg: No Permission
Did you check the attributes of the file to see if it is read only - attrib ar.cfg On 4/3/08, Gary Opela [EMAIL PROTECTED] wrote: I am trying to change submitter mode to locked on a new remedy install. I keep getting an error stating I do not have write permission to ar.cfg. I went to the server, and validated that ar.cfg does indeed have permissions on it for the user that arserver.exe is running under. This server is not yet licensed, do you think this might be the issue? - Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. -- View this message in context: http://www.nabble.com/Error-when-saving-ar.cfg%3A-No-Permission-tp16467551p16467551.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Job: Remedy Developer - Dayton Ohio - Contract - Kforce
Dear List, Hope all is well, and everyone had a great weekend. Any help is greatly appreciated, this project needs someone to be on-site, but be part time for a 4 month project. High possibility of project extension, however, all I have is 4 months in our statement of work. Any recent Remedy experience would be considered. Thanks for everyone's time! Title: Remedy TTS Programmer or SC06 Location: Dayton, OH Telecommuting: Not an Option Authorization Status: US Citizens (Will be processed for Secret Clearance) Duration: 4 Month Part-Time Contract (28 Hours 1st Month / 32-Hours 2nd Month / 38 Hours 3rd 4th Months) Type: Straight Contract with possible extension Requirements: * US Citizen * 1 to 5 years experience with Remedy Action Request System (Releases 6 thru 7) and programming using the Remedy Language * Experience with Remedy IT Service Management Suite (ITSM) Release 7 * Database Experience Required (SQL/Oracle) If you are interested please forward me a resume and your salary requirements to [EMAIL PROTECTED] or call me at 937-416-3456. Respectfully, Joshua Kitchen Information Technology Recruiter Kforce Professional Staffing Two Prestige Place (Suite 350) 937.449.1749 Office 937.461.6888 Fax 937.416.3456 Cell Great People = Great Results http://www.linkedin.com/in/joshkitchen Please don't keep me a secret... a referral is the best compliment I can receive. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are btn_viewmy_160x33.gif
Re: Phone number formatting...
That does look like it'll work, but so many Replaces can get confusing. Here's the sql I have and it works great. You can change the formatting you want using the Substring function after stripping the field. Only downfall of this one is that you have to do a case statement for each character in a string. Our Phone field is 24 chars, Address field is usually a bit longer, but it still works. Don't know why PeopleSoft defaults the Phone field to allow any chars. I've been working with the Field Format property to create our own custom restrictions. It's pretty helpful to prevent future wacky input after you clean up your data. (if that's your intention). Happy Querying! SELECT A.EMPLID, A.PHONE_TYPE, A.PHONE as PHONE_ORIG_FORMAT, A.STRIPPED_PHONE, '(' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 1, 3) + ') ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 4, 3) + '-' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 7, 4) + ' X ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 11, LEN(RTRIM(A.STRIPPED_PHONE))) AS FORMATTED_PHONE, SUBSTRING(RTRIM(A.STRIPPED_PHONE), 1, 10) + ' X ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 11, LEN(RTRIM(A.STRIPPED_PHONE))) AS FORMATTED_PHONE2 FROM (select EMPLID, PHONE_TYPE, PHONE, case when substring( PHONE , 1 , 1 ) LIKE '[0-9]' then substring( PHONE , 1 , 1 ) else '' end + case when substring( PHONE , 2 , 1 ) LIKE '[0-9]' then substring( PHONE , 2 , 1 ) else '' end + case when substring( PHONE , 3 , 1 ) LIKE '[0-9]' then substring( PHONE , 3 , 1 ) else '' end + case when substring( PHONE , 4 , 1 ) LIKE '[0-9]' then substring( PHONE , 4 , 1 ) else '' end + case when substring( PHONE , 5 , 1 ) LIKE '[0-9]' then substring( PHONE , 5 , 1 ) else '' end + case when substring( PHONE , 6 , 1 ) LIKE '[0-9]' then substring( PHONE , 6 , 1 ) else '' end + case when substring( PHONE , 7 , 1 ) LIKE '[0-9]' then substring( PHONE , 7 , 1 ) else '' end + case when substring( PHONE , 8 , 1 ) LIKE '[0-9]' then substring( PHONE , 8 , 1 ) else '' end + case when substring( PHONE , 9 , 1 ) LIKE '[0-9]' then substring( PHONE , 9 , 1 ) else '' end + case when substring( PHONE , 10 , 1 ) LIKE '[0-9]' then substring( PHONE , 10 , 1 ) else '' end + case when substring( PHONE , 11 , 1 ) LIKE '[0-9]' then substring( PHONE , 11 , 1 ) else '' end + case when substring( PHONE , 12 , 1 ) LIKE '[0-9]' then substring( PHONE , 12 , 1 ) else '' end + case when substring( PHONE , 13 , 1 ) LIKE '[0-9]' then substring( PHONE , 13 , 1 ) else '' end + case when substring( PHONE , 14 , 1 ) LIKE '[0-9]' then substring( PHONE , 14 , 1 ) else '' end + case when substring( PHONE , 15 , 1 ) LIKE '[0-9]' then substring( PHONE , 15 , 1 ) else '' end + case when substring( PHONE , 16 , 1 ) LIKE '[0-9]' then substring( PHONE , 16 , 1 ) else '' end + case when substring( PHONE , 17 , 1 ) LIKE '[0-9]' then substring( PHONE , 17 , 1 ) else '' end + case when substring( PHONE , 18 , 1 ) LIKE '[0-9]' then substring( PHONE , 18 , 1 ) else '' end + case when substring( PHONE , 19 , 1 ) LIKE '[0-9]' then substring( PHONE , 19 , 1 ) else '' end + case when substring( PHONE , 20 , 1 ) LIKE '[0-9]' then substring( PHONE , 20 , 1 ) else '' end + case when substring( PHONE , 21 , 1 ) LIKE '[0-9]' then substring( PHONE , 21 , 1 ) else '' end + case when substring( PHONE , 22 , 1 ) LIKE '[0-9]' then substring( PHONE , 22 , 1 ) else '' end + case when substring( PHONE , 23 , 1 ) LIKE '[0-9]' then substring( PHONE , 23 , 1 ) else '' end + case when substring( PHONE , 24 , 1 ) LIKE '[0-9]' then substring( PHONE , 24 , 1 ) else '' end AS STRIPPED_PHONE FROM PS_PERSONAL_PHONE GROUP BY EMPLID, PHONE_TYPE, PHONE HAVING RTRIM(PHONE) '')A WHERE LEN(RTRIM(A.STRIPPED_PHONE)) = 10 -- View this message in context: http://www.nabble.com/Phone-number-formatting...-tp16019958p16491539.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Phone number formatting...
Most applications default phone number columns to characters instead of number.. This is to allow flexibility for users to put special instructions such as Extension or pin numbers texts.. What many applications don't do however is control the usage of this field. IMHO, the data in these fields would have been a lot more cleaner if the input was controlled, meaning at the application level there were fields such as country codes, area codes, local numbers and extensions that allowed input of digits only. Remedy ITSM applications now have that but they do not really control the input into these fields to be digits only.. so basically if the user uses them correctly, you do get a clean format, else junk.. What I wrote would be confusing in case I need to modify it, but for simplicity I have broken it down with more carriage returns than you see in my posting, so it gets easier to read. I'll have a look at your query too and maybe could use it the next time I have to do something similar.. I do however understand the idea on which you based your query and its a interesting thought considering PS phone number fields are 24 characters in length. The only drawback I can think of is that you will need to modify yours, if in case the length of the field is modified for whatever reasons... In my case that wouldn't need a modification, but may need one if we find more special characters in the user input somewhere down the line.. I'm already way too deep into mine to revert at this phase! Thanks for your suggestions.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of PS_Is_Fun Sent: Friday, April 04, 2008 9:52 AM To: arslist@ARSLIST.ORG Subject: Re: Phone number formatting... That does look like it'll work, but so many Replaces can get confusing. Here's the sql I have and it works great. You can change the formatting you want using the Substring function after stripping the field. Only downfall of this one is that you have to do a case statement for each character in a string. Our Phone field is 24 chars, Address field is usually a bit longer, but it still works. Don't know why PeopleSoft defaults the Phone field to allow any chars. I've been working with the Field Format property to create our own custom restrictions. It's pretty helpful to prevent future wacky input after you clean up your data. (if that's your intention). Happy Querying! SELECT A.EMPLID, A.PHONE_TYPE, A.PHONE as PHONE_ORIG_FORMAT, A.STRIPPED_PHONE, '(' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 1, 3) + ') ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 4, 3) + '-' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 7, 4) + ' X ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 11, LEN(RTRIM(A.STRIPPED_PHONE))) AS FORMATTED_PHONE, SUBSTRING(RTRIM(A.STRIPPED_PHONE), 1, 10) + ' X ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 11, LEN(RTRIM(A.STRIPPED_PHONE))) AS FORMATTED_PHONE2 FROM (select EMPLID, PHONE_TYPE, PHONE, case when substring( PHONE , 1 , 1 ) LIKE '[0-9]' then substring( PHONE , 1 , 1 ) else '' end + case when substring( PHONE , 2 , 1 ) LIKE '[0-9]' then substring( PHONE , 2 , 1 ) else '' end + case when substring( PHONE , 3 , 1 ) LIKE '[0-9]' then substring( PHONE , 3 , 1 ) else '' end + case when substring( PHONE , 4 , 1 ) LIKE '[0-9]' then substring( PHONE , 4 , 1 ) else '' end + case when substring( PHONE , 5 , 1 ) LIKE '[0-9]' then substring( PHONE , 5 , 1 ) else '' end + case when substring( PHONE , 6 , 1 ) LIKE '[0-9]' then substring( PHONE , 6 , 1 ) else '' end + case when substring( PHONE , 7 , 1 ) LIKE '[0-9]' then substring( PHONE , 7 , 1 ) else '' end + case when substring( PHONE , 8 , 1 ) LIKE '[0-9]' then substring( PHONE , 8 , 1 ) else '' end + case when substring( PHONE , 9 , 1 ) LIKE '[0-9]' then substring( PHONE , 9 , 1 ) else '' end + case when substring( PHONE , 10 , 1 ) LIKE '[0-9]' then substring( PHONE , 10 , 1 ) else '' end + case when substring( PHONE , 11 , 1 ) LIKE '[0-9]' then substring( PHONE , 11 , 1 ) else '' end + case when substring( PHONE , 12 , 1 ) LIKE '[0-9]' then substring( PHONE , 12 , 1 ) else '' end + case when substring( PHONE , 13 , 1 ) LIKE '[0-9]' then substring( PHONE , 13 , 1 ) else '' end + case when substring( PHONE , 14 , 1 ) LIKE '[0-9]' then substring( PHONE , 14 , 1 ) else '' end + case when substring( PHONE , 15 , 1 ) LIKE '[0-9]' then substring( PHONE , 15 , 1 ) else '' end + case when substring( PHONE , 16 , 1 ) LIKE '[0-9]' then substring( PHONE , 16 , 1 ) else '' end + case when substring( PHONE , 17 , 1 ) LIKE '[0-9]' then substring( PHONE , 17 , 1 ) else '' end + case when substring( PHONE , 18 , 1 ) LIKE '[0-9]' then substring( PHONE , 18 , 1 ) else '' end + case when substring( PHONE , 19 , 1 ) LIKE '[0-9]' then substring( PHONE , 19 , 1 ) else '' end + case when substring( PHONE , 20 , 1 ) LIKE '[0-9]' then substring( PHONE , 20 , 1 ) else '' end + case when substring( PHONE , 21 , 1 ) LIKE '[0-9]' then substring( PHONE , 21 , 1
Re: Phone number formatting...
In my case, I was able to do all of this with Filters, but the difference is that I have to deal only with U.S.-based numbers. The first filter to execute strips out all characters, and the second filter to execute sets the length of the remaining numerical data, then based on how many numbers I have, I split it out appropriately before pushing it into the real form. If I had to work with many international numbers, my first step would be to see if there is a web service that can translate the format for me. Thanks, Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, April 04, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Phone number formatting... ** Most applications default phone number columns to characters instead of number.. This is to allow flexibility for users to put special instructions such as Extension or pin numbers texts.. What many applications don't do however is control the usage of this field. IMHO, the data in these fields would have been a lot more cleaner if the input was controlled, meaning at the application level there were fields such as country codes, area codes, local numbers and extensions that allowed input of digits only. Remedy ITSM applications now have that but they do not really control the input into these fields to be digits only.. so basically if the user uses them correctly, you do get a clean format, else junk.. What I wrote would be confusing in case I need to modify it, but for simplicity I have broken it down with more carriage returns than you see in my posting, so it gets easier to read. I'll have a look at your query too and maybe could use it the next time I have to do something similar.. I do however understand the idea on which you based your query and its a interesting thought considering PS phone number fields are 24 characters in length. The only drawback I can think of is that you will need to modify yours, if in case the length of the field is modified for whatever reasons... In my case that wouldn't need a modification, but may need one if we find more special characters in the user input somewhere down the line.. I'm already way too deep into mine to revert at this phase! Thanks for your suggestions.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of PS_Is_Fun Sent: Friday, April 04, 2008 9:52 AM To: arslist@ARSLIST.ORG Subject: Re: Phone number formatting... That does look like it'll work, but so many Replaces can get confusing. Here's the sql I have and it works great. You can change the formatting you want using the Substring function after stripping the field. Only downfall of this one is that you have to do a case statement for each character in a string. Our Phone field is 24 chars, Address field is usually a bit longer, but it still works. Don't know why PeopleSoft defaults the Phone field to allow any chars. I've been working with the Field Format property to create our own custom restrictions. It's pretty helpful to prevent future wacky input after you clean up your data. (if that's your intention). Happy Querying! SELECT A.EMPLID, A.PHONE_TYPE, A.PHONE as PHONE_ORIG_FORMAT, A.STRIPPED_PHONE, '(' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 1, 3) + ') ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 4, 3) + '-' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 7, 4) + ' X ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 11, LEN(RTRIM(A.STRIPPED_PHONE))) AS FORMATTED_PHONE, SUBSTRING(RTRIM(A.STRIPPED_PHONE), 1, 10) + ' X ' + SUBSTRING(RTRIM(A.STRIPPED_PHONE), 11, LEN(RTRIM(A.STRIPPED_PHONE))) AS FORMATTED_PHONE2 FROM (select EMPLID, PHONE_TYPE, PHONE, case when substring( PHONE , 1 , 1 ) LIKE '[0-9]' then substring( PHONE , 1 , 1 ) else '' end + case when substring( PHONE , 2 , 1 ) LIKE '[0-9]' then substring( PHONE , 2 , 1 ) else '' end + case when substring( PHONE , 3 , 1 ) LIKE '[0-9]' then substring( PHONE , 3 , 1 ) else '' end + case when substring( PHONE , 4 , 1 ) LIKE '[0-9]' then substring( PHONE , 4 , 1 ) else '' end + case when substring( PHONE , 5 , 1 ) LIKE '[0-9]' then substring( PHONE , 5 , 1 ) else '' end + case when substring( PHONE , 6 , 1 ) LIKE '[0-9]' then substring( PHONE , 6 , 1 ) else '' end + case when substring( PHONE , 7 , 1 ) LIKE '[0-9]' then substring( PHONE , 7 , 1 ) else '' end + case when substring( PHONE , 8 , 1 ) LIKE '[0-9]' then substring( PHONE , 8 , 1 ) else '' end + case when substring( PHONE , 9 , 1 ) LIKE '[0-9]' then substring( PHONE , 9 , 1 ) else '' end + case when substring( PHONE , 10 , 1 ) LIKE '[0-9]' then substring( PHONE , 10 , 1 ) else '' end + case when substring( PHONE , 11 , 1 ) LIKE '[0-9]' then substring( PHONE , 11 , 1 ) else '' end + case when substring( PHONE , 12 , 1 ) LIKE '[0-9]' then substring( PHONE , 12 , 1 ) else '' end + case when substring( PHONE , 13 , 1 ) LIKE '[0-9]' then substring( PHONE , 13 , 1 ) else ''
Remedy Installed on DB1 but data from DB2
Folks, Any help is appreciated on this. Facts --- -- Remedy Server is installed with MS SQLServer which has useful data. -- There is an Oracle DB on another box that has other important data. Question --- -- Can we build forms that use the data from the Oracle DB? -- Is that native to how Remedy works? -- Is this something that we need to configure in MS SQLServer? -- Has anyone had any experience with this? -- When you use direct SQL in Remedy filters/active links it will use MS SQLServer, can we somehow get the data Oracle DB? I think this involves MS SQLServer config more than Remedy? We are non-profit organization, but I am willing to look at products that do this and of course read any documentation? Thank you - El-Noor ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OT:British Humour
http://www.anglik.net/rateme.htm and now for something totally different . A man walks into a doctor's office. He has a cucumber up his nose, a carrot in his left ear and a banana in his right ear. What's the matter with me? he asks the doctor. The doctor replies, You're not eating properly. A man asked for a meal in a restaurant. The waiter brought the food and put it on the table. After a moment, the man called the waiter and said: Waiter! Waiter! There's a fly in my soup! Please don't speak so loudly, sir, said the waiter, or everyone will want one. -- There are 5 birds in a tree. A hunter shoots 2 of them dead. How many birds are left? 2 birds. The other 3 fly away! -- An English teacher wrote these words on the whiteboard: woman without her man is nothing. The teacher then asked the students to punctuate the words correctly. The men wrote: Woman, without her man, is nothing. The women wrote: Woman! Without her, man is nothing. The woman was in bed with her lover and had just told him how stupid her Irish husband was when the door was thrown open and there stood her husband. He glared at her lover and bellowed, What are you doing? There, said the wife, didn't I tell you he was stupid? -- What's the definition of a pessimist? A pessimist is a well-informed optimist. - Mark called in to see his friend Angus (a Scotman) to find he was stripping the wallpaper from the walls. Rather obviously, he remarked You're decorating, I see. to which Angus replied No. I'm moving house. - One day an Englishman, a Scotsman, and an Irishman walked into a pub together. They each bought a pint of Guinness. Just as they were about to enjoy their creamy beverage, three flies landed in each of their pints, and were stuck in the thick head. The Englishman pushed his beer away in disgust. The Scotsman fished the fly out of his beer, and continued drinking it, as if nothing had happened. The Irishman, too, picked the fly out of his drink, held it out over the beer, and started yelling, SPIT IT OUT, SPIT IT OUT YOU BAS**RD --- A Scottish farmer was in his field digging up his tatties (a Scots word for potatoes). An American farmer looked over the fence and said In Texas we grow potatoes 5 times larger than that! The Scotsman replied Ah but we just grow them for our own mouths! --- 1st Eskimo: Where did your mother come from? 2nd Eskimo: Alaska 1st Eskimo: Don't bother, I'll ask her myself! --- Charles was getting annoyed and shouted upstairs to his wife, Hurry up or we'll be late. Oh, be quiet, replied his wife. Haven't I been telling you for the last hour that I'll be ready in a minute? -- Five Englishmen boarded a train just behind five Scots, who, as a group had only purchased one ticket. Just before the conductor came through, all the Scots piled into the toilet stall at the back of the car. As the conductor passed the stall, he knocked and calledTickets, please! and one of the Scots slid a ticket under the door. It was punched, pushed back under the door, and when it was safe all the Scots came out and took their seats. The Englishmen were tremendously impressed by the Scots' ingenuity. On the trip back, the five Englishmen decided to try this themselves and purchased only one ticket. They noticed that, oddly, the Scots had not purchased any tickets this time. Anyway, again, just before the conductor came through, the Scots piled into one of the toilet stalls, the Englishmen into the other. Then one of the Scots leaned out, knocked on the Englishmen's stall and called Ticket, Please! When the ticket slid out under the door, he picked it up and quickly closed the door Why did the bald man paint rabbits on his head? Because from a distance they looked like hares! An English man and an Irish man are driving head on , at night, on a twisty, dark road. Both are driving too fast for the conditions and collide on a sharp bend in the road. To the amazement of both, they are unscathed, though their cars are both destroyed. In celebration of their luck, both agree to put aside their dislike for the other from that moment on. At this point, the Englishman goes to the boot and fetches a 12 year old bottle of whisky. He hands the bottle to the Irish man, whom exclaims,'' may the Irish and the English live together forever, in peace, and harmony.'' The Irish man then tips the bottle and gulps half of the bottle down.
Re: Phone number formatting...
Never really thought of that.. so didn't look to see if there were any available web services that would do what I want.. I was trying to use the following statement in a direct SQL, and instead of just one $1$ column, I get 4, $1$, $2$, $3$ and $4$ as available outputs to choose from.. Needless to say these are wrong.. so where am I going wrong in this statement? Does ARS think a space is a separation character to represent another column??? I'm using the following in my Direct SQL statement in my set field action... Select trim(replace(translate(replace(replace(replace(replace(replace(upper(replace (replace(replace(replace(replace(replace(replace(replace(replace($Phone Business$,'+',''), '/',''),'-',''),'(',''),')',''),'!',''),'#',''),'*',''),',','')),'.',' '),' ',' '),' X','?'),' EXT','?'),' ',''),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','^^'),'^','')) from dual Thinking that it may need a single quote around the Phone Business field I even tried the below with the same results.. Select trim(replace(translate(replace(replace(replace(replace(replace(upper(replace (replace(replace(replace(replace(replace(replace(replace(replace('$Phone Business$','+',''),'/',''),'-',''),'(',''),')',''),'!',''),'#',''),'*',''),' ,','')),'.',' '),' ',' '),' X','?'),' EXT','?'),' ',''),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','^^'),'^','')) from dual So where I going wrong? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Pierson, Shawn Sent: Friday, April 04, 2008 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Phone number formatting... ** In my case, I was able to do all of this with Filters, but the difference is that I have to deal only with U.S.-based numbers. The first filter to execute strips out all characters, and the second filter to execute sets the length of the remaining numerical data, then based on how many numbers I have, I split it out appropriately before pushing it into the real form. If I had to work with many international numbers, my first step would be to see if there is a web service that can translate the format for me. Thanks, Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, April 04, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Phone number formatting... ** Most applications default phone number columns to characters instead of number.. This is to allow flexibility for users to put special instructions such as Extension or pin numbers texts.. What many applications don't do however is control the usage of this field. IMHO, the data in these fields would have been a lot more cleaner if the input was controlled, meaning at the application level there were fields such as country codes, area codes, local numbers and extensions that allowed input of digits only. Remedy ITSM applications now have that but they do not really control the input into these fields to be digits only.. so basically if the user uses them correctly, you do get a clean format, else junk.. What I wrote would be confusing in case I need to modify it, but for simplicity I have broken it down with more carriage returns than you see in my posting, so it gets easier to read. I'll have a look at your query too and maybe could use it the next time I have to do something similar.. I do however understand the idea on which you based your query and its a interesting thought considering PS phone number fields are 24 characters in length. The only drawback I can think of is that you will need to modify yours, if in case the length of the field is modified for whatever reasons... In my case that wouldn't need a modification, but may need one if we find more special characters in the user input somewhere down the line.. I'm already way too deep into mine to revert at this phase! Thanks for your suggestions.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of PS_Is_Fun Sent: Friday, April 04, 2008 9:52 AM To: arslist@ARSLIST.ORG Subject: Re: Phone number formatting... That does look like it'll work, but so many Replaces can get confusing. Here's the sql I have and it works great. You can change the formatting you want using the Substring function after stripping the field. Only downfall of this one is that you have to do a case statement for each character in a string. Our Phone field is 24 chars, Address field is usually a bit longer, but it still works. Don't know why PeopleSoft defaults the Phone field to allow any chars. I've been working with the Field Format property to create our own custom restrictions. It's pretty helpful to prevent future wacky input after you clean up your data. (if that's your intention). Happy Querying! SELECT A.EMPLID, A.PHONE_TYPE, A.PHONE
SQL Question
Hi Our Remedy database (MS Sql 2000) has grown from 4GB to 52GB in the past few months. I had turned on auditing for our asset database . The auditing table is huge. That was the cause. I turned off auditing and then late last night deleted the table from ARAdmin. I no longer see the table in Remedy but it's T table is still in SQL with all the data. I am by no stretch of the imagination a DBA so sorry if this is a dumb question. Why is that table still there and how do I get rid of the massive amount of data. thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SQL Question
SQL QuestionBrian, Deleting entries does not get rid of what is often referred to the 'high water mark'. Meaning that space is still allocated to the table.. What you need to do is truncate the tables in question (both the t and h tables) Syntax for truncate is truncate table Txxx; truncate table Hxxx; Truncate is followed by an auto commit so even if you were on Oracle, you would not need to commit after a truncate.. If this still doesn't, shrink your SQL database, use the shrink feature of the database after you have truncated the two tables.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sokol, Brian Sent: Friday, April 04, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: SQL Question ** Hi Our Remedy database (MS Sql 2000) has grown from 4GB to 52GB in the past few months. I had turned on auditing for our asset database . The auditing table is huge. That was the cause. I turned off auditing and then late last night deleted the table from ARAdmin. I no longer see the table in Remedy but it's T table is still in SQL with all the data. I am by no stretch of the imagination a DBA so sorry if this is a dumb question. Why is that table still there and how do I get rid of the massive amount of data. thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.5/1359 - Release Date: 4/4/2008 8:23 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Using 'Search Bar' with 'Create Date'
I'm sorry... this work very well... De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: sex 4/4/2008 12:40 Para: arslist@ARSLIST.ORG Assunto: Using 'Search Bar' with 'Create Date' ** Hi for all, I'd like to know if there is a way to block users to do sentences like that: 'Create Date' 0404/2008 for example... I tried to do something like this... 'Search Bar' LIKE (( % + 'Create Date' ) + % ) using Active Link... But it does not work Thankx in advance... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Moving Data from Oracle to SQL
Why not export the data using the import/export tool and then import it with the import/export tool? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Covert, Jack Sent: Friday, April 04, 2008 12:34 PM To: arslist@ARSLIST.ORG Subject: Moving Data from Oracle to SQL ** Hi guys. We're migrating data from Remedy 5 (Oracle 11) to Remedy 7 (SQL 2005). We're having a heck of a time w/ long fields. Anybody have any experience/advice on how to move millions of records with long fields from one system to the other? Thanks everybody, I don't know what I'd do w/o this group! Jack Covert Corporate IT Enterprise Systems Management Remedy Support Team Remedy Support Team Home Page http://collaborate.mckesson.com/sites/esm/remedy http://collaborate.mckesson.com/sites/esm/remedy ESM - Leveraging the power of automation for the benefit of the business __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Moving Data from Oracle to SQL
Hi guys. We're migrating data from Remedy 5 (Oracle 11) to Remedy 7 (SQL 2005). We're having a heck of a time w/ long fields. Anybody have any experience/advice on how to move millions of records with long fields from one system to the other? Thanks everybody, I don't know what I'd do w/o this group! Jack Covert Corporate IT Enterprise Systems Management Remedy Support Team Remedy Support Team Home Page http://collaborate.mckesson.com/sites/esm/remedy http://collaborate.mckesson.com/sites/esm/remedy ESM - Leveraging the power of automation for the benefit of the business ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Question: Allow Request Creation
I have looked in both the Change Management User's Guide and Configuration Guide (both 7.0) and there is nothing that talks about the option on the left hand side of Change called Create Request Creation. Does anyone know what this is? THANKS! Happy Friday :-) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Question: Allow Request Creation
Yup. A request is required for the Change to show on the Requester Console. -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 T. Dee [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/04/2008 02:12 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Question: Allow Request Creation I have looked in both the Change Management User's Guide and Configuration Guide (both 7.0) and there is nothing that talks about the option on the left hand side of Change called Create Request Creation. Does anyone know what this is? THANKS! Happy Friday :-) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy Mail 4.5.2
Hi Everyone, I am on a site with every version of Remedy you can imagine, and they don't have the budget to upgrade. As BMC only support 2 versions back, does anyone have a copy of Remedy Mail 4.5.2? The Mail application is on an ancient server which has recently started creating DLL errors, and hence no longer sends out emails. Thanks a lot Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy Mail 4.5.2
Mike, I think I do have it.. what OS do you want it for? Do you have an FTP site I can upload it to if I have it for the OS that you want it for? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, April 04, 2008 3:12 PM To: arslist@ARSLIST.ORG Subject: Remedy Mail 4.5.2 ** Hi Everyone, I am on a site with every version of Remedy you can imagine, and they don't have the budget to upgrade. As BMC only support 2 versions back, does anyone have a copy of Remedy Mail 4.5.2? The Mail application is on an ancient server which has recently started creating DLL errors, and hence no longer sends out emails. Thanks a lot Mike No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.5/1359 - Release Date: 4/4/2008 8:23 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Question: Allow Request Creation
Tony I turned this on (clicked button) - saved the Change, but it is not showing up in the Requestor Console - is there something else that has to be done? Thanks. Ty On 4/4/08, Tony Worthington [EMAIL PROTECTED] wrote: ** Yup. A request is required for the Change to show on the Requester Console. -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 *T. Dee [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/04/2008 02:12 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Question: Allow Request Creation I have looked in both the Change Management User's Guide and Configuration Guide (both 7.0) and there is nothing that talks about the option on the left hand side of Change called Create Request Creation. Does anyone know what this is? THANKS! Happy Friday :-) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Search Menus
Hi, We have a search menu in the Help Desk that pulls from another table (i.e. locations). When the user selects the menu in Help Desk - does it go to the database to query all the records from the location table. Secondly, if I have an open window action that passes a qualification against the Help Desk table - - does the workflow query the database once or twice to get the results? I believe it searches the database to get the location data, and the second time to process the qualification. However when Remedy runs the open window $qualification$ action does it search the entire HPD:Help Desk table to process the qualification ? **Planning your summer road trip? Check out AOL Travel Guides. (http://travel.aol.com/travel-guide/united-states?ncid=aoltrv000316) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy and Crystal
Hi All, I am getting an ARERROR 1244 (External qualification error field unexpected $Support Group...) when executing a Crystal report thru remedy. I looked in the documentation and it says syntax error. The syntax has not changed and has been working all along. I updated patches on the user tool. Then I went into production and the reports that used to run are giving me the same error? **Planning your summer road trip? Check out AOL Travel Guides. (http://travel.aol.com/travel-guide/united-states?ncid=aoltrv000316) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy and Crystal
sir, env please, os, version, etc , client, etc On 4/4/08, Koyb P. Liabt [EMAIL PROTECTED] wrote: ** Hi All, I am getting an ARERROR 1244 (External qualification error field unexpected $Support Group...) when executing a Crystal report thru remedy. I looked in the documentation and it says syntax error. The syntax has not changed and has been working all along. I updated patches on the user tool. Then I went into production and the reports that used to run are giving me the same error? -- Planning your summer road trip? Check out AOL Travel Guideshttp://travel.aol.com/travel-guide/united-states?ncid=aoltrv000316 . __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Patrick Zandi Dev Technology Group -- www.devtechnology.com Exceeding your Expectations ! By Design... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: British Humour
I thought for sure someone would have said something by now! Any Monty Python fans in the house? It's And now for something COMPLETELY different... I loved these little jokes, very funny! Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gidd Sent: Friday, April 04, 2008 11:16 AM To: arslist@ARSLIST.ORG Subject: OT:British Humour ** and http://www.anglik.net/rateme.htm now for something totally different . A man walks into a doctor's office. He has a cucumber up his nose, a carrot in his left ear and a banana in his right ear. What's the matter with me? he asks the doctor. The doctor replies, You're not eating properly. A man asked for a meal in a restaurant. The waiter brought the food and put it on the table. After a moment, the man called the waiter and said: Waiter! Waiter! There's a fly in my soup! Please don't speak so loudly, sir, said the waiter, or everyone will want one. -- There are 5 birds in a tree. A hunter shoots 2 of them dead. How many birds are left? 2 birds. The other 3 fly away! -- An English teacher wrote these words on the whiteboard: woman without her man is nothing. The teacher then asked the students to punctuate the words correctly. The men wrote: Woman, without her man, is nothing. The women wrote: Woman! Without her, man is nothing. The woman was in bed with her lover and had just told him how stupid her Irish husband was when the door was thrown open and there stood her husband. He glared at her lover and bellowed, What are you doing? There, said the wife, didn't I tell you he was stupid? -- What's the definition of a pessimist? A pessimist is a well-informed optimist. - Mark called in to see his friend Angus (a Scotman) to find he was stripping the wallpaper from the walls. Rather obviously, he remarked You're decorating, I see. to which Angus replied No. I'm moving house. - One day an Englishman, a Scotsman, and an Irishman walked into a pub together. They each bought a pint of Guinness. Just as they were about to enjoy their creamy beverage, three flies landed in each of their pints, and were stuck in the thick head. The Englishman pushed his beer away in disgust. The Scotsman fished the fly out of his beer, and continued drinking it, as if nothing had happened. The Irishman, too, picked the fly out of his drink, held it out over the beer, and started yelling, SPIT IT OUT, SPIT IT OUT YOU BAS**RD --- A Scottish farmer was in his field digging up his tatties (a Scots word for potatoes). An American farmer looked over the fence and said In Texas we grow potatoes 5 times larger than that! The Scotsman replied Ah but we just grow them for our own mouths! --- 1st Eskimo: Where did your mother come from? 2nd Eskimo: Alaska 1st Eskimo: Don't bother, I'll ask her myself! --- Charles was getting annoyed and shouted upstairs to his wife, Hurry up or we'll be late. Oh, be quiet, replied his wife. Haven't I been telling you for the last hour that I'll be ready in a minute? -- Five Englishmen boarded a train just behind five Scots, who, as a group had only purchased one ticket. Just before the conductor came through, all the Scots piled into the toilet stall at the back of the car. As the conductor passed the stall, he knocked and calledTickets, please! and one of the Scots slid a ticket under the door. It was punched, pushed back under the door, and when it was safe all the Scots came out and took their seats. The Englishmen were tremendously impressed by the Scots' ingenuity. On the trip back, the five Englishmen decided to try this themselves and purchased only one ticket. They noticed that, oddly, the Scots had not purchased any tickets this time. Anyway, again, just before the conductor came through, the Scots piled into one of the toilet stalls, the Englishmen into the other. Then one of the Scots leaned out, knocked on the Englishmen's stall and called Ticket, Please! When the ticket slid out under the door, he picked it up and quickly closed the door Why did the bald man paint rabbits on his head? Because from a distance they looked like hares! An English man and an Irish man are driving head on , at night, on a twisty, dark road. Both are driving too fast for the conditions and collide on a sharp bend in the road. To the
Re: Moving Data from Oracle to SQL
Why not use Migrator? -Original Message- From: Action Request System discussion list(ARSList) on behalf of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Fri 4/4/2008 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Moving Data from Oracle to SQL Why not export the data using the import/export tool and then import it with the import/export tool? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Covert, Jack Sent: Friday, April 04, 2008 12:34 PM To: arslist@ARSLIST.ORG Subject: Moving Data from Oracle to SQL ** Hi guys. We're migrating data from Remedy 5 (Oracle 11) to Remedy 7 (SQL 2005). We're having a heck of a time w/ long fields. Anybody have any experience/advice on how to move millions of records with long fields from one system to the other? Thanks everybody, I don't know what I'd do w/o this group! Jack Covert Corporate IT Enterprise Systems Management Remedy Support Team Remedy Support Team Home Page http://collaborate.mckesson.com/sites/esm/remedy http://collaborate.mckesson.com/sites/esm/remedy ESM - Leveraging the power of automation for the benefit of the business __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are