Details

    • New Feature
    • Resolution: Fixed
    • Major
    • None
    • None
    • Poller, Web Interface
    • Ubuntu 11.04+

    Description

      WMI Poller

      Known Issues

      • Under heavy dev, try at your own risk. That said, it doesn't do any irreversible data changes in Observium, so it's mostly harmless
      • For wmi-common there are conflicts with existing SNMP pollers
        • Event logs will show several entries for updated OS, possibly processor
        • Consequently, generic info is still a work in progress
      • MS SQL is still a work in progress, suggestions for counters welcome
      • App definitions need to be added for MS SQL (only affects Apps overview page, ie. http://yourobserviumsite/apps/app=mssql/)
      • App definitions need to be revisited for Exchange
      • Display name option for apps has not been added to all areas where app_type is used

      Database changes

      update/101.sql
      • Alters applications table: adds "app_name" column
        • This allows customized app name display in HTML elements such as navbars

      Changes to existing files

      includes/defaults.inc.php
      • Added config variable for WMIC executable directory
      • Added config variables for WMI polling options
      • Added WMI poller modules entries, default set to 0
      includes/definitions/apps.inc.php
      • Added app definition for Exchange
      html/pages/device/appcs.inc.php
      • Fixed bug where all instances of an application would be active on navbar (OBSERVIUM-515)
      • Changed app navbar to display an application name (see DB changes)
      • Changed app navbar to display app instance in parenthesis

      Additions

      • Three WMI poller modules that must be enabled in a device's modules page
      WMI Poller for Generic Server Info
      • Finally display correct CPU name!
      • Updates the correct version of Windows
      WMI Poller for Microsoft Exchange Counters
      • Pollers for:
        • ActiveSync
        • Autodiscover
        • Information Store
        • Mailbox
        • Offline Address Book
        • Outlook Web App
        • Transport Queues
        • SMTP
      WMI Poller for very basic MS SQL Counters
      • Currently only polling:
        • Current User Connections
        • Buffers

      Installation

      FOLLOW AT YOUR OWN RISK:
      See attached PDF

      Attachments

        Activity

          [OBS-518] WMI Poller

          Patch 006 is now in SVN.

          adama Adam Armstrong added a comment - Patch 006 is now in SVN.
          highonmikey Mikey added a comment -

          Derp

          highonmikey Mikey added a comment - Derp

          You seem to have forgotten to attach patch 6

          adama Adam Armstrong added a comment - You seem to have forgotten to attach patch 6
          highonmikey Mikey added a comment - - edited

          wmi-005.patch

          wmi-006.patch

          SHOULD work with Ubuntu+ svn patch

          Additions

          • Added CPU usage for MSSQL process

          Changes

          • Aesthetic enhancements
          • Added memory cache to MSSQL
          • Renamed 101.sql -> 103.sql to keep up with committed SQL updates
          highonmikey Mikey added a comment - - edited wmi-005.patch wmi-006.patch SHOULD work with Ubuntu+ svn patch Additions Added CPU usage for MSSQL process Changes Aesthetic enhancements Added memory cache to MSSQL Renamed 101.sql -> 103.sql to keep up with committed SQL updates
          highonmikey Mikey added a comment - - edited

          wmi-004.patch

          Additions

          • Added WMI "modules" to config
          • Added control over which WMI modules are polled to the WMI section in the device edit page
          • Created directories:
            • includes/polling/storage
          • Added files:
            • includes/polling/os/wmi.inc.php
            • includes/polling/processors/wmi.inc.php
            • includes/polling/storage/wmi.inc.php

          Changes

          • Reverted back to a single global poller module that includes module files
          • WMI Poller will check if a WMI module is enabled in config and device_attribs before polling
          • Changed $config to $GLOBALS['config']
          • Moved files:
            • includes/polling/storage-hrstorage.inc.php => includes/polling/storage/hrstorage.inc.php
          • Changed includes/polling/storage.inc.php to reflect above
          • Various optimizations, less DB queries
          highonmikey Mikey added a comment - - edited wmi-004.patch Additions Added WMI "modules" to config Added control over which WMI modules are polled to the WMI section in the device edit page Created directories: includes/polling/storage Added files: includes/polling/os/wmi.inc.php includes/polling/processors/wmi.inc.php includes/polling/storage/wmi.inc.php Changes Reverted back to a single global poller module that includes module files WMI Poller will check if a WMI module is enabled in config and device_attribs before polling Changed $config to $GLOBALS ['config'] Moved files: includes/polling/storage-hrstorage.inc.php => includes/polling/storage/hrstorage.inc.php Changed includes/polling/storage.inc.php to reflect above Various optimizations, less DB queries
          highonmikey Mikey added a comment -

          Mostly bug fix or two and a couple optimizations.. not much progress made.

          wmi-003.patch

          Changes

          • Fixed device edit page for WMI
            • Did not limit jQuery scope to #edit, it was disabling all form elements on page (search bar)
          • wmi_query() no longer queries the database for override status for every query. Override status is queried at the beginning of each WMI module and all values are passed to wmi_query()
          • Removed $config['rrd']['rra'] from rrdtool_create() calls
          • MS SQL app page will look more like a device overview page whenever I figure out WTF I'm even doing

          Additions

          • WMI storage polling
            • Requires initial discovery and poll with SNMP
            • Auto-disables storage poller module
            • Updates RRD and database entries created via storage poller module
          • MS SQL memory

          Removed

          • Exchange definition in includes/definitions/apps.inc.php - Currently reviewing which graphs should be displayed on Apps page
          highonmikey Mikey added a comment - Mostly bug fix or two and a couple optimizations.. not much progress made. wmi-003.patch Changes Fixed device edit page for WMI Did not limit jQuery scope to #edit, it was disabling all form elements on page (search bar) wmi_query() no longer queries the database for override status for every query. Override status is queried at the beginning of each WMI module and all values are passed to wmi_query() Removed $config ['rrd'] ['rra'] from rrdtool_create() calls MS SQL app page will look more like a device overview page whenever I figure out WTF I'm even doing Additions WMI storage polling Requires initial discovery and poll with SNMP Auto-disables storage poller module Updates RRD and database entries created via storage poller module MS SQL memory Removed Exchange definition in includes/definitions/apps.inc.php - Currently reviewing which graphs should be displayed on Apps page
          highonmikey Mikey added a comment - - edited

          wmi-002.patch

          Changes

          • Added device edit page for WMI
          • wmi_query() checks for WMI override values for device and uses them if override is set to true/on
          highonmikey Mikey added a comment - - edited wmi-002.patch Changes Added device edit page for WMI wmi_query() checks for WMI override values for device and uses them if override is set to true/on
          highonmikey Mikey added a comment -

          Forgot to mention under Known Issues:

          • Logical disk poller only displays information and doesn't update any RRDs. It conflicts too much with the SNMP storage poller module.
          highonmikey Mikey added a comment - Forgot to mention under Known Issues : Logical disk poller only displays information and doesn't update any RRDs. It conflicts too much with the SNMP storage poller module.

          People

            adama Adam Armstrong
            highonmikey Mikey
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: