Report All CI Changes For A Given Period

[jfnewell1965]

Hello,

I would like create a simple report (simple to ask, maybe not simple to do!) that shows all CI changes for a given period…maybe a "Last 24 Hours" report, and a "Last Week Report". Eventually, I would like to create a report that narrows the changes down to just unauthorized changes, but for now just an idea of how to get all changes in a report form would be great.

I can see the changes on a per record basis as shown in this WIKI article: http://wiki.service-now.com/index.php?title=Baseline_CMDB , but I am not sure how to get all changes during a certain period into a report.

This appears to be a common request (see the links below), but I don't seem to be able to find a conclusive answer.

Any help or direction would be appreciated.
Jim

Reporting on global changes to CMDB CIs
Report for Change Management
http://community.service-now.com/node/1000735
Baseline differences report
Baseline Differences and Scheduled Changes Table

[david_legrand]

Hello Jim,

Maybe i didn't understand well your question, if necessary, don't hesitate to reply 🙂
I think your request is quite simple to do, for a first try, could you use the following options?

0) Create a new report and name it as you want then
1) Type : line chart
2) Table : Configuration item
3) Group by : none
4) Trend field : updated per hour or day (according the need)
5) Aggregation : Count
6) Filter : Updated on Today or Week (according the need)
7) (bonus) Add a second filter for the "unauthorized changes" if you have a field on the change form to discriminate the changes.

Tell me if that could manage your need.
David

[jfnewell1965]

Hi David,

Yes, I agree a count or trend is fairly easy, but I was thinking of a report along the lines of

"CI" - "Date/Time" - "User" - "Field" - "New_Value" - "Old_value"

Something that would more or less be a daily list of CI changes, and what those changes were. In effect (or fact) the ability to report on a CI's change history for a previous 24 hour period.

The long term goal would be the same information, but with a lookup of changes for the same time period that have a completed change request.

Jim

[david_legrand]

Ok, but i think we can't get the oldvalue Out Of the Box. A nasty (but quick) solution could be create 2 non visible fields (only visible for admin) named "name of the field of the modified value" and "old value of the modified value"

Then, you have a little list report to do.
I'm searching (i never had this question from my customer but it's very interesting for few of them) a better solution but for now, i don't have anything more clean.

If you find (or anyone else), tell me 🙂