Hello!
I want to query the audit-login file with the queryappianlogs() function. The query is like this:
queryappianlogs( sqlStatement:"SELECT Username FROM login-audit WHERE Timestamp >= '2020-05-01' AND Timestamp < '2020-05-30' ORDER BY Timestamp DESC" ).data.Username
I want to get all the username during a period of time, but I need to add the dates dynamically. Is any way to do that, to put a rule input or local variable as parameter inside the query?
Thank you in advance!
Discussion posts and replies are publicly visible
Hello,
did not find documentation regarding this queryappianlogs. However, if you can request the data already, it is a matter of working with it after calling it. I would try as well with a Process Report to have that data. Then a processAnalytics function to call your data and filter it out.