Dell PowerEdge Data Queries [v1.1 2007-12-17]

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

Moderators: Moderators, Developers

Author
Message
User avatar
BSOD2600
Cacti Moderator
Posts: 12160
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Dell PowerEdge Data Queries [v1.1 2007-12-17]

#1 Post by BSOD2600 » Sat Dec 02, 2006 6:08 pm

I've created a set of data queries for Dell PowerEdge servers. Since it's a data query, it's generic enough and should work for any Dell server running OpenMangement. The graphs it creates are for each item (like the standard Traffic graphs). There are numerous multi-graph templates out there for PowerEdge's where you can combine several voltages / fans / temperatures being monitored.

Additionally, if you want Cacti to show the textual status for the various fields like the screenshot below, you must do a few things. My PowerEdge 840 sadly doesn't have much to monitor.

1) Copy the following MIB files to your primary mib folder. On Windows this would be C:\Net-SNMP\share\snmp\mibs\. The MIBs:

10892.mib - (from dell's openmangement cd or install folders)
dcs3fru.mib - (from dell's openmangement cd or install folders)
dcstorag.mib - (from dell's openmangement cd or install folders)
RFC1158
RFC1212

2) Modify your Net-SNMP snmp.conf and add: mibs +MIB-Dell-10892 on a new line.

Changelog:
-1.1
Updated the poweredge temperature graph template due to a cacti import bug
Exported with cacti 0.8.7a

-1.0
Initial release
Exported with cacti 0.8.6j
Attachments
poweredge_data_query.png
Sample data query output. My Poweredge 840 doesn't have much...
poweredge_data_query.png (9.27 KiB) Viewed 44817 times
Dell poweredge templates 1.1.zip
needed templates.
(20.44 KiB) Downloaded 2389 times
Last edited by BSOD2600 on Tue Dec 18, 2007 2:44 am, edited 1 time in total.

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

#2 Post by mcutting » Wed Mar 28, 2007 4:20 am

Hi - would like to use this - would it be possible for you to post the MIBS as well, as I'm habing difficulty finding these.

Thanks
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

User avatar
BSOD2600
Cacti Moderator
Posts: 12160
Joined: Sat May 08, 2004 12:44 pm
Location: USA

#3 Post by BSOD2600 » Wed Mar 28, 2007 11:36 am

As I originally stated, those MIB files are from dell's openmangement cd or install folders. Did you search for them?

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

#4 Post by mcutting » Wed Mar 28, 2007 12:31 pm

Yes, but I couldnt seem to locate them - perhaps it was the wrong CD. Are these MIBS essential for the templates to work (looks like they are for descriptions etc) ?

Thanks
Cacti Version 0.8.8b
Cacti OS Ubuntu LTS
RRDTool Version RRDTool 1.4.7
Poller Information
Type SPINE 0.8.8b

User avatar
BSOD2600
Cacti Moderator
Posts: 12160
Joined: Sat May 08, 2004 12:44 pm
Location: USA

#5 Post by BSOD2600 » Wed Mar 28, 2007 2:36 pm

mcutting wrote:these MIBS essential for the templates to work
No. cacti does not explicitally require MIB files for its functionality.

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#6 Post by slech » Fri Nov 30, 2007 4:08 am

Dell PE 1800 2 Fan - its ok
Thy graph work perfectly.

Dell PE 2950 4 Fan - not working

RRDTool Says:
ERROR: No DS called 'CoolingDeviceReadin' in 'D:/cacti/rra/dell.pe_lowercriticalthresh_586.rrd'



Data Source Debug

c:/cacti/rrdtool/rrdtool.exe create \
D:/cacti/rra/dell.pe_lowercriticalthresh_586.rrd \
--step 60 \
DS:LowerCriticalThresh:GAUGE:120:0:U \
DS:CoolingDeviceReadin:GAUGE:120:0:U \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#7 Post by slech » Fri Nov 30, 2007 4:34 am

I try to create template for 2 fun but apear problem

Image

This is my graph
ImageImage

This is you graph
ImageImage
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

User avatar
BSOD2600
Cacti Moderator
Posts: 12160
Joined: Sat May 08, 2004 12:44 pm
Location: USA

#8 Post by BSOD2600 » Fri Nov 30, 2007 4:59 am

Whats the problem? you have graphs...

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#9 Post by slech » Fri Nov 30, 2007 5:14 am

1. Problem - do not graph Fan on Dell PE 2950 - 4 Fun
you graph the same.

2. My graph not graph what in you 1 and 2 graph
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#10 Post by slech » Fri Nov 30, 2007 9:59 am

2. Resolved

Image
Attachments
cacti_graph_template_dell_poweredge_-_cooling_2_fan_speed.xml
(10.37 KiB) Downloaded 991 times
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#11 Post by slech » Sat Dec 01, 2007 3:50 pm

cacti_data_query_snmp_dell_poweredge_temperature.xml

Error: XML parse error.
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#12 Post by slech » Mon Dec 03, 2007 9:52 am

4 Fun Speed Template

Image
Attachments
cacti_graph_template_dell_poweredge_-_cooling_4_fan_speed.xml
(19.35 KiB) Downloaded 968 times
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#13 Post by slech » Sat Dec 08, 2007 3:01 am

This is my template for 6 fan speed
Image
Attachments
cacti_graph_template_dell_poweredge_-_cooling_6_fan_speed.xml
(38.41 KiB) Downloaded 845 times
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

User avatar
streaker69
Cacti Pro User
Posts: 711
Joined: Mon Mar 27, 2006 10:35 am
Location: Psychic Amish Network Administrator

#14 Post by streaker69 » Sat Dec 08, 2007 8:39 am

slech wrote:cacti_data_query_snmp_dell_poweredge_temperature.xml

Error: XML parse error.
I got this message as well. Anyone have a fix?

slech
Cacti User
Posts: 90
Joined: Tue Nov 06, 2007 7:51 am

#15 Post by slech » Tue Dec 11, 2007 1:56 am

Template for 7 Fan
Image
Attachments
cacti_graph_template_dell_poweredge_-_cooling_7_fan_speed.xml
(42.99 KiB) Downloaded 848 times
[size=75]
[color=green]|Cacti 0.87|[/color][color=green]|PA 1.3|[/color][color=green]|Poller cmd.php|[/color][color=green]|IIS 6.0|[/color][color=green]|PHP Version 5.2.4|[/color][color=green]|MySQL 5.0.27|[/color][color=green]|RRDtool 1.2.15|[/color][/size]
[color=brown]|Thold 0.3.8 |[/color] [color=red]|Zond 0.34 |[/color]
[url=http://forums.cacti.net/viewtopic.php?t=15067][size=75]Complete List of Cacti Scripts and Templates[/size][/url]
[url=http://forums.cacti.net/viewtopic.php?t=14985][size=75]Currently Known Plugins[/size][/url]

Post Reply