All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
alexoxol
Posts: 6 Joined: Fri Sep 30, 2005 2:00 am
Post
by alexoxol » Mon Oct 10, 2005 5:41 am
Hello. MS SQL Server.
I want to check one table by SQL:
Code: Select all
select count(*) from Docs where type_id<>8 group by doc_date having count(*) > 1
and alert if there are more than 0 rows in resultset.
But HostMonitor returns "Inaccessible value".. Why?
KS-Soft
Posts: 13012 Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:
Post
by KS-Soft » Mon Oct 10, 2005 10:08 am
As usually 1st question is what version of HostMonitor do you use?
Old versions did not work with some data types...
Regards
Alex
alexoxol
Posts: 6 Joined: Fri Sep 30, 2005 2:00 am
Post
by alexoxol » Tue Oct 11, 2005 3:10 am
HM 5.38
So, the query doesn't work only with "having" statement, but without it works fine. So strange..
KS-Soft
Posts: 13012 Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:
Post
by KS-Soft » Tue Oct 11, 2005 3:16 pm
Oh, I missed HAVING statement. If you use HAVING, result set can be empty. Probably that's why HostMonitor shows error, it cannot check specified field in result set.
Regards
Alex
alexoxol
Posts: 6 Joined: Fri Sep 30, 2005 2:00 am
Post
by alexoxol » Wed Oct 12, 2005 12:30 am
Thank you