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