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.

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

4

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).

Answered 09/28/2012 by: chucksteel
Red Belt

  • Thanks, CS. That's the ticket. I had tried the < and the % separately, so putting them together did it.
Please log in to comment

Answers

1

I've never done this in advanced search, but you can create a report for this.

SELECT NAME, LAST_SYNC

FROM MACHINE

where (LAST_SYNC > CURDATE() - INTERVAL 1 DAY)

order by name
Answered 09/27/2012 by: dugullett
Red Belt

  • Thanks. I have a report that sorts by last date. It doesn't filter, but I can sort and filter the csv file. The reason I want to have it work in the advanced search is because it will simplify the work I need to do in kbox; for example, checking the non-syncing computers against another db before removing from kbox.
Please log in to comment
1

Since last sync is one of the fields shown in the list I just sort by that and go from there.

Answered 09/28/2012 by: chucksteel
Red Belt

Please log in to comment
1

You could also use a Smart Label to do thi.  Just take what dgullett gave you and create a Smart Label using that for the SQL query. Just change the last line to order by the sync, i.e.:

SELECT NAME, LAST_SYNC
FROM MACHINE
WHERE (LAST_SYNC > CURDATE() - INTERVAL 1 DAY)
ORDER BY LAST_SYNC

If you need help setting up a Smart Label, check this out:

K1000 Labels - Effective Organization & Process Flow Using Manual, Smart & LDAP Labels and Label Groups

http://www.itninja.com/blog/view/k1000-labels-effective-organization-process-flow-using-manual-smart-ldap-labels-and-label-groups

John

Answered 09/28/2012 by: jverbosk
Red Belt

  • But smart labels only apply when the machine syncs, so wouldn't this label never get applied to a machine?
Please log in to comment
Answer this question or Comment on this question for clarity