First time here? Check out the FAQ!
Ask Your Question
0

NEREN Active Agents by Update date range

Having trouble getting results for ActiveAgents using U_UpdateDate in search query while U_user_is_active works fine.

Using "((U_UpdateDate={$datewalkstart}T00:00:00+),(U_UpdateDate={$thenewdate}T23:59:59-))" where $datewalkstart is the start date and $thenewdate is the end date does not return anything.

Any help appreciated. Thanks.

edgewrx's avatar
edgewrx
asked 2017-04-18 10:16:16 -0500
edit flag offensive 0 remove flag close merge delete

Comments

Is this: {$datewalkstart} a macro substitution you are doing on your side? Also the U_UpdateDate is in UTC.

bwolven's avatar bwolven (2017-04-18 11:07:04 -0500) edit
more
  • delete

Yes this is PHP - the same date variables work fine for all other tables - just ActiveAgent returns no results when using dates.

edgewrx's avatar edgewrx (2017-04-18 11:19:39 -0500) edit
more
  • delete

What is your account name? NO Passwords please.

bwolven's avatar bwolven (2017-04-18 11:32:03 -0500) edit
more
  • delete

username = edc61212

edgewrx's avatar edgewrx (2017-04-18 12:05:42 -0500) edit
more
  • delete
add a comment see more comments

1 Answer

0

In our logs, I see 117 ActiveAgent search requests with the same date range query:

((U_UpdateDate=2016-10-01T00:00:00+),(U_UpdateDate=2016-10-02T23:59:59-))

There were not any active agents updated with that 2 day range.

If I use a query like: (U_UpdateDate=2016-10-31T23:59:59-)) I show 7 agents.

bwolven's avatar
bwolven
answered 2017-04-18 14:02:35 -0500
edit flag offensive 0 remove flag delete link
more

Comments

my bad - was not handling empty results which caused failure on my end - have updated and successfully run. thank you

edgewrx's avatar edgewrx (2017-04-18 14:41:07 -0500) edit
more
  • delete
add a comment see more comments

Your Answer

Login/Signup to Answer