Search found 40 matches

by ericm
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...
by ericm
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...
by ericm
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...
by ericm
Mon Jul 10, 2006 5:10 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: ODBC Update statement
Replies: 6
Views: 17005

I tried and get some error about ; expected at end of statement. I tried to add the semicolon but still get the same error.
by ericm
Tue Jun 27, 2006 8:25 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: ODBC Update statement
Replies: 6
Views: 17005

Thank YOu
You saved me alot of work.
by ericm
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...
by ericm
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 ...
by ericm
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 ...
by ericm
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...
by ericm
Mon May 22, 2006 11:15 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: database logging and reporting SOLVED
Replies: 9
Views: 23602

Thank You
Maybe not the best but the working solution
It works for what I need it for.
by ericm
Mon May 22, 2006 9:29 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: database logging and reporting SOLVED
Replies: 9
Views: 23602

I tried it in the odbc string in advanced log settings
Undefined function 'Replace' in expression
by ericm
Mon May 22, 2006 7:47 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: database logging and reporting SOLVED
Replies: 9
Views: 23602

maybe it is my setup but the replace function does not work with a odbc connection. :-(
by ericm
Mon May 22, 2006 6:37 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: database logging and reporting SOLVED
Replies: 9
Views: 23602

Thank You
I will try today.
by ericm
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...
by ericm
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....