Ask a Question

Extract data out of Alertsite XML

rkay1985
Not applicable

Extract data out of Alertsite XML

Hi Guys,



I'm having a bit of a nightmare trying to figure out how to echo out part of an xml that alertsites API generates.



Basically I'm after the latest / last Timiings Total value. Any ideas on a way this can be extracted via VBS ?




<Measurement Timestamp="2013-09-10 16:58:25">


<Timings Total="0.0756" Connect="0.0051" Content="0.0004" Dns="0.0008" Firstbyte="0.0300" Redirect="0.0392"/>


<Capture_exists>0</Capture_exists>


<Ctl_devlog>5070-93183437</Ctl_devlog>


<Deja_branched>0</Deja_branched>


<Dejatime_afttime>0</Dejatime_afttime>


<Dejatime_domload>0</Dejatime_domload>


<Dejatime_firstpaint>0</Dejatime_firstpaint>


<Dejatime_pageload>0</Dejatime_pageload>


<HTTPStatus>HTTP/1.1 200 OK</HTTPStatus>


<Info_msg/>


<Notified/>


<ResponseLength>5487</ResponseLength>


<Status>0</Status>


<Status_verify>0</Status_verify>


<Status_warning>0</Status_warning>


<User_experience>0</User_experience>


</Measurement>


<Measurement Timestamp="2013-09-10 16:59:23">


<Timings Total="0.0828" Connect="0.0052" Content="0.0004" Dns="0.0008" Firstbyte="0.0421" Redirect="0.0342"/>


<Capture_exists>0</Capture_exists>


<Ctl_devlog>5070-93183517</Ctl_devlog>


<Deja_branched>0</Deja_branched>


<Dejatime_afttime>0</Dejatime_afttime>


<Dejatime_domload>0</Dejatime_domload>


<Dejatime_firstpaint>0</Dejatime_firstpaint>


<Dejatime_pageload>0</Dejatime_pageload>


<HTTPStatus>HTTP/1.1 200 OK</HTTPStatus>


<Info_msg/>


<Notified/>


<ResponseLength>5487</ResponseLength>


<Status>0</Status>


<Status_verify>0</Status_verify>


<Status_warning>0</Status_warning>


<User_experience>0</User_experience>


</Measurement>

1 REPLY 1
SJeffries
Staff

You should be able to get this information running a "Sitestatus Endpoint" report for the API, instead of running a detail report. Here's the link in the Report API section on the Sitestatus Endpoint call:



http://help.alertsite.com/AlertSite/ReportAPI?skin=clean.nat%2cnat#Sitestatus_Endpoint



The SiteStatus Endpoint response includes the last status, Response Time and Fullpage Response Time for the devices you include in the call, from each location.

cancel
Showing results for 
Search instead for 
Did you mean: