Windows 2008 DNS Statistics

[somasundaram]

Hello Developers,

I have a DNS server which is running on window 2008 R2 (64bit) server. I is running in cache mode.
I would like to collect the performance statistics, found few scripts but didn't worked.

any one can help me to find out the correct scripts & templates please.

Hopefully from BSOD

Thanks
Soma

Cacti-0.8.8a|OS-windows-2008|NET-SNMP- 5.6.1.1|RRDTool-1.4.x|PHP-5.3.17|SPINE-0.8.8a|Hosts-336|Graphs-5951| Polling time-7.7 Seconds|

[BSOD2600]

Which scripts and why didnt they work? When you manually ran them outside of cacti, did it work?

Depending on the answers above... you can either code up your own scripts to query the performance monitor counters, or use something like SNMP-Informant Advanced (http://www.snmp-informant.com/products/ ... v-tree.htm) which already exposes the perfmon counters via SNMP.

[somasundaram]

Hi BSOD,

i have tried the following script http://forums.cacti.net/about4426.html.

while i was trying with this script, i'm getting empty results for this script.

and probably this is for win2k my cacti installed in win2008 (32bit) and the destination (DNS) installed in 2008 (64bit) may be that could be a reason.

Regards
Soma

Cacti-0.8.8a|OS-windows-2008|NET-SNMP- 5.6.1.1|RRDTool-1.4.x|PHP-5.3.17|SPINE-0.8.8a|Hosts-336|Graphs-5951| Polling time-7.7 Seconds|

[BSOD2600]

ah, yuck Perl to make WMI calls. I'd strongly suggest the snmp-informant addon instead.

Anyways, you can test WMI on the DNS server if it still even gets registered for modern Windows servers (some reason I thought it doesnt).

• start -> run: WBEMTEST
• click connect. in namespace type: root\MicrosoftDNS
• click query. type in: SELECT * FROM MicrosoftDNS_Statistic
• click apply. any results?

[somasundaram]

Hi BSOD,

this is the result i'm receiving BSOD.

its giving success message.

result.jpg (82.75 KiB) Viewed 2521 times

Regards
Soma

[somasundaram]

[quote="somasundaram"]Hi BSOD,

this is the result i'm receiving BSOD.

its giving success message.

result.jpg

Regards
Soma[/quote

should i try with any different method using WMI then?

[BSOD2600]

ok, cool so DNS still is available via WMI.

When you manually run the perl script, whats the output? There was no attachment...

[somasundaram]

sorry forgot to attach.

Here is the output when i run the query manually in CLI

C:\Apache2\htdocs\nms\scripts>w32_dns_query_stats.pl x.x.x.x
Total:1995147 Notify:0 Update:58 TKeyNego:0 Standard:1995089 A:1820022 NS:1102 S OA:5241 MX:21302 PTR:42233 SRV:21128 ALL:578 IXFR:0 AXFR:0 Other:83483

But at the same time when the script is excecuted through cacti i get this error.

SPINE: Poller[0] Host[2499] TH[1] DS[36834] SCRIPT: perl C:/Apache2/htdocs/nms/scripts/w32_dns_query_stats.pl Chennai Cache DNS, output: U

Could not understand what is going wrong.


Regards
Soma

[BSOD2600]

What account is the Cacti task running under? I bet it doesnt have permissions to query WMI. You can test to validate by running a cmd window as the Cacti Task User and then running the script. Then you can either grant the Cacti Task Account the appropriate permissions in WMI or run the task with a higher privilege level account along with weighing the security implications.

[somasundaram]

Hi BSOD,

cacti is running with Administrator account in task scheduler.

scheduler.jpg (22.64 KiB) Viewed 2504 times

Also the test WBEMTEST i was running with Administrator username.

[BSOD2600]

When spine ran the script, whats "Chennai Cache DNS" ? Shouldnt that be the IP? any success if you test by switching the poller from spine to cmd.php?