Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jun 20, 2019 8:16 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 36 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: Exchange Database Size
PostPosted: Tue Apr 10, 2007 2:40 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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 518 times

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Last edited by mcutting on Thu Feb 17, 2011 7:48 am, edited 3 times in total.
Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 3:05 pm 
Offline
Cacti User

Joined: Fri Feb 16, 2007 11:37 am
Posts: 372
Location: Emeryville, CA
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

_________________
Cacti Version - 0.8.7b
Plugin Architecture - 2.2 Beta
Poller Type - CMD.php
Server Info - Linux 2.6.9-78.0.1.ELsmp
Web Server - Apache/2.0.52 (Red Hat)
PHP - 4.3.9
MySQL - 4.1.22
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins
    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)


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 3:22 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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...

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 4:34 pm 
Offline

Joined: Tue Apr 10, 2007 2:07 pm
Posts: 4
Can the share be hidden? Does in matter if your databases are volume mount points?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 4:43 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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.

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 5:00 pm 
Offline

Joined: Tue Apr 10, 2007 2:07 pm
Posts: 4
Cool. I will give this a shot.
I have two Exchange 2003 clusters maxxed out! 4 SGs and 5DBs per each. :)


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 5:01 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
Sounds like fun - let me know how the graph works for you.

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 5:06 pm 
Offline

Joined: Tue Apr 10, 2007 2:07 pm
Posts: 4
Will do.

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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 5:25 pm 
Offline
Cacti User

Joined: Fri Feb 16, 2007 11:37 am
Posts: 372
Location: Emeryville, CA
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

_________________
Cacti Version - 0.8.7b
Plugin Architecture - 2.2 Beta
Poller Type - CMD.php
Server Info - Linux 2.6.9-78.0.1.ELsmp
Web Server - Apache/2.0.52 (Red Hat)
PHP - 4.3.9
MySQL - 4.1.22
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins
    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)


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 6:49 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 7:39 pm 
Offline

Joined: Tue Apr 10, 2007 2:07 pm
Posts: 4
Cool, I will give it a shot.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Apr 10, 2007 7:40 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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.

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Wed Apr 11, 2007 11:43 am 
Offline
Cacti User

Joined: Fri Feb 16, 2007 11:37 am
Posts: 372
Location: Emeryville, CA
MCutting,
Do i still need to edit the script for the location of the databases and STM files? What about the XML files?

app

_________________
Cacti Version - 0.8.7b
Plugin Architecture - 2.2 Beta
Poller Type - CMD.php
Server Info - Linux 2.6.9-78.0.1.ELsmp
Web Server - Apache/2.0.52 (Red Hat)
PHP - 4.3.9
MySQL - 4.1.22
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins
    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)


Top
 Profile  
 
 Post subject:
PostPosted: Wed Apr 11, 2007 12:06 pm 
Offline
Cacti Guru User

Joined: Mon Oct 16, 2006 5:57 am
Posts: 1874
Location: United Kingdom
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.

_________________
Quote:
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b


Top
 Profile  
 
 Post subject:
PostPosted: Thu Apr 26, 2007 4:28 pm 
Offline
Cacti User

Joined: Tue Apr 03, 2007 1:01 pm
Posts: 209
Location: Pullman Washington
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)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 36 posts ]  Go to page 1, 2, 3  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group