Exchange Database Size

Templates, scripts for templates, scripts and requests for templates.

Moderators: Moderators, Developers

Author
Message
mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

Exchange Database Size

#1 Post by mcutting » Tue Apr 10, 2007 2:40 pm

I put this graph together, as I had a need to monitor Exchange Database sizes

You need to share the MDBDATA directory on your Exchange server for this script to work.

Steps:

1. Import both the data and graph templates included
2. Download the file EXSize.vbs.txt, rename to EXSize.vbs, and save to your SCRIPTS directory
3. Create your graph
4. Wait for a couple of poller runs, and check your data

NOTE: These templates were exported using 0.8.6j

EDIT - The original post was from the old bulletin boards, and was removed when this was upgraded. Enclosed is a file called EXSize.zip, which contains the graph and data template. The vbs file has already been posted on page 3 of this topic.
Attachments
EXSize.zip
(33.89 KiB) Downloaded 640 times
Last edited by mcutting on Thu Feb 17, 2011 7:48 am, edited 3 times in total.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

apperrault
Cacti User
Posts: 372
Joined: Fri Feb 16, 2007 11:37 am
Location: Emeryville, CA
Contact:

#2 Post by apperrault » Tue Apr 10, 2007 3:05 pm

This looks like a great script, I have a question for you though. I have two exchange servers to monitor, one of them has 4 databases, and one has 1. I would love to monitor both, but if i could at least get the one with the 4 DBs on it, that would be great. Should i be able to modify your and just add the names of my DBs, like Priv2, Priv3 etc as well as Priv2stm, Priv3stm? I can see in the vbs script what i would need to change, but would i need to change stuff in the XML files?

thanks

app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]

mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#3 Post by mcutting » Tue Apr 10, 2007 3:22 pm

As it stands, you would need to add the databases manually to the script that was enclosed in the post. Have a look at what's already there, and add what you need.

I'm by no means a VB expert, so I coded it manually for one server (this is likely to change soon however, so I am keen to know if anyone else can suggest changes).

You would also need to change the data source and graph template to reflect your modifications.

Hope this helps...
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

tuscani
Posts: 4
Joined: Tue Apr 10, 2007 2:07 pm

#4 Post by tuscani » Tue Apr 10, 2007 4:34 pm

Can the share be hidden? Does in matter if your databases are volume mount points?

mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#5 Post by mcutting » Tue Apr 10, 2007 4:43 pm

Yes, the share can be hidden. You can do this with a $ sign after the share name. The script is not bothered, so long as the account your poller runs under has permissions to access the share.

The location of rhe databases does not matter either. Using a share makes it easier to find the databases, as the script does not have to parse a long path to get where it needs to go.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

tuscani
Posts: 4
Joined: Tue Apr 10, 2007 2:07 pm

#6 Post by tuscani » Tue Apr 10, 2007 5:00 pm

Cool. I will give this a shot.
I have two Exchange 2003 clusters maxxed out! 4 SGs and 5DBs per each. :)

mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#7 Post by mcutting » Tue Apr 10, 2007 5:01 pm

Sounds like fun - let me know how the graph works for you.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

tuscani
Posts: 4
Joined: Tue Apr 10, 2007 2:07 pm

#8 Post by tuscani » Tue Apr 10, 2007 5:06 pm

Will do.

I am a super n00b though. I still have to setup Cacti which I am stumbling through now. :)

apperrault
Cacti User
Posts: 372
Joined: Fri Feb 16, 2007 11:37 am
Location: Emeryville, CA
Contact:

#9 Post by apperrault » Tue Apr 10, 2007 5:25 pm

Hi all,
I think i am going to try and jump in head first on this script, and see if i can make it work for multiple servers, and multiple databases. Looking at this script and the XML pages, i think if i can build an interface similar to the initial setup of the Weatherbug setup, where after each installation, you are prompted for a location, and you would just give it the path to your exchange databases, and that would in turn populate the graphs, that should work. It will take some digging, and some time, but that is my plan.

I will try and work on this in my "spare time" :lol:

I will post what i get when i get it.

Any offers of assistance will be greatly appreciated.

app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]

mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#10 Post by mcutting » Tue Apr 10, 2007 6:49 pm

Ok, after a bit of playing around, I have changed the EXSize.vbs script slightly so that it can now poll any Exchange server of your choice - there is no no need to hard code the server name
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

tuscani
Posts: 4
Joined: Tue Apr 10, 2007 2:07 pm

#11 Post by tuscani » Tue Apr 10, 2007 7:39 pm

Cool, I will give it a shot.

mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#12 Post by mcutting » Tue Apr 10, 2007 7:40 pm

Note to all - I have replaced all scripts and templates in the original post. You will need to reimport the templates again if you want to use the newer script.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

apperrault
Cacti User
Posts: 372
Joined: Fri Feb 16, 2007 11:37 am
Location: Emeryville, CA
Contact:

#13 Post by apperrault » Wed Apr 11, 2007 11:43 am

MCutting,
Do i still need to edit the script for the location of the databases and STM files? What about the XML files?

app
[b]Cacti Version[/b] - 0.8.7b
[b]Plugin Architecture[/b] - 2.2 Beta
[b]Poller Type[/b] - CMD.php
[b]Server Info[/b] - Linux 2.6.9-78.0.1.ELsmp
[b]Web Server[/b] - Apache/2.0.52 (Red Hat)
[b]PHP[/b] - 4.3.9
[b]MySQL[/b] - 4.1.22
[b]RRDTool[/b] - 1.2.23
[b]SNMP[/b] - 5.1.2
[b]Plugins[/b][list]Global Plugin Settings (settings - v0.5)
SuperLinks (superlinks - v0.72)
Host Info (hostinfo - v0.2)
Report Creator (reports - v0.3)
Update Checker (update - v0.4)
Realtime for Cacti (realtime - v0.35)
Cacti Log View (clog - v1.1)
RRD File Cleaner (rrdclean - v0.36)
Network Discovery (discovery - v0.9)
Uptime (uptime - v0.4)[/list]

mcutting
Cacti Guru User
Posts: 1874
Joined: Mon Oct 16, 2006 5:57 am
Location: United Kingdom
Contact:

#14 Post by mcutting » Wed Apr 11, 2007 12:06 pm

Apperault - the script is now able to detect the machine name that you are attempting to graph, so there is no need to hard code this. To ensure that this works, run the script from the command line using

cscript /nologo exsize.vbs <hostname>

Don't forget that you need to share the MDBDATA directory (or wherever your edb and stm files reside).

I have not made any changes to the XML files - you will need to do this manually if you want to add more datasources and database files to monitor.

This is easily done if you look at how I structured the existing data sources and templates.
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

Dacob9906
Cacti User
Posts: 209
Joined: Tue Apr 03, 2007 1:01 pm
Location: Pullman Washington

#15 Post by Dacob9906 » Thu Apr 26, 2007 4:28 pm

When I tryh to use this script, it is giving me this error in the cacti log:

04/26/2007 02:25:08 PM - CACTID: Poller[0] Host[63] DS[1790] WARNING: Result from SCRIPT not valid. Partial Result: ...
04/26/2007 02:25:08 PM - CACTID: Poller[0] Host[63] ERROR: Empty result [10.8.0.10]: 'cscript /nologo C:/Inetpub/wwwroot/cacti/scripts/exsize.vbs 10.8.0.10'


I also get a syntax error trying to run it from the command line on the 8th line 138th character. Thanks!
Jacob Bergman
Pullman School District
[email protected]

Operating System: winserv 2003
Webserver: IIS 6.0
Cacti: BETA windows installer 1.5 (BSOD2600)

Post Reply