I run a query and get the table like this, user user_email content Jack [email protected] abcmdsfsadfsadfsadfsdf Mike [email protected] suiyeworuiweourwqoerw And I want to use command "sendmail" to send email to each user and the message is the content value. But looks like only the first user "Jack" can receive the email, Mike can't. Can you please shed a light, how to send email to multi users one by one? sendemail to=$result.user_email$ from="[email protected]" subject="This is testing!" message="Hi, it's your content $result.content$." sendresults=true inline=true format=raw ... View more

I run a command as below try to get all the locked out accounts, and get the date like %Y-%m-%d as well. But seems always get numbers. |ldapsearch domain=default search="(&(objectClass=user)(lockoutTime>=1)(!(objectClass=computer)))" attrs="sAMAccountName, lockoutTime, mail" | eval testDate=strptime(lockoutTime,"%Y-%m-%d")|rename sAMAccountName as assoc_user | table assoc_user, lockoutTime, testDate, mail assoc_user lockoutTime testDate↕ mail↕ s12345 2015-07-28T06:06:55.809482Z 1438005600.000000 [email protected] ... View more