SQL query for report

violant · Post by **violant** » Fri Apr 30, 2010 12:57 am

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/vi ... php?t=4078. it name SLA Measurement

KS-Soft · Post by **KS-Soft** » Fri Apr 30, 2010 10:03 am

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

violant · Post by **violant** » Sun May 02, 2010 10:01 am

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.

KS-Soft · Post by **KS-Soft** » Mon May 03, 2010 10:56 am

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