OT: System Names and "Fat Fingers"... This seems like a very common thing in-deed...
Unfortunately our data center guys like using very goofy names like sjcsair9 or mucsvr10 which mean only limited information to them (3 digit airport code of data center, S=Server,a=physical | v=virtual,i=IIS,r=production (why not P?) and nn of numbers)... Yah Right, like I can remember this. Our excel sheet(s) look really goofy also. Especially when we add additional servers to the load-balancer then the nn's are all wacked out! Then throw in the named SQL Server instances so you have a goofy Server Name\Goofy Database Name... does MUCSV05\rdev07 mean anything to you? However, what we DO HAVE is DNS-Aliases which are useful "RemedyV6Dev", "ITSM7Dev", (but you need to be careful with the "Application Server" $SERVER$ tests :( ) However, we also to protect TEST and PRODUCTION have the "Disable Admin Operations" set, unless we are doing a migration. Yes, it is a pain, but step 1 = enable admin operations, step last = disable admin operations. HTH Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, April 23, 2007 6:44 AM To: [email protected] Subject: Re: Date in Case number OT: I just wanted to chime in on "Guess how many times I accidentally modified the production server in the middle of the day.", this used to happen to me too. What I did to avoid this is on the Home Page and one other form, I have a window-open active link that checks the name of the server. If it's not the production server I un-hide a field that contains "You are logged into the DEVELOPMENT server" in bold red letters. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Monday, April 23, 2007 1:58 AM To: [email protected] Subject: Re: Date in Case number If you're looking for more fuel, I can help. Don't do it. Matt is right -- if at all possible, don't mess with the Request ID. It reminds me of those silly names the IT people give printers and servers, like "HPLJ5305RCWF" for "HP Laser Jet 5 in building 30, 5th floor, Right Corner, by the Water Fountain." Nobody can remember the name and, most likely, nobody remembers why it was named that way. Odds are, somebody recently moved it to a different location. I've worked at several places where the name of the production Remedy AR server and the development server was different by only one letter. Guess how many times I accidentally modified the production server in the middle of the day. (Answer: About once a week. :-o) Overloading simple names with model and location information is foolish. There's a reason why they used to give UNIX boxes names like "ren" and "stimpy". If a name is just as hard to remember as an IP address, you've defeated the whole purpose of host names. But I digress... Generally speaking, you don't want to try to overload field values with unrelated information. For example, in a primary key field in a database table, you don't want to start concatenating last names and create dates and such. As Matt said, if you want the Create Date, then you can jolly well query for the Create Date. --Tim ----- Original Message ---- From: Steven Pataray <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, April 23, 2007 12:14:42 AM Subject: Re: [ARSLIST] Date in Case number ** I can create a character field that displayes the HDyyyyddmm using the LPAD and DATENUM functions in an Active link but I don't know how to get the next Entry ID since the LASTID would get the last entry id since I have to use Execute On After Submit. How could I be sure that I'll always get the correct sequence number if it's After Submit since someone else could possibly submit before the transaction is complete? Thanks guys, I can use your recommendations to fuel my justification not to do this. Steve On 4/22/07, Rick Cook < [EMAIL PROTECTED]> wrote:I agree with Matt - see if he can get by with just a displayed number that's formatted like he wants - create a new field into which to dump that reformatted Entry ID without mucking with what you already have. You could maybe compromise by agreeing to send that new field out in a few key notifications and/or use it for reports, without having to rebuild all of the workflow associated with Field ID #1. Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Saturday, April 21, 2007 6:30 PM To: [email protected] Subject: Re: Date in Case number Steven, I would strongly suggest that you NOT alter the field 1 value. Add a new field. Do your business logic there and then propagate those changes to the table fields/forms of interest too. Simply add the time/cost of all of those changes and inform your management of the impact to the application and any future upgrades. See how much they think this is really worth. Generally I find that when you can use existing functionality (AKA: 'Create Date') and not have to do additional, expensive, and difficult to maintain "enhancements" appeals to most management types. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 4/20/07, Steven Pataray <[EMAIL PROTECTED] > wrote: > ** My managment would like to have a date included our HelpDesk Case > number i.e. HD20070420xxxxx. The xxxxx would be the actual sequential case number. > They would use this so they know what day a ticket was created. I > really don't want to create another field with this number appended to > each other since a lot of the reports and table queries are based on the Case number. > Does anyone have any advise how I can achieve this? > > Thanks > Steve > > ARS/HelpDesk 6.3 patch 19 > Oracle 10g R1 Clustered > Application server Windows 2003 ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
