Inventory search on last sync
Advanced Search has "Last Sync" as a criteria, but I can't figure out how to filter. EG, I'd like to find all computers that have not checked in for more than a day, so I tried Last Sync contains d, but that doesn't work. * doesn't work at all as a wild card - no results found. % kinda works, but not in a useful way. If I put % by itself, it returns all my PCs, but I can't use % with the characters d, h or any number.
Sorting without filtering isn't helpful because I want to filter the last sync, then order by computer name.
Any ideas? Thanks.
Community Chosen Answer
I played with this some more and it looks like the Advanced Search does a comparison with the value in the database (even though it displays it as the relative difference). Knowing that I did a search for Last Sync < 2012-09-27% and got machines that haven't checked in since yesterday. The value is stored in the DB as yyyy-mm-dd hh:mm:ss so searching for Last Sync < 2012-09-27 15:% got even more specific to computers the checked in over one day ago (since it's is almost 4:00pm here as I'm writing this).