Re: Escalation Timeline
Latest version has been updated on BMCDN http://communities.bmc.com/communities/docs/DOC-10093 _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, April 07, 2010 12:23 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Okafter several back and forths with Chris Pruitt, another version is available for download http://www.arinside.org/downloads/20 I have submitted the update to BMCDN, will notify when it's approved. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Okafter several back and forths with Chris Pruitt, another version is available for download http://www.arinside.org/downloads/20 I have submitted the update to BMCDN, will notify when it's approved. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Monday, April 05, 2010 9:27 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline http://communities.bmc.com/communities/docs/DOC-10093 The updated version is again available from the BMCDN. Please feel free to download and check it outlet me know if it's working and if you find the information useful. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Friday, April 02, 2010 2:30 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline I have updated the java program as well as the html file to fix the IE issues. Please download again from ARInside web site till they approve the update on the BMCDN http://www.arinside.org/downloads/20 _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:41 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...approved, I didn't know what sort of timeline it was going to take to get it approvedhere is the link http://communities.bmc.com/communities/docs/DOC-10093 Thank you to the 8 people interested enough in this project to download it in the last hour :) _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:03 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
http://communities.bmc.com/communities/docs/DOC-10093 The updated version is again available from the BMCDN. Please feel free to download and check it outlet me know if it's working and if you find the information useful. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Friday, April 02, 2010 2:30 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline I have updated the java program as well as the html file to fix the IE issues. Please download again from ARInside web site till they approve the update on the BMCDN http://www.arinside.org/downloads/20 _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:41 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...approved, I didn't know what sort of timeline it was going to take to get it approvedhere is the link http://communities.bmc.com/communities/docs/DOC-10093 Thank you to the 8 people interested enough in this project to download it in the last hour :) _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:03 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
I have updated the java program as well as the html file to fix the IE issues. Please download again from ARInside web site till they approve the update on the BMCDN http://www.arinside.org/downloads/20 _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:41 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...approved, I didn't know what sort of timeline it was going to take to get it approvedhere is the link http://communities.bmc.com/communities/docs/DOC-10093 Thank you to the 8 people interested enough in this project to download it in the last hour :) _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:03 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
The yucky search is on the BMC.com website. Just wanted to make that clear! (not arslist.org) :) Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Thursday, April 01, 2010 11:57 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** This is more of a rant about the Community Search function. I did a search on "Escalation Timeline" (because I forgot where I put this post) and I get 2 results, neither of them are LJ's post. Weird! It's in the SUBJECT! Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, March 31, 2010 12:41 PM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** Ok...approved, I didn't know what sort of timeline it was going to take to get it approvedhere is the link http://communities.bmc.com/communities/docs/DOC-10093 Thank you to the 8 people interested enough in this project to download it in the last hour :) From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:03 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
This is more of a rant about the Community Search function. I did a search on "Escalation Timeline" (because I forgot where I put this post) and I get 2 results, neither of them are LJ's post. Weird! It's in the SUBJECT! Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, March 31, 2010 12:41 PM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** Ok...approved, I didn't know what sort of timeline it was going to take to get it approvedhere is the link http://communities.bmc.com/communities/docs/DOC-10093 Thank you to the 8 people interested enough in this project to download it in the last hour :) From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:03 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
LJ, please bear with me.. I've downloaded this tool and copied the 2 JAR files into its directory (C:\Tools\Escalation Timeline). But when I try to run the tool I get the following: Runtime error on line 7. Error: expected identifier, string or number Runtime error on line 29. Error: expected identifier, string or number Runtime error on line 58. Error: object expected Am I missing something? Thanks, Marcelo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Wednesday, March 31, 2010 11:41 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** Ok...approved, I didn't know what sort of timeline it was going to take to get it approvedhere is the link http://communities.bmc.com/communities/docs/DOC-10093 Thank you to the 8 people interested enough in this project to download it in the last hour :) From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:03 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Ok...approved, I didn't know what sort of timeline it was going to take to get it approvedhere is the link http://communities.bmc.com/communities/docs/DOC-10093 Thank you to the 8 people interested enough in this project to download it in the last hour :) _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 10:03 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Escalation Timeline Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Ok...I don't know if this went out or notbut I'm pretty sure the attachment didn't. I wasn't planning on adding it to the BMC Developers network quite yet, but that seems to be about the only way for me to get it out to youwell, just about the only waytill it's approved on the BMCDN I have added it to the ARInside downloads http://www.arinside.org/downloads/20 it won't stay there...but until it's available on BMCDN I'll leave it there. _ From: LJ Longwing [mailto:lj.longw...@gmail.com] Sent: Wednesday, March 31, 2010 9:49 AM To: LJ Longwing; 'arslist@ARSLIST.ORG' Subject: Escalation Timeline I submit to the community a tool requested many a time, but never quite delivered upon. Escalation Timeline In the attached zip file are some files to work with...it's fully functional in my little corner of the world. Here is a list of the files and their function -EscalationTimeline.java - Source code for the program -EscalationTimeline.class - Compiled version of said source code -esc_timeline.properties - This is the config file the program uses to generate the output, it's commented fairly good -esc_timeline.css - css file for the html file -esc_timeline.html - html file that displays the output -esc_timeline.js - this is the 'events' file that the program generates, it takes the input in the config file and the escalations in your server and generates this file, this is an input to the html Okthis program requires two things I didn't include. It needs the ARAPI*.JAR fileI'm using the 7.5 version, but really, I believe anything 7.1+ will work. It also wants a log4j jar file...both of these jar files should be available on your server somewhere and depending on what version of the tools you have on your workstation, they may exist there as well . It uses the opensource timeline simile project and requires access to the internet to grab the libraries from them. I sincerely would like feedback on the programthe coding is sloppy but effective. One example of the sloppywhen determining which type of escalation, I do a cast in a try block, if the cast fails, I know it's the other kind...VERY sloppy but effective for the most part. :) Let me know folks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Since we're on the subject of escalations, I thought I'd weigh in here. Not sure how relevant this is to your end goal, but it may stimulate some thought at the very least. This was in a pre 7.x environment, so the use of "Escalation Pools" was not available yet. To help ease our troubleshooting efforts, we took a number of actions in our environment. 1. Created and maintained a document (spreadsheet) listing all defined escalation, what they do, the defined timeline, and whatever other information we needed to capture about the escalation. Yes, this was a manual process, but at least it gave us reference as to what was configured. 2. It became a "Change Control" process when ever added a new or modifying an existing escalation, and part of that process was to update the master reference document. 3. We created a backend form (AR Escalation Monitor) to store information about an escalation run. This forms contained fields like: . Escalation Name . Start Time . End Time . #Recs . Secs, Mins, Hrs, etc. . Status . Secs (per/rec) . Free (Mins) 4. For each escalation that we wanted to monitor (in our case all of them), each existing escalation was modified to include a "Push Fields" action that pushes a new record (or updates) to the "AR Escalation Monitor" form with each run of the escalation. . So basically, each time the escalation runs the following occurs: i. Create new record in AR Escalation Monitor, setting Escalation Name, a "Start Time", #Recs = (#Recs +1), Etc. ii. Each subsequent record processed by the escalation, updates the newly created record and increments the #Recs counter. iii. For the "Status", we set a value of "Running" at the beginning of each transaction, and then set it to "Completed" at the end. . At the end of each escalation run, we end up with one new record in "AR Escalation Monitor" that shows us useful information about the run. . Obviously, this process would add some overhead to what the escalation is already defined to do. However, after measuring the impact of the additional overhead (in our environment), it was overwhelmingly agreed that the benefit of the output by far outweighed any performance hit. 5. A policy change was made to our Development Guidelines, which required any developer who had a need to create a new escalation, to include this process as part on that escalation. 6. We then created a report (Crystal) which could be run On-Demand, to display this data. . The typical report would show the following information: i. What escalation is currently running ii. What type of escalation (Time/Interval) iii. Previous escalations that ran (depending on the Date Range selection in the report). iv. The Start and End time for the escalation. v. The number of records that were processed by the escalation vi. The Duration of the escalation (Secs, Mins, Hrs). vii. How many records per/sec the escalation has processed. . On the Crystal Report, some conditional formatting was put in place to highlight certain records if defined thresholds have been exceeded. Note: We defined these thresholds after establishing baselines from a normally operating system. So, to sum this all up, after having implemented this process, whenever a problem was reported, we were able to pull this report up, Refresh, and immediately see what escalation (if any) was running, and what the performance of it was. This report was also very useful because it helped indentify if the root cause was like related to Network issues as opposed to application. Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 5:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline ** Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: Escalation Timeline
Yes the view form simply get you access to a "select * from escalation" but no other "formatting" so to say :( I was hopeful myself but... Robert On Thu, May 14, 2009 at 9:40 AM, Rick Cook wrote: > ** They provide pre-made forms displaying the metadata, but the underlying > data, at least for the escalations, appears to be the same. > > Rick > > Sent from my Verizon Wireless BlackBerry > > -- > *From*: "Kemes, Lisa" > *Date*: Thu, 14 May 2009 12:34:42 -0400 > > *To*: > *Subject*: Re: Escalation Timeline > > Does 7.5 have a way of viewing this info more easily? (I hope, I hope!) > > > Lisa > > > -- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Nicky Madjarov > *Sent:* Thursday, May 14, 2009 10:35 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Escalation Timeline > > ** It is kind of tricky, once you restart the ar server the interval based > escalations start counting from 0, so, every time the overall time line will > be different. > > Regards, > > Nicky Madjarov > phone: 973-202-4278 > Find out how to bust your AR System performance @ > http://www.SpeedUpARS.com <http://www.speedupars.com/> > > - Original Message ----- > *From:* Rick Cook > *Newsgroups:* public.remedy.arsystem.general > *To:* arslist@ARSLIST.ORG > *Sent:* Tuesday, May 12, 2009 11:32 AM > *Subject:* Re: Escalation Timeline > > ** That would make sense. A view form over the metatable would be a great > way of managing that data from the UT. You could set workflow against it to > change them and everything. > > I love everything about that idea except that I didn't have it a year ago. > > Rick > > Sent from my Verizon Wireless BlackBerry > > -- > *From*: "Grooms, Frederick W" > *Date*: Tue, 12 May 2009 10:24:57 -0500 > *To*: > *Subject*: Re: Escalation Timeline > > I did it with a query against the Escalation table in the database. > Unfortunately it was a good while ago so I don’t have the details right at > hand. > > > > Fred > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Pruitt, Christopher J > *Sent:* Tuesday, May 12, 2009 10:18 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Escalation Timeline > > > > ARInside would have been great for this, we still use it but that product > is no longer available or supported. I am hoping some new product comes > along soon. I am holding out for ARSmarts, but so far I have not seen one. > > > > *Christopher Pruitt* > Consultant Specialist > *EDS,* an HP Company > mailto:* **christopher.pru...@eds.com* > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Rick Cook > *Sent:* Tuesday, May 12, 2009 10:00 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Escalation Timeline > > > > Unless ARSmarts, Abydos, or some other tool does that, I don't know of a > way, either. I tried to think of one last year when looking at how to > multithread the escalations, and ended up just doing it manually. > > Rick > > Sent from my Verizon Wireless BlackBerry > -- > > *From*: "Schryver, Curt" > *Date*: Tue, 12 May 2009 10:52:33 -0400 > *To*: > *Subject*: Re: Escalation Timeline > > I started tinkering with something just last week to do this exact thing. > Didn't get too far, but will continue to play with it. (Unless someone > comes forward with an already-functioning application) > > > > *Curt A. Schryver* > 717-810-2109 tel > cschry...@tycoelectronics.com > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *O'Brien, Keith KOB. (Citco) > *Sent:* Tuesday, May 12, 2009 8:46 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Escalation Timeline > > > > Hi, > > Just wondering if there is a tool or process available to document the > timeline of all active escalations on a system. > > > > Regards, > Keith. > > > > > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > -- If it were not for the gutter, my mind would be homeless! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
They provide pre-made forms displaying the metadata, but the underlying data, at least for the escalations, appears to be the same. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: "Kemes, Lisa" Date: Thu, 14 May 2009 12:34:42 To: Subject: Re: Escalation Timeline Does 7.5 have a way of viewing this info more easily? (I hope, I hope!) Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Thursday, May 14, 2009 10:35 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** It is kind of tricky, once you restart the ar server the interval based escalations start counting from 0, so, every time the overall time line will be different. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Rick Cook<mailto:remedyr...@gmail.com> Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Sent: Tuesday, May 12, 2009 11:32 AM Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Does 7.5 have a way of viewing this info more easily? (I hope, I hope!) Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Thursday, May 14, 2009 10:35 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** It is kind of tricky, once you restart the ar server the interval based escalations start counting from 0, so, every time the overall time line will be different. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Rick Cook<mailto:remedyr...@gmail.com> Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Sent: Tuesday, May 12, 2009 11:32 AM Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
It is kind of tricky, once you restart the ar server the interval based escalations start counting from 0, so, every time the overall time line will be different. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Rick Cook Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, May 12, 2009 11:32 AM Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry -- From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don’t have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry -- From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Simile was the utility to graph timelines, but I never did anything with it
related to escalations.
http://simile-widgets.org/timeline/
It would be pretty if it graphed the expected and actual fire times of each
escalation though, esp. if it was dual banded like this example:
http://simile-widgets.org/timeline/examples/religions/religions.html
Axton Grams
On Wed, May 13, 2009 at 2:14 PM, Thad K Esser wrote:
> David,
>
> A couple of years ago Geoff Endresen posted the following that might help:
> -
> Subject: cool awk script to find out how late escalations are running
>
> Body:
> I don't know why it took me more than 10 years to figure out this one. The
> escalation log actually shows you if you are running late, for example if
> some escalation is taking so long that it delays others. If you never have
> had this problem they you probably have not tried hard enough.
>
> Whe the escalations are running late they create a log entry that has the
> currentime and the firetime
>
> I let the esclation log run overnight and I wanted to see how late (in
> seconds) the escalations were delayed. This works on our linux. I'm sure
> there are smart people that have solved this before, but I thought it was
> cool enough to share.
>
> % grep "set firetime of 1 second, firetime" arescl.log | awk '{print
> $23-$21, "late at", $20, $21, $22, $23, $24}' | grep -v "^0" | sort -nr |
> mail -s "late escalations report" yourem...@address.com
>
> The output looks something like this:
>
> 1495 late at firetime 1188930731, currenttime 1188932226
> 1097 late at firetime 1188973269, currenttime 1188974366
> 1093 late at firetime 1188961114, currenttime 1188962207
> 1090 late at firetime 1188934027, currenttime 1188935117
> 1023 late at firetime 1188942394, currenttime 1188943417
>
> --
> -Geoff Endresen
> -
>
> Also, I can't find it now, but didn't Axton post a link at one point for a
> utility to graph timelines?
>
> Thad Esser
> Remedy Developer
> "Argue for your limitations, and sure enough, they're yours."-- Richard
> Bach
>
>
> |>
> | From: |
> |>
>
>
> >--|
> |"Barber, David"
> |
>
>
> >--|
> |>
> | To:|
> |>
>
>
> >--|
> |arslist@ARSLIST.ORG
> |
>
>
> >--|
> |>
> | Date: |
> |>
>
>
> >--|
> |05/13/2009 07:59 AM
> |
>
>
> >--|
> |>
> | Subject: |
> |>
>
>
> >--|
> |Re: Escalation Timeline
> |
>
>
> >--|
> |>
> | Sent by: |
> |>
>
>
> >--|
> |"Action Request System discussion list(ARSList)"
> |
>
>
> >--|
>
>
>
>
>
>
Re: Escalation Timeline
David,
A couple of years ago Geoff Endresen posted the following that might help:
-
Subject: cool awk script to find out how late escalations are running
Body:
I don't know why it took me more than 10 years to figure out this one. The
escalation log actually shows you if you are running late, for example if
some escalation is taking so long that it delays others. If you never have
had this problem they you probably have not tried hard enough.
Whe the escalations are running late they create a log entry that has the
currentime and the firetime
I let the esclation log run overnight and I wanted to see how late (in
seconds) the escalations were delayed. This works on our linux. I'm sure
there are smart people that have solved this before, but I thought it was
cool enough to share.
% grep "set firetime of 1 second, firetime" arescl.log | awk '{print
$23-$21, "late at", $20, $21, $22, $23, $24}' | grep -v "^0" | sort -nr |
mail -s "late escalations report" yourem...@address.com
The output looks something like this:
1495 late at firetime 1188930731, currenttime 1188932226
1097 late at firetime 1188973269, currenttime 1188974366
1093 late at firetime 1188961114, currenttime 1188962207
1090 late at firetime 1188934027, currenttime 1188935117
1023 late at firetime 1188942394, currenttime 1188943417
--
-Geoff Endresen
-
Also, I can't find it now, but didn't Axton post a link at one point for a
utility to graph timelines?
Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard
Bach
|>
| From: |
|>
>--|
|"Barber, David"
|
>--|
|>
| To:|
|>
>--|
|arslist@ARSLIST.ORG
|
>--|
|>
| Date: |
|>
>--|
|05/13/2009 07:59 AM
|
>--|
|>
| Subject: |
|>
>----------|
|Re: Escalation Timeline
|
>--|
|>
| Sent by: |
|>
>--|
|"Action Request System discussion list(ARSList)"
|
>--|
We've got a sequence of escalations running on various schedules - 1
minute, 3, 5, 7, etc.
Catch is that one is taking considerably longer to run (instead of 1
minute, its taking between 20 and 60). While that one is being re-written,
thought I spend a bit of time trying to analyse how long the others are
taking.
Time for some text file parsing haven't done that in years.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of LJ Longwing
Sent: 13 May 2009 15:55
To: arslist@ARSLIST.ORG
Subject: Re: Escalation Timeline
You can check when they were supposed to run, and put that on a timeline
-Original Message-
From: A
Re: Escalation Timeline
We've got a sequence of escalations running on various schedules - 1 minute, 3, 5, 7, etc. Catch is that one is taking considerably longer to run (instead of 1 minute, its taking between 20 and 60). While that one is being re-written, thought I spend a bit of time trying to analyse how long the others are taking. Time for some text file parsing haven't done that in years. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of LJ Longwing Sent: 13 May 2009 15:55 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline You can check when they were supposed to run, and put that on a timeline -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: Wednesday, May 13, 2009 8:44 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Doh! You're right - timestamp is the create date or last modified date of the escalation. So unless there is another metatable hidden in there somewhere, then I can't go any further on this. If the last executed is stored internally within the servers memory, then you possible can't check the timeline of escalations without delving into the server logs? Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Grooms, Frederick W Sent: 13 May 2009 15:35 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline I thought timestamp was the create date of the escalation. The last executed is only in the server's memory -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: Wednesday, May 13, 2009 9:25 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Hi Rick, I should have posted - found it after a quick google. All I'd really is the escalation name (stored in the "NAME" field) and the time last run. Its the latter that appears to be dubious - on our live (load balanced) system, put the "timestamp" field into an epoch date convertor, and it seemed to give dates implying that the escalations hadn't run since yesterday. Checked the log files, and the escalations were running just fine. Didn't have this problem on our test systems though. It is handy to have it available via a quick bit of SQL - select name, timestamp from escalation order by timestamp find when last run. But as I said above, this only seems to work correctly on our test systems. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 13 May 2009 15:19 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline David, It's just called 'escalation' - always has been. Note that you will have to massage/parse some data and map some bitmasks to turn those into human readable values, etc., so it's not as simple as I might have made it sound. But as long as the translations go both ways, it should work. One thing of note is that neither the form name nor schemaId are in the escalation table. You have to map the escalation.escalationId field to the escal_mapping.escalationId field, and then use the schemaId column in escal_mapping to get the Form Name from arschema. That makes it tricky in non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, you can just join the view forms. But you could probably accomplish the same thing in any 7.x version by adding character fields to the escalations view form for the schemaId and name, and then using workflow to pull the data in. As is usually the case in AR System, there are multiple ways to skin that cat. The tables and data appear to be named and formatted the same in all 7.x versions, so it should migrate just fine. Rick On Wed, May 13, 2009 at 2:58 AM, Barber, David wrote: ** I'm interested about this - what is the relevant metatable to setup a view over? Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 12 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry ____________ From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From:
Re: Escalation Timeline
You can check when they were supposed to run, and put that on a timeline -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: Wednesday, May 13, 2009 8:44 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Doh! You're right - timestamp is the create date or last modified date of the escalation. So unless there is another metatable hidden in there somewhere, then I can't go any further on this. If the last executed is stored internally within the servers memory, then you possible can't check the timeline of escalations without delving into the server logs? Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Grooms, Frederick W Sent: 13 May 2009 15:35 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline I thought timestamp was the create date of the escalation. The last executed is only in the server's memory -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: Wednesday, May 13, 2009 9:25 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Hi Rick, I should have posted - found it after a quick google. All I'd really is the escalation name (stored in the "NAME" field) and the time last run. Its the latter that appears to be dubious - on our live (load balanced) system, put the "timestamp" field into an epoch date convertor, and it seemed to give dates implying that the escalations hadn't run since yesterday. Checked the log files, and the escalations were running just fine. Didn't have this problem on our test systems though. It is handy to have it available via a quick bit of SQL - select name, timestamp from escalation order by timestamp find when last run. But as I said above, this only seems to work correctly on our test systems. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 13 May 2009 15:19 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline David, It's just called 'escalation' - always has been. Note that you will have to massage/parse some data and map some bitmasks to turn those into human readable values, etc., so it's not as simple as I might have made it sound. But as long as the translations go both ways, it should work. One thing of note is that neither the form name nor schemaId are in the escalation table. You have to map the escalation.escalationId field to the escal_mapping.escalationId field, and then use the schemaId column in escal_mapping to get the Form Name from arschema. That makes it tricky in non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, you can just join the view forms. But you could probably accomplish the same thing in any 7.x version by adding character fields to the escalations view form for the schemaId and name, and then using workflow to pull the data in. As is usually the case in AR System, there are multiple ways to skin that cat. The tables and data appear to be named and formatted the same in all 7.x versions, so it should migrate just fine. Rick On Wed, May 13, 2009 at 2:58 AM, Barber, David wrote: ** I'm interested about this - what is the relevant metatable to setup a view over? Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 12 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry ____ From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On
Re: Escalation Timeline
Doh! You're right - timestamp is the create date or last modified date of the escalation. So unless there is another metatable hidden in there somewhere, then I can't go any further on this. If the last executed is stored internally within the servers memory, then you possible can't check the timeline of escalations without delving into the server logs? Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Grooms, Frederick W Sent: 13 May 2009 15:35 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline I thought timestamp was the create date of the escalation. The last executed is only in the server's memory -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: Wednesday, May 13, 2009 9:25 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Hi Rick, I should have posted - found it after a quick google. All I'd really is the escalation name (stored in the "NAME" field) and the time last run. Its the latter that appears to be dubious - on our live (load balanced) system, put the "timestamp" field into an epoch date convertor, and it seemed to give dates implying that the escalations hadn't run since yesterday. Checked the log files, and the escalations were running just fine. Didn't have this problem on our test systems though. It is handy to have it available via a quick bit of SQL - select name, timestamp from escalation order by timestamp find when last run. But as I said above, this only seems to work correctly on our test systems. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 13 May 2009 15:19 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline David, It's just called 'escalation' - always has been. Note that you will have to massage/parse some data and map some bitmasks to turn those into human readable values, etc., so it's not as simple as I might have made it sound. But as long as the translations go both ways, it should work. One thing of note is that neither the form name nor schemaId are in the escalation table. You have to map the escalation.escalationId field to the escal_mapping.escalationId field, and then use the schemaId column in escal_mapping to get the Form Name from arschema. That makes it tricky in non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, you can just join the view forms. But you could probably accomplish the same thing in any 7.x version by adding character fields to the escalations view form for the schemaId and name, and then using workflow to pull the data in. As is usually the case in AR System, there are multiple ways to skin that cat. The tables and data appear to be named and formatted the same in all 7.x versions, so it should migrate just fine. Rick On Wed, May 13, 2009 at 2:58 AM, Barber, David wrote: ** I'm interested about this - what is the relevant metatable to setup a view over? Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 12 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry ____ From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to mult
Re: Escalation Timeline
I thought timestamp was the create date of the escalation. The last executed is only in the server's memory -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: Wednesday, May 13, 2009 9:25 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Hi Rick, I should have posted - found it after a quick google. All I'd really is the escalation name (stored in the "NAME" field) and the time last run. Its the latter that appears to be dubious - on our live (load balanced) system, put the "timestamp" field into an epoch date convertor, and it seemed to give dates implying that the escalations hadn't run since yesterday. Checked the log files, and the escalations were running just fine. Didn't have this problem on our test systems though. It is handy to have it available via a quick bit of SQL - select name, timestamp from escalation order by timestamp find when last run. But as I said above, this only seems to work correctly on our test systems. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 13 May 2009 15:19 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline David, It's just called 'escalation' - always has been. Note that you will have to massage/parse some data and map some bitmasks to turn those into human readable values, etc., so it's not as simple as I might have made it sound. But as long as the translations go both ways, it should work. One thing of note is that neither the form name nor schemaId are in the escalation table. You have to map the escalation.escalationId field to the escal_mapping.escalationId field, and then use the schemaId column in escal_mapping to get the Form Name from arschema. That makes it tricky in non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, you can just join the view forms. But you could probably accomplish the same thing in any 7.x version by adding character fields to the escalations view form for the schemaId and name, and then using workflow to pull the data in. As is usually the case in AR System, there are multiple ways to skin that cat. The tables and data appear to be named and formatted the same in all 7.x versions, so it should migrate just fine. Rick On Wed, May 13, 2009 at 2:58 AM, Barber, David wrote: ** I'm interested about this - what is the relevant metatable to setup a view over? Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 12 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry ____________ From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list
Re: Escalation Timeline
Oooo, good catch, Fred. I forgot about that. It can get pretty complex, and in most installations there aren't that many escalations to manage. Which is why most of us just do it manually. Rick On Wed, May 13, 2009 at 7:26 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > Actually since an Escalation can run against multiple forms the list of > forms (from Escal_Mapping) should really be displayed as a table. > If you are just going to show a list of the forms then you could use an SQL > Set Fields action on display > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Rick Cook > Sent: Wednesday, May 13, 2009 9:19 AM > To: arslist@ARSLIST.ORG > Subject: Re: Escalation Timeline > > David, > > It's just called 'escalation' - always has been. Note that you will have > to massage/parse some data and map some bitmasks to turn those into human > readable values, etc., so it's not as simple as I might have made it sound. > But as long as the translations go both ways, it should work. > > One thing of note is that neither the form name nor schemaId are in the > escalation table. You have to map the escalation.escalationId field to the > escal_mapping.escalationId field, and then use the schemaId column in > escal_mapping to get the Form Name from arschema. That makes it tricky in > non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, > you can just join the view forms. But you could probably accomplish the > same thing in any 7.x version by adding character fields to the escalations > view form for the schemaId and name, and then using workflow to pull the > data in. As is usually the case in AR System, there are multiple ways to > skin that cat. > > The tables and data appear to be named and formatted the same in all 7.x > versions, so it should migrate just fine. > > Rick > > -Original Message- > On Wed, May 13, 2009 at 2:58 AM, Barber, David > wrote: > > I'm interested about this - what is the relevant metatable to setup a view > over? > > Ta > > Dave > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]on Behalf Of Rick Cook > Sent: 12 May 2009 16:33 > To: arslist@ARSLIST.ORG > Subject: Re: Escalation Timeline > ** That would make sense. A view form over the metatable would be a great > way of managing that data from the UT. You could set workflow against it to > change them and everything. > > I love everything about that idea except that I didn't have it a year ago. > > Rick > Sent from my Verizon Wireless BlackBerry > > -Original Message- > From: "Grooms, Frederick W" > Date: Tue, 12 May 2009 10:24:57 -0500 > To: > Subject: Re: Escalation Timeline > I did it with a query against the Escalation table in the database. > Unfortunately it was a good while ago so I don't have the details right at > hand. > > Fred > > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Pruitt, Christopher J > Sent: Tuesday, May 12, 2009 10:18 AM > To: arslist@ARSLIST.ORG > Subject: Re: Escalation Timeline > > ARInside would have been great for this, we still use it but that product > is no longer available or supported. I am hoping some new product comes > along soon. I am holding out for ARSmarts, but so far I have not seen one. > > Christopher Pruitt > Consultant Specialist > EDS, an HP Company > mailto: christopher.pru...@eds.com > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Rick Cook > Sent: Tuesday, May 12, 2009 10:00 AM > To: arslist@ARSLIST.ORG > Subject: Re: Escalation Timeline > > Unless ARSmarts, Abydos, or some other tool does that, I don't know of a > way, either. I tried to think of one last year when looking at how to > multithread the escalations, and ended up just doing it manually. > > Rick > Sent from my Verizon Wireless BlackBerry > > -Original Message- > From: "Schryver, Curt" > Date: Tue, 12 May 2009 10:52:33 -0400 > To: > Subject: Re: Escalation Timeline > I started tinkering with something just last week to do this exact thing. > Didn't get too far, but will continue to play with it. (Unless someone > comes forward with an already-functioning application) > Curt A. Schryver > 717-810-2109 tel > cschry...@tycoelectronics.com > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of O'Brien, Keith K
Re: Escalation Timeline
Actually since an Escalation can run against multiple forms the list of forms (from Escal_Mapping) should really be displayed as a table. If you are just going to show a list of the forms then you could use an SQL Set Fields action on display Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Wednesday, May 13, 2009 9:19 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline David, It's just called 'escalation' - always has been. Note that you will have to massage/parse some data and map some bitmasks to turn those into human readable values, etc., so it's not as simple as I might have made it sound. But as long as the translations go both ways, it should work. One thing of note is that neither the form name nor schemaId are in the escalation table. You have to map the escalation.escalationId field to the escal_mapping.escalationId field, and then use the schemaId column in escal_mapping to get the Form Name from arschema. That makes it tricky in non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, you can just join the view forms. But you could probably accomplish the same thing in any 7.x version by adding character fields to the escalations view form for the schemaId and name, and then using workflow to pull the data in. As is usually the case in AR System, there are multiple ways to skin that cat. The tables and data appear to be named and formatted the same in all 7.x versions, so it should migrate just fine. Rick -Original Message- On Wed, May 13, 2009 at 2:58 AM, Barber, David wrote: I'm interested about this - what is the relevant metatable to setup a view over? Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 12 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Hi Rick, I should have posted - found it after a quick google. All I'd really is the escalation name (stored in the "NAME" field) and the time last run. Its the latter that appears to be dubious - on our live (load balanced) system, put the "timestamp" field into an epoch date convertor, and it seemed to give dates implying that the escalations hadn't run since yesterday. Checked the log files, and the escalations were running just fine. Didn't have this problem on our test systems though. It is handy to have it available via a quick bit of SQL - select name, timestamp from escalation order by timestamp find when last run. But as I said above, this only seems to work correctly on our test systems. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 13 May 2009 15:19 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** David, It's just called 'escalation' - always has been. Note that you will have to massage/parse some data and map some bitmasks to turn those into human readable values, etc., so it's not as simple as I might have made it sound. But as long as the translations go both ways, it should work. One thing of note is that neither the form name nor schemaId are in the escalation table. You have to map the escalation.escalationId field to the escal_mapping.escalationId field, and then use the schemaId column in escal_mapping to get the Form Name from arschema. That makes it tricky in non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, you can just join the view forms. But you could probably accomplish the same thing in any 7.x version by adding character fields to the escalations view form for the schemaId and name, and then using workflow to pull the data in. As is usually the case in AR System, there are multiple ways to skin that cat. The tables and data appear to be named and formatted the same in all 7.x versions, so it should migrate just fine. Rick On Wed, May 13, 2009 at 2:58 AM, Barber, David < david.bar...@cw.com> wrote: ** I'm interested about this - what is the relevant metatable to setup a view over? Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org]on Behalf Of Rick Cook Sent: 12 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry _ From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: < arslist@ARSLIST.ORG> Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don’t have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry _ From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: < arslist@ARSLIST.ORG> Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com _ From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards,
Re: Escalation Timeline
David, It's just called 'escalation' - always has been. Note that you will have to massage/parse some data and map some bitmasks to turn those into human readable values, etc., so it's not as simple as I might have made it sound. But as long as the translations go both ways, it should work. One thing of note is that neither the form name nor schemaId are in the escalation table. You have to map the escalation.escalationId field to the escal_mapping.escalationId field, and then use the schemaId column in escal_mapping to get the Form Name from arschema. That makes it tricky in non-7.5 versions, because you'll have to do the joins in SQL. In 7.5, you can just join the view forms. But you could probably accomplish the same thing in any 7.x version by adding character fields to the escalations view form for the schemaId and name, and then using workflow to pull the data in. As is usually the case in AR System, there are multiple ways to skin that cat. The tables and data appear to be named and formatted the same in all 7.x versions, so it should migrate just fine. Rick On Wed, May 13, 2009 at 2:58 AM, Barber, David wrote: > ** I'm interested about this - what is the relevant metatable to setup a > view over? > > Ta > > Dave > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *Rick Cook > *Sent:* 12 May 2009 16:33 > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Escalation Timeline > > ** That would make sense. A view form over the metatable would be a great > way of managing that data from the UT. You could set workflow against it to > change them and everything. > > I love everything about that idea except that I didn't have it a year ago. > > Rick > > Sent from my Verizon Wireless BlackBerry > > ------ > *From*: "Grooms, Frederick W" > *Date*: Tue, 12 May 2009 10:24:57 -0500 > *To*: > *Subject*: Re: Escalation Timeline > > I did it with a query against the Escalation table in the database. > Unfortunately it was a good while ago so I don’t have the details right at > hand. > > > > Fred > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Pruitt, Christopher J > *Sent:* Tuesday, May 12, 2009 10:18 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Escalation Timeline > > > > ARInside would have been great for this, we still use it but that product > is no longer available or supported. I am hoping some new product comes > along soon. I am holding out for ARSmarts, but so far I have not seen one. > > > > *Christopher Pruitt* > Consultant Specialist > *EDS,* an HP Company > mailto:* **christopher.pru...@eds.com* > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Rick Cook > *Sent:* Tuesday, May 12, 2009 10:00 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Escalation Timeline > > > > Unless ARSmarts, Abydos, or some other tool does that, I don't know of a > way, either. I tried to think of one last year when looking at how to > multithread the escalations, and ended up just doing it manually. > > Rick > > Sent from my Verizon Wireless BlackBerry > -- > > *From*: "Schryver, Curt" > *Date*: Tue, 12 May 2009 10:52:33 -0400 > *To*: > *Subject*: Re: Escalation Timeline > > I started tinkering with something just last week to do this exact thing. > Didn't get too far, but will continue to play with it. (Unless someone > comes forward with an already-functioning application) > > > > *Curt A. Schryver* > 717-810-2109 tel > cschry...@tycoelectronics.com > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *O'Brien, Keith KOB. (Citco) > *Sent:* Tuesday, May 12, 2009 8:46 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Escalation Timeline > > > > Hi, > > Just wondering if there is a tool or process available to document the > timeline of all active escalations on a system. > > > > Regards, > Keith. > > > > > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > > This e-mail has been scanned for viruses by the Cable & Wireless e-mail > security system - powered by MessageLabs. For more information on a > proactive managed e-mail security service, visit > http://www.cw.com/uk/emailprotection/ > > The information contained in this e-mail is confidential and may also be > subject to legal privilege. It
Re: Escalation Timeline
I'm interested about this - what is the relevant metatable to setup a view over? Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rick Cook Sent: 12 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry _ From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 -0500 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don’t have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry _ From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
That would make sense. A view form over the metatable would be a great way of managing that data from the UT. You could set workflow against it to change them and everything. I love everything about that idea except that I didn't have it a year ago. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: "Grooms, Frederick W" Date: Tue, 12 May 2009 10:24:57 To: Subject: Re: Escalation Timeline I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
I did it with a query against the Escalation table in the database. Unfortunately it was a good while ago so I don't have the details right at hand. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher J Sent: Tuesday, May 12, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
ARInside would have been great for this, we still use it but that product is no longer available or supported. I am hoping some new product comes along soon. I am holding out for ARSmarts, but so far I have not seen one. Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Tuesday, May 12, 2009 10:00 AM To: arslist@ARSLIST.ORG Subject: Re: Escalation Timeline ** Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 -0400 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline ** Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
Unless ARSmarts, Abydos, or some other tool does that, I don't know of a way, either. I tried to think of one last year when looking at how to multithread the escalations, and ended up just doing it manually. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: "Schryver, Curt" Date: Tue, 12 May 2009 10:52:33 To: Subject: Re: Escalation Timeline I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline ** Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Escalation Timeline
I started tinkering with something just last week to do this exact thing. Didn't get too far, but will continue to play with it. (Unless someone comes forward with an already-functioning application) Curt A. Schryver 717-810-2109 tel cschry...@tycoelectronics.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of O'Brien, Keith KOB. (Citco) Sent: Tuesday, May 12, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: Escalation Timeline ** Hi, Just wondering if there is a tool or process available to document the timeline of all active escalations on a system. Regards, Keith. Disclaimer link. To see it, click the link below, or copy and paste it into your browser's address line. http://www.citco.com/emaildisclaimer.htm _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
