I need to remove rows that have duplicates PC_NAME, but I cannot seem to get it working.
I can only make it work if I select one object but I need to returns the entire rows.
I do not care what DATA is in the row, I only need to make sure that the PC_NAME is unique.
Let’s say I have this data:
I want to return this:
This script is only returning the PC_NAME and not the entire rows:
$my_filtered_data = $pc_list | Select-Object -Property PC_NAME -Unique