Versions Compared

Version Old Version 1 New Version Current
Changes made by

MadanaGopal.Ragupathy@cognizant.com

Abirami

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top1
top1

Image Removed


Tip

Here is a .bat script to trigger mail as result of Neo4j Cypher query execution? Like to know agent running and data duplication status as examples.



Expand
titlePrerequisite


Panel
titleCopy and paste the sample script and modify based on your requirement


Panel

@echo off
cd C:\Insights\InSights_V1.0\Server1\neo4j-community-3.0.6\bin
call neo4j-shell.bat -file C:\Insights\a.cql > C:\Insights\sendEmail-v156\test.txt
findstr /C:"| 0" C:\Insights\sendEmail-v156\test.txt
ECHO %ERRORLEVEL%
if ERRORLEVEL 1 (
echo "String NOT found..."
) else (
echo "String found"
cd C:\Insights\sendEmail-v156
sendEmail.exe -f fromaddress -t toaddress -s smtp.gmail.com:587 -o tls=auto -xu username -xp password -u "Subject" -m "This is test mail" -a test.txt
)


Note: 

  • aCreate your own .cql contains file with cypher query test(As a.cql used in script)
  • Create your own .txt contains to write output of cypher query (As test.txt used in script)
  • findstr command checks literally existence of "| 0" in test.txt file
  • sendEmail.exe sends a mail
  • Used Gmail gmail server and port 587 for testing purpose




Top Section