I’m trying to find systems that have not had a successful BigFix Inventory Scan in the last 7 days.
I’m thinking of using "Time of Last Successful Scan for Software Identification Tag Files (Software Scan Status)"
from Software Scan Status Analysis from BigFix Inventory External Site for comparison. That gives me date/time string in the format:
YYYY-MM-DD hh:mm:ss UTC
and comparing it to now - 7 * day
I did the following to try to get the string to a time format, but this is as far as I got…
q: (first 4 of it as integer * year) of "2019-08-09 05:23:15 UTC"
A: 2019 years
I: singular number of months
q: ((last 2 of preceding texts of last "-" of it) as integer * day) of "2019-08-09 05:23:15 UTC"
A: 8 days
I: singular time interval
q: ((first 2 of following texts of last "-" of it) as integer * month) of "2019-08-09 05:23:15 UTC"
A: 9 months
I: singular number of months
q: ((first 2 of following texts of first " " of it as integer * hour) + ((first 2 of following texts of first ":" of it) as integer * minute) + ((first 2 of following texts of last ":" of it) as integer * second)) of "2019-08-09 05:23:15 UTC"
A: 05:23:15
I: singular time interval
Does anyone have an idea of what can be done to get this comparison working?
I’m trying to find a way to run another scan on machines that were missed in the last 7 days without scanning everything again (~100,000 machines)
Thanks for any help,
Bob_K