SLA report

Need new test, action, option? Post request here.
Post Reply
User avatar
Stoltze
Posts: 174
Joined: Tue Feb 03, 2004 1:58 am
Location: Denmark

SLA Report

Post by Stoltze »

Hi,

I wasn't logged in with the other post.. (Please delete that one..)

In many companys, you are bound up to a SLA (Service Level Agreement). I would like to have a special build-in function, to build a SLA report.

In this report, I can choose several things:

- Which folders, (including virtual folders) or tests to include.
- What level in %, the test must NOT be below.
- What level in %, the test must NOT go under. If it does, the test have failed.
- A weightning for each test. Total of all tests will be 100%. But maybe one test count for 20% of the SLA, and another one only for 5%.
- It should be possible to insert text og empty lines, in between the test lines.
- And it should be possible to see how the development in the SLA, have been for each day.
- Finally, a graph to show the development, would be nice..

I have created to pages, to illustrate what I mean.

This one shows in text, how the SLA have been over the month.
http://www.netsaint.dk/ahm/sla.htm

This is a chart, showing how the SLA have been going.
http://www.netsaint.dk/ahm/chart.htm

Hope I have explained, what I meen.. :)

Best Regards,
Stoltze
KS-Soft
Posts: 12821
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

Looks like really customized report. I don't think we will implement this in nearest versions.
On the other hand using ODBC Logging, some SQL server and several SQL scripts you may create this report by yourself.

Regards
Alex
ChristianD
Posts: 18
Joined: Wed Aug 06, 2003 6:00 pm
Contact:

Post by ChristianD »

Hi,

i created some scripts for my own to do some sla reporting with variables:
I use 98% as a key to make the item red when its below.
This percentage could also be a CommentLine? variable to make it more scriptable.

I hope someone could also make use of it.

Sincere,
Christian

Custom Report:
Test Items:
<script type="text/vbscript">
if (%AliveRatio%>98 ) then
document.write("<input type=button class=Good value=""%TestName% (%AliveRatio%%)"" onclick=""showinfo('\n%TestName% \n%CommentLine2% \n%CommentLine3% \n%CommentLine4% \n%CommentLine5% \n%CommentLine6% \nAverage Reply: %AverageReply%')"">")
Else
document.write("<input type=button class=Bad value=""%TestName% (%AliveRatio%%)"" onclick=""showinfo('\n%TestName% \n%CommentLine2% \n%CommentLine3% \n%CommentLine4% \n%CommentLine5% \n%CommentLine6% \nAverage Reply: %AverageReply%')"">")
end if
</script>

Folder Summary:
<HR>
<script type="text/vbscript">
If (%FolderCurrent_TotalTests%>0) then
If (cint(%FolderAverage_AliveRatio%+1-1) >=98 ) then
Document.write("<font color=""green""><b>Aantal tests: %FolderCurrent_TotalTests% - Uptime: %FolderAverage_AliveRatio%% - Unknown time: %FolderAverage_UnknownRatio%% - Downtime: %FolderAverage_DeadRatio%%</b></font>")
Else
Document.write("<font color=""red""><b>Aantal tests: %FolderCurrent_TotalTests% - Uptime: %FolderAverage_AliveRatio%% - Unknown time: %FolderAverage_UnknownRatio%% - Downtime: %FolderAverage_DeadRatio%%</4></font>")
End if
End if
</script>
Post Reply