For your first question, I didn't get the + symbol at all. After the time I gave you, the report page displayed with 1/253 pages.
For the 2nd question, the CSV export was done on all fields on the incident form for that qualification which returned 2138 records. The time to completion was: 2 minutes, 38 seconds. Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rabi Tripathi Sent: Monday, February 09, 2009 7:38 PM To: [email protected] Subject: Re: Somebody please run this ITSM 7 report for me Wow, that puts my system to shame. How many pages did you get in the report? Can you please confirm that you waited until info about all the incidents were loaded on the "Report Preview" screen and that the page counter such as "1/7+" did not have the "+" sign any more? One last favor...can you pleas use the same search criteria on Incident screen and report on all the incidents, and report on all fields to a csv file and tell me how long for that csv report to complete? I want to confirm my theory that I have general slowness in my setup compared to yours, that accounts for all or a big part of the report slowness here? Thanks a lot for trying this out for me. --- On Mon, 2/9/09, Chowdhury, Tauf <[email protected]> wrote: > From: Chowdhury, Tauf <[email protected]> > Subject: Re: Somebody please run this ITSM 7 report for me > To: [email protected] > Date: Monday, February 9, 2009, 5:52 PM > Rabi, > Here's the qualification I ran on that canned report > (in user tool): > ('1000000560' >= "02/01/09 12:00:00 > AM" AND '1000000560' <= "02/09/09 > 5:43:53 PM") > > It returned 2138 records and it took 1 minute, 12 seconds. > Work info IS included in my system. > > I am currently in the same building as the datacenter that > houses both the App servers and DB server. Obviously, the DB > is remote to the application. DB is oracle. > Our App servers are virtual servers on Win2k3 with 8gb of > RAM and Quad 3ghz xeon processors. > Not too sure about the DB but it is running on an AIX > cluster with a Gig Ethernet link. > Hope this helps. > > > Tauf Chowdhury > Analyst, Service Management > Office: 631.858.7765 > Mobile:646.483.2779 > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Rabi Tripathi > Sent: Monday, February 09, 2009 2:04 PM > To: [email protected] > Subject: Somebody please run this ITSM 7 report for me > > Hi all, > I have complaints of slow or never-ending reporting in ITSM > 7. After a lot of looking around, I am wondering if the > inherent design of the reports is a big factor. Such as a > Join done in the report (with a subreport), ODBC overhead > etc. > > Can somebody run this report for me and tell me how long it > takes. If you can use Remedy User instead of a browser and > do this on a powerful box (may I suggest production?) that > would be nice-- > > Incident Management Console->Reports > > On "ReportSelection" popup choose this > "Report Name": > Incident->Incident Information->All > Incidents->Incicent Details By Date Range > > For "Start Date" and "End Date" select > dates that would give you at least 500 Incidents in your > environment. Closer to 1000 would be nice. > > Choose "Destination" = "Screen" > > Click "Run Report" and start your "Stop > Watch" > > On the prompt asking for titles, just click "Ok" > > Let me know: > (1) how long until the report completes...meaning > ReportViewer pop-up has finished loading all data (hint > where it shows page info like this "1/6+", > presence of "+" means its still loading more. > > (2) how many Incidents did you catch > > (3) does your report have "work info" included > for incidents? > > (4) Quick detail of your environment. The network path > between your PC and the server, how "strong" is > the AR Server/Database > > Ok, it's quite some work...but may I plead that I would > do this for you? :) > > If you want to be really nice to me, if you could do the > same report such that your date criteria catches no > Incidents at all, how much time till the Report windows > shows up and completes loading with no info on the report? > > Thank you in advance. > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the > Answers Are" > > ********************************************************************** > This e-mail and its attachments may contain Forest > Laboratories, Inc. proprietary information that is > privileged, confidential or subject to copyright belonging > to Forest Laboratories, Inc. This e-mail is intended solely > for the use of the individual or entity to which it is > addressed. If you are not the intended recipient of this > e-mail, or the employee or agent responsible for delivering > this e-mail to the intended recipient, you are hereby > notified that any dissemination, distribution, copying or > action taken in relation to the contents of and attachments > to this e-mail is strictly prohibited and may be unlawful. > If you have received this e-mail in error, please notify the > sender immediately and permanently delete the original and > any copy of this e-mail and any printout. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the > Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
