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 mailto:observium-bounces@observium.org > On Behalf Of Adam Armstrong via observium Sent: teisipäev, 20. oktoober 2020 23:52 To: 'Observium' <observium@observium.org mailto:observium@observium.org > Cc: Adam Armstrong <adama@observium.org mailto: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 mailto:observium-bounces@observium.org > On Behalf Of Rando Sui via observium Sent: 20 October 2020 19:15 To: observium@observium.org mailto:observium@observium.org Cc: Rando Sui <rando@blueit.ee mailto: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.