CMDB baseline comparison report

[rhofing]

I would like to be able to run a report that compares two baselines and displays the differences between them. I have looked and can't find anything like this. Is there a way to do this?

Ric

[sharmas]

Hi Ric,
Go on the list view of the baselines and select any two records which you want to take the report of. Now right click on the list and from the options that come select bar chart or pie chart, by doing this it gets displayed on a new page and "Run Report" option comes alongwith clicking on which you can see the whole report console from where you can easily run the report and get the details.

I hope it helps....


SS

[rhofing]

Hi SS, I have four baselines in the Baseline view. If I select two of them, then select bar or pie chart I get a report that shows four bars (or pie pieces). This is what I get no matter how many baselines I select. What I want to see is the differences between the baselines. For example, if I have added a server after the first baseline, then take a second baseline, then compare the two I would like to be able to see that the difference between baseline 1 and baseline 2 is the server I added.

Ric

[sharmas]

Hey Ric, I saw what you are trying to say.....so lets try a different approach. Instead of the cmdb_baseline form directly go to the Report Console and make a new report and select the table there as "cmdb_baseline" and in the group by option select "Name" and also use the filter as NAME starts with "first letter of your baseline". So now what happens is be there n number of records in the baseline list but it will only pick those records which you wanna take the report of.
You can increase the number of filters if you want according to your ease. Dont forget to select "display grid" so that you get the details below the filter as required by you.

Lets see if it works this time....

SS

[rhofing]

I am getting closer. I ran a report using the cmdb_baseline_entry table, filtering on the two baselines that interest me. I get a bar chart report that shows two bars, and a count of CI's for each. In baseline 1 I have 1839 CI's. In baseline 2 I have 1842 CI's, which is a difference of three CI's. Now what I would like to do (and this is where I am stuck), is display those three CI's that exist in baseline 2 but not in baseline 1.

Ric