Solved

script to monitor whether application URL available and trigger alert mail on the same

Posted on 2016-08-26
11
264 Views
Last Modified: 2016-08-31
I have two application URL like http://www.sample.com:1200/fyi/logon.html and https://servername.net:1200/fyi/logon_face.html.
After restarting the application services in windows server 2012, we try to load this URL in website to confirm its availability. I'm trying to automate it and send alert mail with URL status like URL is available or URL is down. I'm new to scripting so kindly help me with the code
Also please do note that webpage doesn't load, unless you give full URL with /logon.html etc.
0
Comment
Question by:V Thrusher
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 36

Expert Comment

by:Kimputer
ID: 41771491
Here's some code to get you started. It takes an url, and shows you the raw code.
What you can do it to check if this source code is what you'd expect from a correctly running server and then fire off an email command.
After you understand it, we can take further steps to tailor it to your needs.

Option Explicit

Dim goFS : Set goFS = CreateObject("Scripting.FileSystemObject")

dim csURL

check1()
check2()

Function check1()
  csURL             = "http://test.com/"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  msgbox sHTML
	'check something 
End Function

Function check2()
  csURL             = "http://test2.com/"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  msgbox sHTML
	'check something else
End Function

Function getURL(sURL)
  Dim oHTTP : Set oHTTP = CreateObject("Msxml2.XMLHTTP")
  oHTTP.Open "GET", csURL, False
  oHTTP.Send
  If 200 = oHTTP.Status Then
     getURL = oHTTP.responseText
  Else
     ' handle error\
	 'mail command
  End If
End Function ' getURL

Function mailcode(url)

End Function

Open in new window

1
 

Author Comment

by:V Thrusher
ID: 41773265
Thanks a lot .... i will try it out
0
 

Author Comment

by:V Thrusher
ID: 41773827
Option Explicit

Dim goFS : Set goFS = CreateObject("Scripting.FileSystemObject")

dim csURL

check1()
check2()

Function check1()
  csURL             = "https://www.experts-exchange.com/"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  'msgbox sHTML
	'check something 
End Function

Function check2()
  csURL             = "http://www.aspsnippets.com/Articles/Send-email-using-Gmail-SMTP-Mail-Server-in-ASPNet.aspx"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  'msgbox sHTML
	'check something else
End Function

Function getURL(sURL)
  Dim oHTTP : Set oHTTP = CreateObject("Msxml2.XMLHTTP")
  oHTTP.Open "GET", csURL, False
  oHTTP.Send
  If 200 = oHTTP.Status Then
     'getURL = oHTTP.responseText
     dim status = "Up" 
     mailcode (status)
  Else
     dim status = "Down"
     mailcode (status)
  End If
End Function ' getURL

Function mailcode(url)
dim sta = url
Set MyEmail=CreateObject("CDO.Message")

MyEmail.Subject="alertmail"
MyEmail.From="name@domain.com"
MyEmail.To="vishnuadithya52@gmail.com"
MyEmail.TextBody="Application services is &sta& "

MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2

'SMTP Server
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver")="smtp.gmail.com"

'SMTP Port
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=465 

MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate")=1
'Username
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername")="" 
'Password
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword")=""

MyEmail.Configuration.Fields.Update
MyEmail.Send

set MyEmail=nothing


End Function

Open in new window

0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:V Thrusher
ID: 41773829
i added a mail function to get triggered based on ping status but unfortunately its not working
0
 
LVL 36

Expert Comment

by:Kimputer
ID: 41774585
While the code is somewhat reliable, I made these two lines for a reason:

  'msgbox sHTML
	'check something 

Open in new window


