Hardware Inventory Report

[MichaelM1]

Is there a way to create a report that list which devices have a single power supply installed vs a redundant power supply? or perhaps report the serial number of the power supply unit installed in each of my devices so I would know if only one serial number is reports a second power supply needs to be installed?

I can see the information stored in the device view, I just cant figure how to run a report against all my devices so I dont have to go into the device view on each device and manually check.

[MichaelM1]

Is this a built in Flexview or a custom one you guys built\found?  I have a majority of EOS 7100s, but we are starting to swap them out with EXOS 5520s.

[Jtonic]

I believe it was something custom, I am sure GTAC or our sales engineer must have helped us put it together. It puts everything in a spreadsheet:


Here is the code in the FlexView if you want to take a look:

<?xml version="1.0" encoding="UTF-8"?>
<flextablelist version="8.5.0.169">
<flextable autoExportCsvTextDelineation="DQUOTE" autoExportFrequencyUnit="Minutes" autoExportFormat="HTML" showHorizontalLines="true" autoExportFilename="" autoExportFileManagement="Replace" highlightBackground="153,255,255,255" class="com.enterasys.netsight.console.client.flexview.FvTable" id="ctChasPowerSupplyState" columnSelectionAllowed="false" autoCreateColumnsFromModel="false" autoExportAllowed="false" autoExportCsvFieldDelimiter="Comma">ctChasPowerSupplyState
<tableModel>com.ets.nac.tables.TbModel</tableModel>
<column comparator="com.ets.flextable.col.IntStringComparator" id="0" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" fixed="true" hidden="true">ReqID
<notes></notes>
<dataField>OID::ReqID:::SNMP::ReqID</dataField></column>
<column comparator="com.ets.nac.tables.TbCompOid" id="1" width="156" sortOrder="ascending" class="com.enterasys.netsight.console.client.flexview.FvColumn" fixed="true" sorted="true" modelIndex="1">IP Address
<notes></notes>
<dataField>OID::IP Address:::SNMP::IP Address</dataField></column>
<column comparator="com.ets.nac.tables.TbCompOid" id="2" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" fixed="true" hidden="true" modelIndex="2">Instance
<notes></notes>
<dataField>OID::Instance:::SNMP::Instance</dataField></column>
<column comparator="com.ets.flextable.col.IntStringComparator" id="101" width="195" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" modelIndex="3">ctChasPowerSupplyNum
<notes></notes>
<dataField>OID::ctChasPowerSupplyNum:::SNMP::SNMP;false;2;3;false;false;4;2;0;0;0;0;0</dataField></column>
<column comparator="com.enterasys.netsight.console.client.flexview.FvCompMibEnum" id="100" width="319" sortOrder="descending" class="com.enterasys.netsight.console.client.flexview.FvColumn" modelIndex="4">ctChasPowerSupplyState
<notes></notes>
<dataField>OID::ctChasPowerSupplyState:::SNMP::SNMP;false;2;4;false;false;4;2;0;0;0;0;0</dataField></column>
<notes></notes>
<dataField>TBLHASH::::TBLHDR::0;0;true;30;ctChasPowerEntry;V.0.3.3.0;0;0;105</dataField></flextable></flextablelist>