[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

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

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
V Thrusher
Asked:
V Thrusher
  • 7
  • 4
1 Solution
 
KimputerCommented:
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
 
V ThrusherAuthor Commented:
Thanks a lot .... i will try it out
0
 
V ThrusherAuthor Commented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
V ThrusherAuthor Commented:
i added a mail function to get triggered based on ping status but unfortunately its not working
0
 
KimputerCommented:
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
 
V ThrusherAuthor Commented:
Thanks Kim for your feedback and i agree, but i'm not sure on how to compare the webpage contents  ??
0
 
KimputerCommented:
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
 
V ThrusherAuthor Commented:
Thanks a lot Kim, i will try and let you know
0
 
V ThrusherAuthor Commented:
(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
 
KimputerCommented:
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
 
V ThrusherAuthor Commented:
Thanks a lot for your help & support and i understood.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now