Hi,
If you do an advanced search for ('Attachment' != $NULL$), you will get the
count of attachment records. The percentage should be easy from there.
To get the uncompressed size of each attachment, it is trickier.
There are one non-direct-sql way I can think of, and that is to create a
display-only-field and a filter:
Filter Execute On: Get Entry
Run If: ('Attachment' != $NULL$)
Set-Fields:
AttachmentSizeInteger: SUBSTR(STRSTR($Attachment$, ";")+1, $Attachment$)
This will get you the uncompressed size of the attachment in the
AttachmentSizeInteger display-only field. If I did not make a typo.
If you then create a normal AR Report, you can do an AVERAGE operation on that
display-only-integer-field.
You can also go straight to the database B-table where the same information
with uncompressed size can be found.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* 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.
> I am trying to find out following
> 1. % of incident tickets with attachment:
> 2. Average size of the incident ticket:
> 3. Average size of attachment to incident ticket
>
> Any help on this is appreciated.
>
> thanks
>
> _______________________________________________________________________________
> 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"
