Web page status monitor

[Timothy Ryner]

Our organization has hundreds of sites & web apps, and no widely available “Uptime Robot” for teams to automatically notify them of accessibility issues. Everyone develops their own internal solutions, if anything at all. I’m looking to use Jira and Scriptrunner to deliver this kind of service. 

The plan is:

• create a new project “PING”
• use two custom fields “Website” (URL) & “Response” (Number)
• Use a simple workflow “Site Up” & “Site Down”
• allow users to create new issues for their site, they provide the URLs and Response info.

I need help writing the script. Not groovy fluent, so I’m going to start trying to piece this together. 

• Use a Scriptrunner Job to run a script every few minutes.
• Script looks at each issue in the PING project, grabs the URL and Response values and runs a connection check. 
  When the response matches, transition to “Site Up”. When the response doesn’t match or times out, transition to “Site Down”. 
  
  

We also have the Automation plugin at our disposal, but not sure it’s necessary or simplifies much. 

This is going to be a fun project, and I think a lot of people could get some good use from it!  Any help from the community is greatly appreciated!!

[Piotr Bojko]

With this addon - https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview - you can query JIRA with SQL straight from the app or through the special JDBC without to worry about permissions to data.

[Tuncay Senturk _Snapbytes_]

All custom fields are stored in customfields table in Jira.

Also you can find options and values in customfieldoption and customfieldvalue tables.

Is that what you were asking for?

[Frank]

Yes, I am looking for sql query.

[フェリックス]

Something simple to get you started? :

select * from customfield limit 10;
select * from customfieldoption limit 10;
select * from customfieldvalue limit 10;

How are you intending to query?