Search found 40 matches
- Tue Sep 11, 2007 7:46 am
- Forum: Wish list
- Topic: Auto Reset Host Monitor from excel
- Replies: 1
- Views: 8944
Auto Reset Host Monitor from excel
I know I can reset the statistics for test from the web interface which seems to use java script. I was wondering if there is a way to automat this through a macro in excel. I have to supply a way for the Director of IT to get monthly Metrics of all test performed. SO what I did was write some sql q...
- Sat Sep 02, 2006 9:07 pm
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: Email send failure
- Replies: 34
- Views: 70211
IF you don't mind my asking
What are some specs about your system you are running HM on CPU ? Mem? HM Ver? OS Ver? .NET Framework Ver? Other third party software or development software. Reason I ask is because this error is not caused by HM in my opion. Even though HM is the reported program that is only because they system i...
- Fri Sep 01, 2006 5:38 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: ODBC MYSQL UPDATE LOGGING
- Replies: 1
- Views: 7996
ODBC MYSQL UPDATE LOGGING
High all I am using the folloiwing sql to update the results of my tests to a mysql db. I wish to only update if the test exist all ready. If it doesn't exist then insert. (As you will see in my statement.) Anyways it does not update if the test exist all ready. It is always inserting. NSERT INTO me...
- Mon Jul 10, 2006 5:10 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: ODBC Update statement
- Replies: 6
- Views: 17005
- Tue Jun 27, 2006 8:25 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: ODBC Update statement
- Replies: 6
- Views: 17005
- Wed Jun 21, 2006 7:40 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: ODBC Update statement
- Replies: 6
- Views: 17005
ODBC Update statement
I am guessing at this but can someone take a look at this and tell me whats wrong. What I am trying to do is with ODBC logging to a access database I want to just update the record from a test instead of inserting a new record. Even better would be to update the record and if not exist then insert r...
- Mon May 29, 2006 11:43 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: Getting Date field into Database
- Replies: 5
- Views: 15742
Ok I figured this out by mistake. In my database the colum name was Date. While trying to figure this out by recreating a new table I mispelled the Date colum to datw and the query worked. When I fixed the mispelling to Date it didn't work again. So for some reason the query will not execute if the ...
- Tue May 23, 2006 4:47 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: Getting Date field into Database
- Replies: 5
- Views: 15742
Also you shoud wrap %DateTime% variable in ', e.g: Insert into hm (TestName, Folder, Date, Alive, Dead, Average) VALUES ('%TestName%', '%Folder%','%DateTime%',left('%AliveRatio%',instr('%AliveRatio%',' %')-1) ,left('%DeadRatio%',instr('%DeadRatio%',' %')-1) ,'%AverageReply%') That was a typo in my ...
- Mon May 22, 2006 12:00 pm
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: Getting Date field into Database
- Replies: 5
- Views: 15742
Getting Date field into Database
Ok this is probably not going to be my last one but anyways I am trying to have the test date inserted into my database theough odbc and keep getting a syntax error Insert into hm (TestName, Folder, Date, Alive, Dead, Average) VALUES ('%TestName%', '%Folder%',%Date%,left('%AliveRatio%',instr('%Alive...
- Mon May 22, 2006 11:15 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: database logging and reporting SOLVED
- Replies: 9
- Views: 23602
- Mon May 22, 2006 9:29 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: database logging and reporting SOLVED
- Replies: 9
- Views: 23602
- Mon May 22, 2006 7:47 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: database logging and reporting SOLVED
- Replies: 9
- Views: 23602
- Mon May 22, 2006 6:37 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: database logging and reporting SOLVED
- Replies: 9
- Views: 23602
- Mon May 22, 2006 5:22 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: database logging and reporting SOLVED
- Replies: 9
- Views: 23602
database logging and reporting SOLVED
I am logginf to a odbc msaccess database. I want to strip the % off the end of the replies for Alive and Dead because when I try to run a query to give me the average of a certain test I get a error that says mismatched data. I have been doing this through a query in access but over time the log has...
- Thu Dec 01, 2005 8:57 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: Issues with Performance Counter tests
- Replies: 12
- Views: 31568
Simular Issue
I am having a simular issue where I thought it was a network problem also but have found it it is not. MY problem is if I have \\servername in the test method and a test errors by "unable to connect to specified machine" I go in and put the ip address and the test will work. Or vise versa....