Need a report showing base MAC address for Aruba CX switches

I have searched Thwack for this information and found several threads over the years, but never a solution.

If one runs a "show system" command for an Aruba CX JL677A switch, the response includes the "base MAC address". I need that data in a report.

How can this be done? Anyone actually done it? Thank you for any help.

Find more posts tagged with

Accepted answers

All comments

borgan

Anyone?

tobyw_loop1

Hey Brett - worth chucking it over in the NPM forum too? If you haven't already [mention:5ead648511384d829046fcc7d3f86b50:23b05a61c3e5445190d9bfa00453bce4]

There's also the Report Lab forum - a little hidden but worth checking out.

HerrDoktor

Just throwing Ideas around: so you are creating a new "Config type" in NCM that has the "show system" command. Are you able to append a GREP after that to only have that Base Mac Address" you are looking for. It would make it a lot easier to just get the content of that specific config type. parsing the MAC out of the database via SWQL will be most likely.

Daran

I wrote a custom poller to grab the serial number from Aerohive AP's - I am pretty certain you could do the same for a MAC address from an Aruba switch if you have the OID.

this is the SQL to grab the info into a custom query - just adjust for the MAC address.

SELECT n.NodeID, n.Caption, n.Status, cps.Status AS SerialNumber
FROM Orion.Nodes n

JOIN Orion.NPM.CustomPollerAssignment cpa ON n.NodeID = cpa.NodeID

JOIN Orion.NPM.CustomPollerStatus cps ON cpa.CustomPollerAssignmentID = cps.CustomPollerAssignmentID

WHERE cpa.DisplayName = 'ahSystemSerial'

AND n.Status = '1'