KS-Soft

MSSQL 2005| Working variant Drop Table #101; Select EventTime,Status,Simple_Status,Reply,TestId Into #101 From HMLog --Where Convert(Char(10),EventTime,104)='17.11.2010' And TestId=2113; Where TestId=2313; --Where Convert(Char(10),EventTime,104)='17.11.2010'; --Select * From #101 Order by 1; Drop Ta...

I assume this problem caused by some 3rd party application running on this system

Yes, this caused by some 3rd party application running on this system, but life is life.
I think I move HM server to virtual machine.

What I need to do if:
- HM service in status "start"
- I am in console session in win 2003
I dont see tray icon in tray.

P.S. May be this help you.
http://www.tek-tips.com/faqs.cfm?fid=5937

HM v.8.72. Win 2003R2.
When in console session (id 0) explorer.exe crash and then restore HM tray icon don't recover and I don't see it. To recover it I need to restart HM service. But I don't want to do this.
Q:How can I see tray icon after explorer.exe crash without restart HM service?

I use Oracle client 8.x. Test method - ODBC query test. Timeout in HM ODBC query test - 10sec. But I have situation when all my Oracle ODBC query test in status "Checking" for big time and nothing help - Only restart HM service help me. I can't change my oracle client because I test Oracle...

Can you write disconnect status to window "View"-"RCI status"-"Latest commands". And make it window more bigger. For fast view when operator disconnect.

I have text log files which have filename yyyymmdd.log. But only if there is error this file create and it have all this day error. For example. If today I have error - file create and include all this day error, but if no error file didnt create. When I set %yyyy%%mm%%dd%.log to logfile name and no...

thanks

When RCC via RCI connected - HM write to system log entry. But it don't write anything when connection lost. In RCI status I see who connected to HM via RCI, but when connection close there is no entry to system log. Now I see in system log only when he connect to HM. It very important to know how l...

Status "Out of schedule" & "Paused" use one color. 1) I need different color for this status. In my case "out of schedule" status administrator puts. But "Paused" status put RCC operator. One operator don't now which tests with status "Paused" by...

What timeout for Check Oracle server test and how change it?
How can I set max reply value which set ALARM status?

Can you check network connection of HMServer? Doesn't meter why my network connection down (some repair work on network where my server connect, maybe patch cord replace or something else) in result all test going down and want send notification. May be I need to create some test that test my networ...

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.

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

Can you do some logs (text file or ODBC better) with audit data of all user action (change options,refresh test,acknowledge, generate report,delete test - all of actions). May be in that format |Datetime|HMUser|Action|Object of Action| |2010-04-21 15:00|admin|Disable alert|Monitoring - Alert| |2010-...