In EPO Console system properties for Client machines one of the properties " Last communication".
same properties is available in sql server?
Currently i am able to see in the table EPO Leafnode properties name: lastupate.
I have checked the Last communication in EPO Console & Last update details in sql table.both time stamp is not matching.
In which table i have to find the Last Communication details. Please help me in this regard.
Thats the right table and column (LastUpdate). It looks like ePO stores the LastUpdate column timestamp in UTC and then converts probably via a function when presenting it in the front end.
If your trying to run a query in the backend, you'll need to find the function or write a conversion.. see below: