Name

global.DiscoveryMSSQLSensor

Description

Sensor that processes MSSQL data fetched from either the PowershellMSSQL probe or the RemoteRunner probe to fetch MSSQL data.

Script

var DiscoveryMSSQLSensor = Class.create();

DiscoveryMSSQLSensor.prototype = Object.extendsObject(DiscoverySensor, {

  process: function(result) {
      this.dataArray = [];
      this.parseResult(result);
  },

  parseResult: function(result) {
      current.version = result.version;
      current.tcp_port = result.port;
      current.short_description = result.description;

      this.populateDBCatalogs(result);

  },

  populateDBCatalogs: function(result) {
      var nodeArray = g_array_util.ensureArray(result.databases.database);

      for (var i = 0; i < nodeArray.length; i++) {
          var dataObj = {};
          dataObj.name = nodeArray[i]['@id'];
          dataObj.database_instance = this.getCmdbCi();

          this.dataArray.push(dataObj);
      }

      this.addToRelatedList('cmdb_ci_db_mssql_catalog', this.dataArray, 'database_instance', 'name');
  },

  zeroResults: function() {
      // do nothing; it's ok to have zero results from this sensor...
  },

  type: 'DiscoveryMSSQLSensor'
});

Sys ID

095f0c03c0a8398200b3898ca1787544

Offical Documentation

Official Docs: