Need report of incident ever assigned to a group

[sapna_sagar]

Hi Expert,

I need a report of incident assigned to a particular group ever (Means if support a incident is asigned to BAC group but now it is assigned to ABC so i want this ticket too in report because It was assigned to BAC at some point of time.)

I tried by Keyword search but It giving some incident in which BAC group is available and even some incident in which it is not available so it is not working correctly. Any other idea??

[Chuck Tomasi]

Hi Sapna,

You will need to look through the sys_history_line table which can be quite large and may take a while to produce your report. The table contains the field/value pairs for a record anywhere in it's history.

[sapna_sagar]

Same i am doing but i doubt .

The result should come large but it is actually not large (contain only 100-150) record while if i am making report by seraching keyword , the result is approx 600 which is close to correct.

filter on sys_history_line :

[sapna_sagar]

Hi Chuck,

I tried report on sys_audit table because sys_history_line dont give full data.

but still same issue. currently incident assigned to ABC group is 600 so history data should come more than this because here i am including every incident where ABC touch.

but only getting 300 records.

[The SN Nerd]

Sounds like what you really need (in retrospect) is metrics on the assignment group field.