KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

SQL query for report

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Wish list
View previous topic :: View next topic  
Author Message
violant



Joined: 25 Apr 2009
Posts: 51
Location: Ukraine

PostPosted: Fri Apr 30, 2010 12:57 am    Post subject: SQL query for report Reply with quote

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
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12284
Location: USA

PostPosted: Fri Apr 30, 2010 10:03 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
violant



Joined: 25 Apr 2009
Posts: 51
Location: Ukraine

PostPosted: Sun May 02, 2010 10:01 am    Post subject: Reply with quote

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
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12284
Location: USA

PostPosted: Mon May 03, 2010 10:56 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Wish list All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index