How to compare two records in a table and highlight all the differences?

[SuryaTeja]

on cmdb_ci_server table we have 3500 servers. I need a report to be created when we pull 2 servers from the servers table and compare them. The differences should be highlighted. 

1.pick 2 servers from servers list.

2.Compare all the column values and the related column values.

3.Highlight the differences. 

[Josh Cooper]

That's a cool idea, but not something that we handle out of the box.  It shouldn't be too hard to make a custom application that would do it, with a custom table, two reference fields back to cmdb_ci_servers and then extended fields with a style applied, but there's not a way I know of to do it with basic reporting.

Probably easiest would be to export the records in question to Excel and apply formula formatting.  Like if b2 doesnt equal c2, then paint it yellow.  Then you could reuse the worksheet.

[SuryaTeja]

Thanks for the reply. We are following that Excel thing right now. We want to implement something like that in ServiceNow. 

[Ganesan5]

Hi Surya, any update how you solve this problem? I think for comparing we can try Multi-Pivot, but unable to filter further like exclude records that more than 2.