Dear All , Thanks For your support
i have come to develop more simple CMD script to check for the SAP systems on windows platform
i even added a feature to the script to send mail to you with the status of the system. P.s REM means a remark you dont have to write it in your batch file
Prerequisites:
---------------------
-Download SAPINFO.exe from http://www.filewatcher.com/m/sapinfo.exe.36935-0.html and place it is the dir where you will create the batch file.
- if you have Business Object SAP System you will need to download and install Nmap from http://nmap.org/
Code For Batch File:
-------------------------------
@echo off
rem we use sapinfo to check for the instance of the sap system and if its up the error lvl is 0 and if it is down it returns 1
rem this can work for abap servers or double stack servers but for java only stack servers we use other mechanism
rem in order to send mails you cant use .bat or .cmd file you have to use .vbs file
rem thankfully we have the "cscript " command that allow us to call a vbs file within bat file
rem so the bellow code is we sapinfo with the hostname or ip and the main instance no. of the system
rem if it returns one we call the downmail.vbs file cause that mean it have an error
rem else it returns 0 we call the upmail.vbs file cause it means it up and running
sapinfo ashost=HostnameORip sysnr=instanseNoOf Abap System & if errorlevel 1 ( cscript "<dir to your Downmail.vbs File" ) else ( cscript "dir to your upmail.vbs File" )
// the above code if the all the ABAP SAP Systems Not java Systems Like Enterprise portal
//you can repeat the above line over and over in the batch file for all your systems but note that
all of the above code should be in the same line for each system
// also each system should had its own DOWN and UP mail.vbs files to be accurate
E.G
sapinfo ashost=10.2.6.100 sysnr=00 & if errorlevel 1 ( cscript "D:\soldownmail.vbs" ) else ( cscript "D:\solupmail.vbs" )
Now the code for Java Only System E.g EPortal Read The Remarks carefully
------------------------------------------------------------------------------------------------------------------
rem below is the code for java only stack systems, it also uses the sapifno Technic
rem in hear we call the instance for java which is by default 01
rem if the server is up or down it returns an error cause java only servers doesn't have rfc configuration to them
rem however sapinfo sense the occurrence of a SAP GATEWAY and stats the FQN of the server its on
rem so when it sense the occurrence of the SAP GATEWAY it returns the FQN of the server
rem so we insert the output in a txt file and check for the server hostname on it if it find it it return error level 0
rem that means its up and if it returns 1 so no hostname was returned cause it didn't sense the sap-gateway which means the system is down
rem e.g in below the hostname is EPPRO and i have tested by putting the system down and it didn't return the FQN of the host
rem last step we delete the txt file cause it have no use anymore
rem Java Instance No. is usually 01 Unless you changed it
sapinfo ashost=hostnameORip sysnr=Java instanceNo. > D:\1.txt
find /c /i "EPPRO" D:\1.txt
if errorlevel 1 ( cscript "D:\EPPRODownmail.vbs" ) else ( cscript "D:t\EPPROupmail.vbs" )
del D:\1.txt
// This Technic is not official its a work around i made up cause the only way to check for java
only systems from CMD is Jcomn and it need interaction you cant use it as an automatic batch job
// Also you can repeat it over and over in the same batch file and make both codes for ABAP and JAVA Only systems in the same batch file it works fine
Now If you have a 3rd party System like SAP Business Object SBOP you will have to download nmap as i stated above
// SBOP uses a Web Server like Tomcat ,, this web server have its own port that you define while installing It is most commonly 8080 so when need to ping this port some how not the host cause the host could be up but the web server is down , this cant be achieved by the normal Ping command
so we use Nmap
Here is the code :
----------------------------
nmap -p8080 IPADDRESS >D:\2.txt
find /c /i "CLOSED" D:\2.txt
if errorlevel 1 ( cscript "D:\SBOPupmail.vbs" ) else ( cscript "D:\SBOPdownmail.vbs" )
del D:\2.txt
//Nmap returns (web server is down case :
Nmap scan report for IPADDRESS
Host is up (0.0071s latency).
PORT STATE SERVICE
8080/tcp closed unknown
Nmap done: 1 IP address (1 host up) scanned in 18.07 seconds
// so we look for CLOSED if it is absent in the txt file that means its up and running cause when it is up and running the state is open so you can either check for closed or open in my case i choose closed
Nmap scan report for IPADDRESS
Host is up (0.0071s latency).
PORT STATE SERVICE
8080/tcp open http
The Mail.vbs Code :
------------------------------
Set objMail = CreateObject("CDO.Message")
Set objConf = CreateObject("CDO.Configuration")
Set objFlds = objConf.Fields
objFlds.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objFlds.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "<SMTPName Or Ip>.DOMAN.com"
objFlds.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
'uncomment next three lines if you need to use SMTP Authorization
'objFlds.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "<Username on the domain>"
'objFlds.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "<password>"
'objFlds.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
objFlds.Update
objMail.Configuration = objConf
objMail.From = "<whatever_you_want@Bla.Bla>"
objMail.To = "<Your Mail>"
objMail.cc = "<Any mail or leave empty>"
objMail.Subject = "<Name of system>"
objMail.TextBody = "<Name : State>"
objMail.Send
Set objFlds = Nothing
Set objConf = Nothing
Set objMail = Nothing
// replace all that is between <> with its relevant
SAPROUTER check :
//you can add this code as well to your batch file to check for your sap router service
TASKLIST /S <host or ip>/U <username> /P <password> /FI "imagename eq <name of the service and the extension>" /svc & if errorlevel 1 ( cscript "D:\SRDownmail.vbs" ) else ( cscript "D:\SRupmail.vbs" )
// remember all in the same line in the batch file otherwise you may get errors
//name of service is usually "saprouter.exe"
//username and password for an admin host user
------------------------------------------------------------------------------------------
And That's Every Thing it works great like a charm with me and saves me alot of time also makes me Pro-active by scheduling a task on windows to run the batch file every day before working hours by an hour and also i run a batch file that only sends mail if system is down every 1 hour
Feel Free to ask me for anything , Hope it helps
Regards,
Ahmed Salam.
Message was edited by: Ahmed Salam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.