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