Bill, On my past two systems (that had SLM) we trashed anything in the SLM:Measurement, older then 30 days and that was not tied to active ticket. I think we were able to report, but I don't remember from where.
hbr On Fri, Dec 19, 2008 at 12:35 PM, William Rentfrow < wrentf...@stratacominc.com> wrote: > ** It's Friday and I have some other stuff to finish today so I haven't > gotten too far into researching this yet - so I thought I'd ask if anyone > else has a solution for this already. > > Problem: SLM:Measurement is gigantic. We have 240,000 requests in HPD:Help > Desk (IM 7.x) and 4,400,000+ SLM:Measurement records. > > My gut feeling is to just archive off all of the records that are closed > and refer the reporting people to that table when they want to run reports; > however, I have not yet investigated the ramifications of doing this. > > Has anyone else? > > > William Rentfrow > > Principal Consultant, StrataCom Inc. > > wrentf...@stratacominc.com > > 701-306-6157 C > > 952-432-0227 O > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"