querying Multiple Computer With wmi in c#

Question

Thank you,

Answer 1

Your tbl_target table missing the column name of year. If you include that column name then you can filter the data 501 employee id may month of 2017. or else you will have two 501 record with same month.

 

Another option also you can add one more column Created_Date in that you can get year.

Answer 2

You need to join both the tables and get/track the employee records