Need help in exporting history of all incidents created within a assignment_group

[varun42]

I tried different options and finally could get the history of all incidents with following steps.

1)select single incident
2)in the incident form, right click->history-> list
3)near history bread crumb(copy url)
4)paste it to new browser with &CSV

this is bringing me following useful columns.

1) set ---which is incident number
2) label --state
3) old
4) new
5) updated time
6) updated by

But now I cannot relate which ticket belongs to which group to report groupwise.
so basically I want to add following column.is there anyway I can do it...?

7) assigned group.

Can someone help me.
Not sure why service now could not give such a easy feature in reports " to pull history of all incidents of a particular group"

Varun.

[#2]

You could simply running a report of all incidents with the fields you want and exporting that to excel? To me this seems like a very easy way to get what you want.

-Rich

[varun42]

Thanks for the reply.

I explored the options of running the report on incident table, which is giving me current state of all the records of a group.
But I need each incident past states as well ,like - who updated,what was the state during that time,what is old and new states like shown below. basically want information joining "incident" and "sys_audit" table.
to get following below columns.I understood I need to use database view plug in to join tables.

solutions woud be
a) create db view on incident and sys_audit. question is can I create view on sys_audit table, even if it is dangerours..?
b) make a new table and use rule to write into the new table whenever any event happens on incident.
not sure how to write script in a rule.

set label old new update_time user_name assigned group opened,openedby,closedby,resolved by,updated
INC0002079StateNew Active3/6/2012 12:24JohnsonIT
INC0002079State New 3/6/2012 11:26Kerry IT

INC0002078StateActive Closed3/6/2012 12:24JohnsonIT
INC0002078StateNew Active3/6/2012 12:24JohnsonIT
INC0002078State New3/6/2012 11:26Kerry IT