Hi ,

I'm trying to create a query report on devices based on lastcontacttime, however it doens't seem to work either through a SSMS query or using the longtodate, all the data is from the systeminfo table