How to create a comparison report based on specific dates?

Hello,

I'm struggling to create this report with a comparative analysis. I've searched in community but couldn't find anything. I need to create a comparison report that uses a data table with the following main columns: TSIM (String) | Object (String) | Object class (String) | Parameter (String) | Date (Date) | .

This table every day is filled with a copy from another table and it stores data for 15 days. I need a report the shows the changes from a specific date to another. The new registers, the deleted and change ones. For example: In December 10, there was the following data:

TSIM (String)

Object (String)

Object class (String)

Parameter (String)

Date (Date)

A

/

Filesystem

% Filesystem space used

12/10/2018

B

/

Filesystem

% Filesystem space used

12/10/2018

A

NT_Health

NT_Health

Memory Usage

12/10/2018

A

<hostname>

PPM_DEVICE

Availability

12/10/2018



In december 11, the table was like this:

TSIM (String)

Object (String)

Object class (String)

Parameter (String)

Date (Date)

A

/

Filesystem

% Filesystem space used

12/10/2018

B

/

Filesystem

% Filesystem space used

12/10/2018

A

NT_Health

NT_Health

Memory Usage

12/10/2018

A

<hostname>

PPM_DEVICE

Availability

12/10/2018

A

/

Filesystem

% Filesystem space used

12/11/2018

B

/

Filesystem

% Filesystem space used

12/11/2018

A

NT_Health

NT_Health

Total Processor Utilization

12/11/2018

A

C:

NT_Logical_Disks

Free Space

12/11/2018

How can I present in a report only the lines that were changed from Dec 10 to Dec 11, comparing the same line in different days? What about comparing the previous days? This table doesn't contain a key column that is unique.



I hope this is clear, but if not let me know.

Thanks a lot for any help!

Vinícius

(1) Answer

Login