We have setup a database view to get a list of software installed on servers with their current version & lifecycle phase. We have used below tables. The problem is, the records seem to have duplication where multiple record with the same software and version installed on the same server appeared. Is there something that we could configure in the clause to fix this?
Another thing to achieve, how to filter for record with only latest phase start date?
