Versions Compared

Version Old Version 2 New Version Current
Changes made by

MadanaGopal.Ragupathy@cognizant.com (Unlicensed)

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: 

  • Create your own .cql file with cypher query (As a.cql used in script)
  • Create your own .txt 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 server and port 587 for testing purpose




Top Section