Hi, Thanks for the response. It will be future tickets beginning when the warranty ends.
David -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Tuesday, January 21, 2014 3:12 PM To: [email protected] Subject: Re: Workflow ideas Hi, Are we talking about the future or old records? I would seriously consider creating and enforcing a more structured way to point Help Desk tickets towards assets (one to one or one to many)? If it is easy to spot the numbers in text, you could create one or more relationship records based on Short Description and Details. Maybe using a guide and a tmp-field looping through the data until all PCs has been found and a corresponding relationship record created. When you have your relationships stored in a table, you can do a join and report on assets flagged for counting. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Good day. > > Mostly custom site her using AR 7.1 on Windows server and SQL. I have > a request to track HelpDesk tickets involving particular PCs in assets that > have > gone off warranty. I have flagged the pcs in the asset file and need a way > to track and report on the helpdesk tickets which have the particular > asset number in either the Short Description or the Details. Just > wondering if anyone would have an idea of the best way to handle this. > Thanks in advance for any suggestions. > > David Morrison > East Tennessee State University > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
