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
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.
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.