Query with big numbers (lastlogontimestamp)
I am trying to find all machines with a lastlogontimestamp greater than 1st July 2012. I tried this query: select SMS_R_System.NetbiosName, SMS_R_System.LastLogonTimeStamp from SMS_R_System where SMS_R_System.LastLogonTimeStamp > 129855767893444959 order by SMS_R_System.LastLogonTimeStamp but it doesnt work. I cannot use AS BIGINT as I get a syntax error. Is there any way to do this please? Thanks David Z
August 29th, 2012 5:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics