Xymon Mailing List Archive search

Booking new scripts into Xymon

16 messages in this thread

list Neil Franken · Tue, 15 Jun 2010 08:17:10 +0200 ·
Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that? 

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable. 

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken
list Neil Franken · Fri, 18 Jun 2010 12:58:54 +0200 ·
Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil
quoted from Neil Franken


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that? 

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable. 

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken
list Neil Franken · Fri, 18 Jun 2010 13:08:03 +0200 ·
I did look at the FAQ in the site.
quoted from Neil Franken

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that? 

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable. 

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken
list Neil Franken · Fri, 18 Jun 2010 14:14:54 +0200 ·
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph definitions
and all sorts of goodies. Hope it helps.
quoted from Neil Franken


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that? 

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable. 

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken
list Walter van Loon · Mon, 21 Jun 2010 10:00:54 +0200 (CEST) ·
Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is een
9-digit getal en de huidige waarde is een 4-digit getal, het resultaat is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql 2008?

Walter.
quoted from Neil Franken
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Neil Franken · Mon, 21 Jun 2010 10:31:25 +0200 ·
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil
quoted from Walter van Loon

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid] 
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql 2008?

Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Johan Sjöberg · Mon, 21 Jun 2010 11:02:16 +0200 ·
Hi.

Should everything in hobbitgraph.cfg be on one single line, or is it the wiki that has messed up the format?
Maybe you could put it in a "Code" box, to preserve the correct format?

/Johan
quoted from Neil Franken

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: den 18 juni 2010 14:15
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that? 

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable. 

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken
list Neil Franken · Mon, 21 Jun 2010 11:19:02 +0200 ·
I think the wiki messed it up. It should have newline after the definitions. Sorry about that I am still new to the wiki software.

Regards
Neil
quoted from Johan Sjöberg


-----Original Message-----
From: Johan Sjöberg [mailto:user-74c177c1220d@xymon.invalid] 
Sent: 21 June 2010 11:02 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi.

Should everything in hobbitgraph.cfg be on one single line, or is it the wiki that has messed up the format?
Maybe you could put it in a "Code" box, to preserve the correct format?

/Johan

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: den 18 juni 2010 14:15
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that? 

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable. 

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken
list Neil Franken · Mon, 21 Jun 2010 11:35:42 +0200 ·
Updated the wiki hope it help. My wiki-fu will get stronger with practise!
quoted from Neil Franken

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 21 June 2010 11:19 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I think the wiki messed it up. It should have newline after the definitions. Sorry about that I am still new to the wiki software.

Regards
Neil


-----Original Message-----
From: Johan Sjöberg [mailto:user-74c177c1220d@xymon.invalid] 
Sent: 21 June 2010 11:02 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi.

Should everything in hobbitgraph.cfg be on one single line, or is it the wiki that has messed up the format?
Maybe you could put it in a "Code" box, to preserve the correct format?

/Johan

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: den 18 juni 2010 14:15
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there a
QA function or something like that? 

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable. 

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken
list Walter van Loon · Mon, 21 Jun 2010 11:41:29 +0200 (CEST) ·
Yes, I'm sorry about that.

It looks like a WMI issue since "select * from
sys.dm_os_performance_counters" does show 'normal' values that result in
100% (which is in line with what perfmon on this server shows). It looks
as if WMI returns completely different counters/values, very strange.

Walter.
quoted from Neil Franken
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql 2008?

Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Walter van Loon · Mon, 21 Jun 2010 12:06:06 +0200 (CEST) ·
One of our DBA's modified the script from

strOutput = strOutput &
CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager","@","Buffercachehitratio"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

For our SQL 2008 servers this seems to work fine.

Thanks again for sharing your work; looking forward to your asp.net monitor.

Walter.
quoted from Walter van Loon

Yes, I'm sorry about that.

It looks like a WMI issue since "select * from
sys.dm_os_performance_counters" does show 'normal' values that result in
100% (which is in line with what perfmon on this server shows). It looks
as if WMI returns completely different counters/values, very strange.

Walter.
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql 2008?

Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there any
special requirements to upload these to the Xymon community? Is there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little further.
While AJAX and web 2.0 technologies would be great I feel that for the
moment I could probably add some value in making it a little easier to
customize via CSS. I am not a web designer by trade but I think I can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Neil Franken · Mon, 21 Jun 2010 12:10:22 +0200 ·
I was just testing that myself. Will merge this into the main file and
release a update during lunch.
quoted from Walter van Loon


-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid] 
Sent: 21 June 2010 12:06 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

One of our DBA's modified the script from

strOutput = strOutput &

CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServer
BufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Bu
ffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLSe
rverBufferManager","@","Buffercachehitratio"),"Buffer
quoted from Walter van Loon
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

For our SQL 2008 servers this seems to work fine.

Thanks again for sharing your work; looking forward to your asp.net
monitor.

Walter.

Yes, I'm sorry about that.

It looks like a WMI issue since "select * from
sys.dm_os_performance_counters" does show 'normal' values that result
in
100% (which is in line with what perfmon on this server shows). It
looks
as if WMI returns completely different counters/values, very strange.

Walter.
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio
als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het
resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql
2008?
Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to
upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there
any
special requirements to upload these to the Xymon community? Is
there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large
graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little
further.
While AJAX and web 2.0 technologies would be great I feel that for
the
moment I could probably add some value in making it a little easier
to
customize via CSS. I am not a web designer by trade but I think I
can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that
xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Neil Franken · Mon, 21 Jun 2010 12:39:12 +0200 ·
Interesting response from M$ about WMI and SQL2008

Microsoft was supporting monitoring using WMI till SQL 2005. So
OpManager should be able to fetch information from some WMI classes. But
from SQL 2008 these WMI classes are deprecated and Powershell should be
used to fetch the same kind of information. See this link
http://forums.manageengine.com/topic/no-database-in-sql-2008-express-ins
tance

Seems like powershell is being pushed as the new technology. I went to
the MS Tech Ed 2009 in Durban south Africa and I remember one of the SQL
sessions they showed powershell and how you can use a pipe to string
commands together. The presenter was going on about the power of the
pipe and I thought to myself he must have never touched *nix before
because this aint new.
quoted from Neil Franken


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 21 June 2010 12:10 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I was just testing that myself. Will merge this into the main file and
release a update during lunch.


-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid] 
Sent: 21 June 2010 12:06 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

One of our DBA's modified the script from

strOutput = strOutput &
CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServer
BufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Bu
ffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLSe
rverBufferManager","@","Buffercachehitratio"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

For our SQL 2008 servers this seems to work fine.

Thanks again for sharing your work; looking forward to your asp.net
monitor.

Walter.

Yes, I'm sorry about that.

It looks like a WMI issue since "select * from
sys.dm_os_performance_counters" does show 'normal' values that result
in
100% (which is in line with what perfmon on this server shows). It
looks
as if WMI returns completely different counters/values, very strange.

Walter.
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio
als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het
resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql
2008?
Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to
upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there
any
special requirements to upload these to the Xymon community? Is
there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large
graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little
further.
While AJAX and web 2.0 technologies would be great I feel that for
the
moment I could probably add some value in making it a little easier
to
customize via CSS. I am not a web designer by trade but I think I
can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that
xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Johan Sjöberg · Wed, 30 Jun 2010 12:36:14 +0200 ·
Hi. I am having a little trouble using the SQL permon script on a Win 2k8 64-bit server. I get the following errors in the eventlog (along with some more of the same kind):

"Windows cannot open the 64-bit extensible counter DLL ASP.NET_64 in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe."

I think this problem is caused by bbwin being a 32-bit application. As such, it is seeing the 32-bit version of the system32-folder and is loading the 32-bit perfmon.exe.

I had this problem when I created an exchange mailqueue monitoring script, bbwin loaded the 32-bit powershell exe, which is not compatible with the exchange PS extensions. I "solved" this by copying the 64-bit powershell exe to the ext folder and loading it explicitly.
However, I do not know very much VBS, so I do not know how to solve it in this case, if it is possible to fix.

I would be grateful for any hints on how to get it working on a 64-bit environment.
quoted from Neil Franken

/Johan

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: den 21 juni 2010 12:39
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Interesting response from M$ about WMI and SQL2008

Microsoft was supporting monitoring using WMI till SQL 2005. So
OpManager should be able to fetch information from some WMI classes. But
from SQL 2008 these WMI classes are deprecated and Powershell should be
used to fetch the same kind of information. See this link
http://forums.manageengine.com/topic/no-database-in-sql-2008-express-ins
tance

Seems like powershell is being pushed as the new technology. I went to
the MS Tech Ed 2009 in Durban south Africa and I remember one of the SQL
sessions they showed powershell and how you can use a pipe to string
commands together. The presenter was going on about the power of the
pipe and I thought to myself he must have never touched *nix before
because this aint new.


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 21 June 2010 12:10 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I was just testing that myself. Will merge this into the main file and
release a update during lunch.


-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid] 
Sent: 21 June 2010 12:06 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

One of our DBA's modified the script from

strOutput = strOutput &
CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServer
BufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Bu
ffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLSe
rverBufferManager","@","Buffercachehitratio"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

For our SQL 2008 servers this seems to work fine.

Thanks again for sharing your work; looking forward to your asp.net
monitor.

Walter.

Yes, I'm sorry about that.

It looks like a WMI issue since "select * from
sys.dm_os_performance_counters" does show 'normal' values that result
in
100% (which is in line with what perfmon on this server shows). It
looks
as if WMI returns completely different counters/values, very strange.

Walter.
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio
als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het
resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql
2008?
Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to
upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there
any
special requirements to upload these to the Xymon community? Is
there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large
graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little
further.
While AJAX and web 2.0 technologies would be great I feel that for
the
moment I could probably add some value in making it a little easier
to
customize via CSS. I am not a web designer by trade but I think I
can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that
xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Neil Franken · Wed, 30 Jun 2010 13:03:18 +0200 ·
Hi Johan

I don't have access to a 2k8 64 Bit box at the moment to reproduce the problem. However....

I have been reading some articles around this problem. See this link for some more background information http://www.sepago.de/helge/2008/04/02/windows-x64-all-the-same-yet-very-different-part-6/ 
You could try the following:

WScript.exe or CScript.exe must be used to execute the script and call the COM object(WMI etc). Since the 64Bit version of windows has two cscript/WScript installed you need to specify which one

They are located in the following places:

32-bit Script Host: %Systemroot%\SysWOW64\cscript.exe Script-Name
64-bit Script Host: %Systemroot%\System32\cscript.exe Script-Name

You could try the following. Change the line in the BBwin.ext from <load value="cscript c:\pathtoscript\scriptname.vbs" /> to <load value="%Systemroot%\SysWOW64\cscript.exe c:\pathtoscript\scriptname.vbs" />. If that does not work try the other path. Normally the %Systemroot% would be c:\windows.

Let me know what you find!
quoted from Johan Sjöberg

Regards
Neil


-----Original Message-----
From: Johan Sjöberg [mailto:user-74c177c1220d@xymon.invalid] 
Sent: 30 June 2010 12:36 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi. I am having a little trouble using the SQL permon script on a Win 2k8 64-bit server. I get the following errors in the eventlog (along with some more of the same kind):

"Windows cannot open the 64-bit extensible counter DLL ASP.NET_64 in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe."

I think this problem is caused by bbwin being a 32-bit application. As such, it is seeing the 32-bit version of the system32-folder and is loading the 32-bit perfmon.exe.

I had this problem when I created an exchange mailqueue monitoring script, bbwin loaded the 32-bit powershell exe, which is not compatible with the exchange PS extensions. I "solved" this by copying the 64-bit powershell exe to the ext folder and loading it explicitly.
However, I do not know very much VBS, so I do not know how to solve it in this case, if it is possible to fix.

I would be grateful for any hints on how to get it working on a 64-bit environment.

/Johan

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: den 21 juni 2010 12:39
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Interesting response from M$ about WMI and SQL2008

Microsoft was supporting monitoring using WMI till SQL 2005. So
OpManager should be able to fetch information from some WMI classes. But
from SQL 2008 these WMI classes are deprecated and Powershell should be
used to fetch the same kind of information. See this link
http://forums.manageengine.com/topic/no-database-in-sql-2008-express-ins
tance

Seems like powershell is being pushed as the new technology. I went to
the MS Tech Ed 2009 in Durban south Africa and I remember one of the SQL
sessions they showed powershell and how you can use a pipe to string
commands together. The presenter was going on about the power of the
pipe and I thought to myself he must have never touched *nix before
because this aint new.


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 21 June 2010 12:10 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I was just testing that myself. Will merge this into the main file and
release a update during lunch.


-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid] 
Sent: 21 June 2010 12:06 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

One of our DBA's modified the script from

strOutput = strOutput &
CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServer
BufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Bu
ffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLSe
rverBufferManager","@","Buffercachehitratio"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

For our SQL 2008 servers this seems to work fine.

Thanks again for sharing your work; looking forward to your asp.net
monitor.

Walter.

Yes, I'm sorry about that.

It looks like a WMI issue since "select * from
sys.dm_os_performance_counters" does show 'normal' values that result
in
100% (which is in line with what perfmon on this server shows). It
looks
as if WMI returns completely different counters/values, very strange.

Walter.
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio
als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het
resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql
2008?
Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to
upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there
any
special requirements to upload these to the Xymon community? Is
there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large
graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little
further.
While AJAX and web 2.0 technologies would be great I feel that for
the
moment I could probably add some value in making it a little easier
to
customize via CSS. I am not a web designer by trade but I think I
can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that
xymon
has saved me back into the project.

Kind Regards
Neil Franken

list Johan Sjöberg · Wed, 30 Jun 2010 13:16:13 +0200 ·
Hi.

Thank you for your response, I did not think about that.
However, it seems like these loggings did only occur during the first run of the script. I have not seen them after that, and data is being reported to Xymon. I do not know if there is data missing or if it is incorrect, but I think it looks ok. 
quoted from Neil Franken

/Johan

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: den 30 juni 2010 13:03
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Johan

I don't have access to a 2k8 64 Bit box at the moment to reproduce the problem. However....

I have been reading some articles around this problem. See this link for some more background information http://www.sepago.de/helge/2008/04/02/windows-x64-all-the-same-yet-very-different-part-6/ 
You could try the following:

WScript.exe or CScript.exe must be used to execute the script and call the COM object(WMI etc). Since the 64Bit version of windows has two cscript/WScript installed you need to specify which one

They are located in the following places:

32-bit Script Host: %Systemroot%\SysWOW64\cscript.exe Script-Name
64-bit Script Host: %Systemroot%\System32\cscript.exe Script-Name

You could try the following. Change the line in the BBwin.ext from <load value="cscript c:\pathtoscript\scriptname.vbs" /> to <load value="%Systemroot%\SysWOW64\cscript.exe c:\pathtoscript\scriptname.vbs" />. If that does not work try the other path. Normally the %Systemroot% would be c:\windows.

Let me know what you find!

Regards
Neil


-----Original Message-----
From: Johan Sjöberg [mailto:user-74c177c1220d@xymon.invalid] 
Sent: 30 June 2010 12:36 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi. I am having a little trouble using the SQL permon script on a Win 2k8 64-bit server. I get the following errors in the eventlog (along with some more of the same kind):

"Windows cannot open the 64-bit extensible counter DLL ASP.NET_64 in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe."

I think this problem is caused by bbwin being a 32-bit application. As such, it is seeing the 32-bit version of the system32-folder and is loading the 32-bit perfmon.exe.

I had this problem when I created an exchange mailqueue monitoring script, bbwin loaded the 32-bit powershell exe, which is not compatible with the exchange PS extensions. I "solved" this by copying the 64-bit powershell exe to the ext folder and loading it explicitly.
However, I do not know very much VBS, so I do not know how to solve it in this case, if it is possible to fix.

I would be grateful for any hints on how to get it working on a 64-bit environment.

/Johan

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: den 21 juni 2010 12:39
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Interesting response from M$ about WMI and SQL2008

Microsoft was supporting monitoring using WMI till SQL 2005. So
OpManager should be able to fetch information from some WMI classes. But
from SQL 2008 these WMI classes are deprecated and Powershell should be
used to fetch the same kind of information. See this link
http://forums.manageengine.com/topic/no-database-in-sql-2008-express-ins
tance

Seems like powershell is being pushed as the new technology. I went to
the MS Tech Ed 2009 in Durban south Africa and I remember one of the SQL
sessions they showed powershell and how you can use a pipe to string
commands together. The presenter was going on about the power of the
pipe and I thought to myself he must have never touched *nix before
because this aint new.


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid] 
Sent: 21 June 2010 12:10 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I was just testing that myself. Will merge this into the main file and
release a update during lunch.


-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid] 
Sent: 21 June 2010 12:06 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

One of our DBA's modified the script from

strOutput = strOutput &
CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServer
BufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Bu
ffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLSe
rverBufferManager","@","Buffercachehitratio"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

For our SQL 2008 servers this seems to work fine.

Thanks again for sharing your work; looking forward to your asp.net
monitor.

Walter.

Yes, I'm sorry about that.

It looks like a WMI issue since "select * from
sys.dm_os_performance_counters" does show 'normal' values that result
in
100% (which is in line with what perfmon on this server shows). It
looks
as if WMI returns completely different counters/values, very strange.

Walter.
Hi Walter

For the benefits of the other users on the list I will use english. I
have not yet tested with 2008. I will let you know what I find when I
get the chance.

Regards
Neil

-----Original Message-----
From: Walter van Loon [mailto:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi Neil,

De DBA's hier zijn blij met deze monitor, bedankt!

Als ik het goed begrijp berekent het script de BufferCacheHitRatio
als
(value / baseline*100)

Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
een
9-digit getal en de huidige waarde is een 4-digit getal, het
resultaat
is
dan altijd een veel te groot getal.

Heb jij een idee wat dit is of heb je zelf nog niet getest met sql
2008?
Walter.
Hi Guys/Gals

I think I got it right. I have uploaded the Microsoft SQL Server
Performance script to the repository. I have included graph
definitions
and all sorts of goodies. Hope it helps.


Regards
Neil

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

I did look at the FAQ in the site.

-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon

Hi All

I registered on the http://xymonton.trantor.org site. I want to
upload
my script but to be honest I am completely lost as how to do it. Is
there instructions somewhere. Sorry this is my  first time with
DokuWiki
and I don't want to mess up the site.  Any help will be appreciated.


Regards
Neil


-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Booking new scripts into Xymon

Hi All

I am almost done with the scripts I talked about before. Is there
any
special requirements to upload these to the Xymon community? Is
there
a
QA function or something like that?

Here is what I have:
1) ASP.NET overall health(VBS Script and graph definitions)
2) ASP.NET Application Specific Scripts (VBS Script and graph
definitions)
3) SQL Server(Microsoft) DBA type performance pack (rather large
graph
definition)

On another note I have been able to interface with Xymon via telnet
and
using Wireshark learned some basics about the protocol. Once I am a
little more clued up I will upload some docs for the Wiki. At this
point
I would also like to look at taking Xymon HTML pages a little
further.
While AJAX and web 2.0 technologies would be great I feel that for
the
moment I could probably add some value in making it a little easier
to
customize via CSS. I am not a web designer by trade but I think I
can
add some value in making this front end a little more configurable.

Anyway if anyone can just let me know what the procedures  are for
contributing to the project and I will gladly give the time that
xymon
has saved me back into the project.

Kind Regards
Neil Franken