HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
Showing results for 
Search instead for 
Did you mean: 

ILO mac address report is showing all interfaces SIM 7.05

Occasional Contributor

ILO mac address report is showing all interfaces SIM 7.05

Hi all, I'm running a report follwing the steps attached to determine the mac addresses of the ILO's in my estate. Instead of 1 result per machine in the report, I'm seeing all interfaces per machine, I've tried running the report at the ILO collection and see the same issue. Any assistance appreciated. 

Steps I'm following: http://community.hpe.com/hpeb/attachments/hpeb/itrc-455/43471/1/372154.pdf

SQL query output if helpful:

 select R_NetworkInterface.DeviceName, R_NetworkInterface.Description, R_NetworkInterface.MacAddress, R_NetworkInterface.IPAddress, R_NetworkInterface.InterfaceName from R_NetworkInterface WHERE ((R_NetworkInterface.SnapShotID=-1) OR (R_NetworkInterface.SnapShotID is NULL)) AND DeviceKey in (select devices.deviceKey from devices LEFT OUTER JOIN DB_deviceInfoEx ON devices.deviceKey = DB_deviceInfoEx.deviceKey LEFT OUTER JOIN IPAddress ON devices.deviceKey = IPAddress.deviceKey and IPAddress.ipIndex = 0 LEFT OUTER JOIN associated_device_data ON devices.deviceKey = associated_device_data.deviceKey LEFT OUTER JOIN deviceProtocolInfo ON devices.deviceKey = deviceProtocolInfo.deviceKey LEFT OUTER JOIN simAggrStatus ON devices.deviceKey = simAggrStatus.deviceKey LEFT OUTER JOIN DeviceStatusValue ON devices.deviceKey = DeviceStatusValue.deviceKey and DeviceStatusValue.StatusSourceId= 6 JOIN consolidatedNodeAuths ON devices.mxGuid = consolidatedNodeAuths.NodeId and consolidatedNodeAuths.userID = '0000005056897fc60000000400000026' WHERE ( ( devices.productType = 12) ) ) order by R_NetworkInterface.DeviceName ASC