How to distinct count the row value?

My objective is, I want to verify some asset from my user. So I have to run some script that contains the hardware information such as below.   EmID Name LastName Asset CPU GPU Monitor S/...