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

Here's an older thread discussing the use of LastLogonTimeStamp in a collection query: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/42335fa7-bf95-46f0-a067-02dbc31611f5 Here's an easy way to use it in a report: http://www.myitforum.com/absolutenm/templates/Articles.aspx?articleid=14349&zoneid=87 The question I would have is are you actually going to target software, updates, or baselines based on this criteria? Probably not. Then why are you doing this in WQL instead of a SQL report? Building collections is meant for targeting activities in ConfigMgr, not reporting or tracking.Jason | http://blog.configmgrftw.com

Here's an older thread discussing the use of LastLogonTimeStamp in a collection query: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/42335fa7-bf95-46f0-a067-02dbc31611f5 Here's an easy way to use it in a report: http://www.myitforum.com/absolutenm/templates/Articles.aspx?articleid=14349&zoneid=87 The question I would have is are you actually going to target software, updates, or baselines based on this criteria? Probably not. Then why are you doing this in WQL instead of a SQL report? Building collections is meant for targeting activities in ConfigMgr, not reporting or tracking.Jason | http://blog.configmgrftw.com