SQL query for availability Error
-
Hi Team, We have an application called as TMART. Basically TMART is used to monitor each application such as web,citrix etc. Under a particular project we have multiple monitor that are getting monitored. We would like to have a sql query through which we can pull the availability error. Can some one please provide us with the sql query for the same. Its bit urgent... Your response would be highly appreciated.
-
Hi Team, We have an application called as TMART. Basically TMART is used to monitor each application such as web,citrix etc. Under a particular project we have multiple monitor that are getting monitored. We would like to have a sql query through which we can pull the availability error. Can some one please provide us with the sql query for the same. Its bit urgent... Your response would be highly appreciated.
It is impossible to give you an answer without details of the tables and columns involved, so please give us the information needed to help you.
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
-
It is impossible to give you an answer without details of the tables and columns involved, so please give us the information needed to help you.
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
Hi Chris, I am really happy for the quick response. But there is no table and columns involved into this. We have the data as below:-
(Complete Time of the Period – (Addition of Failures Durations)) / (N° of Failures + 1)*
*for n failures, there n + 1 periods of functioning, and therefore:
For example for a month as January with 44 640 seconds for the complete period and errors as below:
• From 1/1/14 09:17 to 1/1/14 17:20, (error 1 duration = 483 minutes)
• From 14/1/14 17:20 to 15/1/14 07:40 (error 2 duration = 860 minutes)
• From 21/1/14 07:40 to 21/1/14 11:12 (error 3 duration = 212 minutes)The MTBF would be:
(44 640 - (483 + 860 + 212)) / 4 = 5 385 minutes 30s, MTBF is 89 hours 45mn 30s = 3 days 17 hours 45mn 30s.
This is what we require for... :(
-
Hi Chris, I am really happy for the quick response. But there is no table and columns involved into this. We have the data as below:-
(Complete Time of the Period – (Addition of Failures Durations)) / (N° of Failures + 1)*
*for n failures, there n + 1 periods of functioning, and therefore:
For example for a month as January with 44 640 seconds for the complete period and errors as below:
• From 1/1/14 09:17 to 1/1/14 17:20, (error 1 duration = 483 minutes)
• From 14/1/14 17:20 to 15/1/14 07:40 (error 2 duration = 860 minutes)
• From 21/1/14 07:40 to 21/1/14 11:12 (error 3 duration = 212 minutes)The MTBF would be:
(44 640 - (483 + 860 + 212)) / 4 = 5 385 minutes 30s, MTBF is 89 hours 45mn 30s = 3 days 17 hours 45mn 30s.
This is what we require for... :(
If there are not tables or columns, mhow can you expect a SQL query to work? How is the data held, where is the data held?
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
-
Hi Chris, I am really happy for the quick response. But there is no table and columns involved into this. We have the data as below:-
(Complete Time of the Period – (Addition of Failures Durations)) / (N° of Failures + 1)*
*for n failures, there n + 1 periods of functioning, and therefore:
For example for a month as January with 44 640 seconds for the complete period and errors as below:
• From 1/1/14 09:17 to 1/1/14 17:20, (error 1 duration = 483 minutes)
• From 14/1/14 17:20 to 15/1/14 07:40 (error 2 duration = 860 minutes)
• From 21/1/14 07:40 to 21/1/14 11:12 (error 3 duration = 212 minutes)The MTBF would be:
(44 640 - (483 + 860 + 212)) / 4 = 5 385 minutes 30s, MTBF is 89 hours 45mn 30s = 3 days 17 hours 45mn 30s.
This is what we require for... :(
Don't tell me it is a text report and you are hoping to query the text file using TSQL - not going to work. First you need to parse the data into logical fields using the correct data types. Then you may query the TABLE and COLUMNs to get the results you need.
Never underestimate the power of human stupidity RAH