Your check for the http 200 status, only tells you if the website is up. Not if it's displaying the correct page (could be a bandwidth alert, hacked site, script error etc etc). The 'check something' is to capture, for instance, the login form, or the correct header for the website. While still not always 100% correct (for instance, only after logging in you will get an error), it's far superior than just checking for the http 200 status.
Anyway, you can now continue finishing the script as you wish (or not, since it's working properly right now with below code).


Here's the updated code:

Option Explicit

Dim goFS : Set goFS = CreateObject("Scripting.FileSystemObject")
Dim status, sta, csURL, MyEmail

check1()
check2()

Function check1()
  csURL             = "https://www.experts-exchange.com/"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  'msgbox sHTML
	'check something 
End Function

Function check2()
  csURL             = "http://www.aspsnippets.com/Articles/Send-email-using-Gmail-SMTP-Mail-Server-in-ASPNet.aspx"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  'msgbox sHTML
	'check something else
End Function

Function getURL(sURL)
  Dim oHTTP : Set oHTTP = CreateObject("Msxml2.XMLHTTP")
  oHTTP.Open "GET", csURL, False
  oHTTP.Send
  If 200 = oHTTP.Status Then
     'getURL = oHTTP.responseText
     status = "Up" 
     mailcode status, sURL
  Else
     status = "Down"
     mailcode status, sURL
  End If
End Function ' getURL

Function mailcode(status, url)

Set MyEmail=CreateObject("CDO.Message")

MyEmail.Subject="alertmail"
MyEmail.From="name@domain.com"
MyEmail.To="vishnuadithya52@gmail.com"
MyEmail.TextBody="Application services " & url & " is " & status

MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2

'SMTP Server
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver")="smtp.gmail.com"

'SMTP Port
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=465 

MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate")=1
'Username
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername")="" 
'Password
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword")=""

MyEmail.Configuration.Fields.Update
MyEmail.Send

set MyEmail=nothing

End Function

Open in new window

0
 

Author Comment

by:V Thrusher
ID: 41774820
Thanks Kim for your feedback and i agree, but i'm not sure on how to compare the webpage contents  ??
0
 
LVL 36

Accepted Solution

by:
Kimputer earned 500 total points
ID: 41774890
First, open the webpage in your browser (using anonymous/incognito mode), and view the source.
Find what is unique about this working page and use a string from it. That's all!

Adjust script again, as needed (right now you'll get two updates, one if the site is up/down, one if the site returns what you'd expect or not). If a site gets redesigned, you'll probably have to adjust your script again.

Option Explicit

Dim goFS : Set goFS = CreateObject("Scripting.FileSystemObject")
Dim status, sta, csURL, MyEmail

check1()
check2()

Function check1()
  csURL             = "https://www.experts-exchange.com/"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  	if Instr(sHTML, "/plansAndPricing.jsp?cid=topnavjoin") then
		mailcode "working properly", csURL
	else
		mailcode "probably not working properly", csURL
	end if
	
End Function

Function check2()
  csURL             = "http://www.aspsnippets.com/Articles/Send-email-using-Gmail-SMTP-Mail-Server-in-ASPNet.aspx"
  Dim oDOM  : Set oDOM = CreateObject("HTMLFILE")
  Dim sHTML : sHTML    = getURL(csURL)
  
	if Instr(sHTML, "__doPostBack") then
		mailcode "working properly", csURL
	else
		mailcode "probably not working properly", csURL
	end if
	
End Function

Function getURL(sURL)
  Dim oHTTP : Set oHTTP = CreateObject("Msxml2.XMLHTTP")
  oHTTP.Open "GET", csURL, False
  oHTTP.Send
  If 200 = oHTTP.Status Then
     getURL = oHTTP.responseText
     status = "Up" 
     mailcode status, sURL
  Else
     status = "Down"
     mailcode status, sURL
  End If
End Function ' getURL

Function mailcode(status, url)

Set MyEmail=CreateObject("CDO.Message")

MyEmail.Subject="alertmail"
MyEmail.From="name@domain.com"
MyEmail.To="vishnuadithya52@gmail.com"
MyEmail.TextBody="Application services " & url & " is " & status

MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2

'SMTP Server
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver")="smtp.gmail.com"

'SMTP Port
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=465 

MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate")=1
'Username
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername")="" 
'Password
MyEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword")=""

MyEmail.Configuration.Fields.Update
MyEmail.Send

set MyEmail=nothing

End Function

Open in new window

0
 

Author Comment

by:V Thrusher
ID: 41774993
Thanks a lot Kim, i will try and let you know
0
 

Author Comment

by:V Thrusher
ID: 41775041
(sHTML, "/plansAndPricing.jsp?cid=topnavjoin") in this you are looking for planandpricing.jsp page if so below action take places. so what it cid=topnavjoin ?
0
 
LVL 36

Expert Comment

by:Kimputer
ID: 41775869
No, I said, you are looking for something unique on a working page. A non-user watching Expers Exchange, will always see this link if the page is working properly (until the page is redesigned).
It could also have been
	if Instr(sHTML, "Search Experts Exchange") then

Open in new window

As long as it's something unique on that page. Since a non-working page will have simple text like "Database down" or "Bandwidth problems" etc, when you get the error that the page isn't working, even though there's also a status the site is up, just visit the site to check what the error is.
0
 

Author Comment

by:V Thrusher
ID: 41776057
Thanks a lot for your help & support and i understood.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question