Hi,

Any instructions?

Gr,

Rando.

From: observium <observium-bounces@observium.org> On Behalf Of Adam Armstrong via observium
Sent: kolmapäev, 21. oktoober 2020 17:23
To: observium@observium.org
Cc: Adam Armstrong <adama@observium.org>
Subject: Re: [Observium] WMI custom queries and MSSQL developments

Hi,

You can’t just add extra data to an RRD, they have a fixed format.

You’d also need to add code to graph and display the data. It’s a fair bit more complicated than this, especially for WMI.

Adam.

From: Rando Sui <rando@blueit.ee>
Sent: 21 October 2020 06:30
To: Adam Armstrong <adama@observium.org>
Subject: RE: [Observium] WMI custom queries and MSSQL developments

Hi,

OK, hopefully in future versions.

How you develop mssql.inc.php . I added one line to see also transactions, uploaded file and rebooted observium, but nothing appears. Am I missing something?

  $wql = "SELECT * FROM ".$wmi_class_prefix."GeneralStatistics";

  $wmi['mssql'][$instance['Name']]['stats'] = wmi_parse(wmi_query($wql, $override), TRUE);

  if ($wmi['mssql'][$instance['Name']]['stats'])

  {

    $app_found['mssql'] = TRUE;

    echo("Stats; ");

    rrdtool_update_ng($device, 'mssql-stats', array(

      'userconnections' => $wmi['mssql'][$instance['Name']]['stats']['UserConnections'],

                  'transactions' => $wmi['mssql'][$instance['Name']]['stats']['Transactions'],

    ), $instance['Name']);

    $app_data['stats']['UsrConn'] = $wmi['mssql'][$instance['Name']]['stats']['UserConnections'];

                $app_data['stats']['Transactions'] = $wmi['mssql'][$instance['Name']]['stats']['Transactions'];

  }

Gr,

Rando.

From: observium <observium-bounces@observium.org> On Behalf Of Adam Armstrong via observium
Sent: teisipäev, 20. oktoober 2020 23:52
To: 'Observium' <observium@observium.org>
Cc: Adam Armstrong <adama@observium.org>
Subject: Re: [Observium] WMI custom queries and MSSQL developments

Hi,

We don’t really have the ability to do this. :)

Adam.

From: observium <observium-bounces@observium.org> On Behalf Of Rando Sui via observium
Sent: 20 October 2020 19:15
To: observium@observium.org
Cc: Rando Sui <rando@blueit.ee>
Subject: [Observium] WMI custom queries and MSSQL developments

Hello,

We are using paid version of observium.

How you can make custom WMI queries for hosts?

How you can develop metrics for MSSQL? There is some available I’d like to add but they are not shown once I upload .php file and reboot observium.

Greetings,

Rando.