View previous topic :: View next topic |
Author |
Message |
violant
Joined: 25 Apr 2009 Posts: 51 Location: Ukraine
|
Posted: Fri Apr 30, 2010 12:57 am Post subject: SQL query for report |
|
|
Please help with SQL query for report.
SLA Measurement. I want to get in result table this row:
1)testname
2)test folder
3)start datetime
4)end datetime
5)difference
6)from status
7)to status
8)translated (UP or DOWN)
sort by testname.
No metter which timeperiod. Thats I create myself. In DB I write standart row:
1)testname
2)status
3)eventtime
4)reply
5)eventid
6)folder
I SEE THIS REPORT IN http://www.ks-soft.net/cgi-bin/phpBB/viewtopic.php?t=4078. it name SLA Measurement |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Fri Apr 30, 2010 10:03 am Post subject: |
|
|
As I understand single SQL query cannot generate such reports.
You need set of tables and some scripts (stored procedures) to generate such reports.
Regards
Alex |
|
Back to top |
|
|
violant
Joined: 25 Apr 2009 Posts: 51 Location: Ukraine
|
Posted: Sun May 02, 2010 10:01 am Post subject: |
|
|
How I now in MSSQL I can use construction like this SELECT(SELECT(SELECT())). So it doesnt matter how to do this (maybe temp tables+procedure).
I think it very helpful report so we need to write this SQL report and publish it in Library.
To ALL: IF you now how to do this answer. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Mon May 03, 2010 10:56 am Post subject: |
|
|
Well, if we implement new type of report, it will be implemented as HostMonitor code so it will work regardless of your type of log file and type of SQL server.
Regards
Alex |
|
Back to top |
|
|
|