SONATE_NetworkRelations

JSFiddle for Impact policy

by J Mac Lean

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.4/lodash.js"></script>

JavaScript

/// original query: select ServerName, ServerSerial, CEStateChange, Severity, LocalPriObj, RemotePriObj from status where Node like 'cehost' and Type=1
var resultSet = [
["SS0000", "122674865","1505654321" ,"4", "TenGigE0/2/0/35", "Eth1", "Impact", "BD_STATUS"],
["SS0001", "122674950","1505912345", "4", "4063480/rack=1/shelf=3146544/slot=12/domain=wdm/port=6/och=1/dsr=1", "Eth2", "Manager", "R_LOS"],
["SS0002", "183148", "1504765697", "4", "4063480/rack=1/shelf=3146544/slot=12/domain=wdm/port=6/och=1/dsr=1", "myfield", "Manager", "R_LOF"],
["SS0003", "184555", "1504765697", "4", "4063480/rack=1/shelf=3146544/slot=12/domain=sdh/port=6/och=1/dsr=1", "myfield", "Manager", "LP_RDI"],
["SS0004", "185235", "1504765697", "4", "1234domain=sdh", "4235", "Manager", "LP_RDI_VC12"],
["SS0005", "186891", "1504765697", "4", "1234domain=sdh", "Eth2", "Manager", "OTS_LOS"],
["SS0006", "194152", "1504765697", "4", "332211/rack=1/shelf=3146544/slot=12/domain=sdh/port=6/och=1/dsr=1", "myfield", "Manager", "OTS_LOS-P"],
["SS0007", "195075", "1504765697", "4", "18305", "9152", "Manager", "ALS_ACTIVE"],
["SS0008", "196419", "1504765697", "4", "19652", "9826", "Manager", "L_SYNC"],
["SS0009", "206560", "1504765697", "4", "29791", "14895", "Manager", "SBS"],
["SS0010", "215015", "1504765697", "4", "38216", "19108", "Manager", "OTS"],
["SS0011", "214991", "1504765697", "4", "38213", "19106", "Manager", "ABCDEF"],
["SS0012", "217056", "1504765697", "4", "40277", "20138", "Manager", "MyAlertGroup"]
];

var sourceEvents = resultSet.map(function(row){
  return {
    serverName: row[0],
    serverSerial: row[1],
    ceStateChange: row[2],
    severity: row[3],
    LocalRootObj: row[4],
    X733ManagedObj: row[5],
    Manager: row[6],
    AlertGroup: row[7]
  }
});
console.table(sourceEvents);