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"
