I am trying to build a report from the PatchHistory table in LDMS. The table contains the results of installing patches on computers. If a patch install was attempted multiple times on a single computer, then there will be an entry for each attempt in this table. I want my report to only include a single entry for each computer with a specific patch and the result of the most recent attempt.
Sample Data in PatchHistory Table:
|Computer_A||Patch_1||5/1/2017||Fail for reason x|
|Computer_A||Patch_1||5/10/2017||Fail for reason x|
|Computer_A||Patch_1||5/20/2017||Fail for reason x|
I only want the last row in my report. Can this be done in the Expression for Date or do I have to create a new table that contains only the most recent entries for each computer given the patch?