Look up for Big Data

This is for the purpose to analyse which systems are not updated with recent version of the antivirus.

So we generate report from 3 different sources, One for windows machine, another for Linux and for MAC.

So we need to compare the latest version and the updated date on each machine and need to work on the machines which was not up to date.

So for this purpose, Look up is not helping (Since we have 2.5 Lakhs windows machines and 1 lakh of linux machines). Any other option is encouraged, since am out of options from my end.