Skip to content

d3vilh/HW_AU

Repository files navigation

Hardware Inventory audit tool for Comverse One systems.

Runs audit for all AIX and Linux servers in /etc/hosts of your master node and provides CSV file with all the details as result.

UPDATES

  • v.0.1.7 26.12.2022 audit_new.run - new version of audit.run. Universal for all the sites.
  • v.0.1.6 23.03.2022 Now audit.run is universal for all sites and customers. For minimum run you need to have audit.run, aix_hw_au.sh, linux_hw_au.sh, esxi_hw_au.sh and inventory.SITE in the same directory.
  • v.0.1.6 14.03.2022 + Report files format update & rotation(+15 days older files will be deleted). You can run single audit.run file on different inventory files. + some bugfixes for lnx_hw_au.sh
  • v.0.1.5 28.01.2022 + esxi hosts inventory and various bugfixes
  • v.0.1.2 11.01.2022 Inventory fileto store all the hosts
  • v.0.1.1 13.09.2021 AIX UAC Expiration date report

MAIN FEATURES

  • Fast and easy to setup
  • Require minimal system resources
  • Does not require 3rd party software to run
  • VM and BM compatible

The Inventory utility provides following information:

  • Server hardware parts report (CPU, RAM, HDD, PCI boards)
  • Server Serial Numbers report (Server MB, Storage, Fiber Switches, Tape Libs)
  • Server Firmware versions (BIOS, UEFI, NIC, POWER servers)
  • OS information (Score version, architecture type, Linux kernel, AIX OS Level)
  • HDD and SSD Smart status (HDD & SSD health)
  • Linux drivers versions for critical components (NIC modules)
  • Server uptime, Limits, MEM Pages and TZ settings
  • Running C1 and 3rd party applications version (CBS apps, UPA, Oracle, Java, WebLogic) Advanced Storage report (for EMC CX, DATA Domain, IBM v7000 and IBM fs900) Advanced FCS report (CISCO Nexus)
  • Core Network switches inventory (Juniper and Cisco switches)
  • Servers Network configuration snapshot (AIX and Linux. MAC, IP, Routing, VIP). Available here

PREREQUISITES

  • Require Bash version 3 or higher on the master server (bash --version)
  • The inventory.SITE_ID file should be updated with IPs and hosts you desire to run audit. You can cat /etc/hosts into inventory, but be sure there are no duplicated records for the same server.
  • SSH password-less access needs be configured across all UNIX servers (Linux and AIX). If this configuration is missed the utility will ask for the password for every server where no ssh certificates is present
  • For IBM v7000 and fs900 storages, ssh password-less access needs to be present on SDP_A node to both storage enclosures(active and stby.). This is default configuration.
  • The Hardware Inventory tool support any Linux or AIX versions on the remote servers by default. However, Site specific configuration should be done for audit.run script.

PREPARATION

1. The inventory.SITE_ID file will be created automatically with necessary template on first audit.run execution in ./ directory. Then you have to update it with all the IPs and hosts you are desired to run audit. cat /etc/hosts > inventory.SITE_ID will also works for you, just be sure there will not be any duplicated records (othervise you'll have dup results) and final forma of every line will be IP hostname. The linux and aix audit scripts uses special filters to avoid running inventory on the same host several times. Nevertheless it is recomended to carefully review inventory file. You can add special filter to exclude not necessary servers from the inventory list by adding the line #audit_exclude for every server record. For example:

CELCO:oam1a:/root# grep audit_exclude inventory.CELCO 
10.1.1.112 upmdb1a #audit_exclude
10.1.1.113 upmdb1b #audit_exclude
10.1.1.234 BitCoin1 miner1 #audit_exclude 

Different SDP types(Linux or AIX) inside inventory.SITE_ID file should be marked by #aixsdp or #lnxsdp tags, as shown below.

CELCO:oam1a:/root# grep sdp inventory.CELCO 
10.1.1.112 sdp1a #lnxsdp
10.1.1.114 sdp2a #aixsdp

FOR BASIC INVENTORY - skip preparation and go to next step - FULL SITE INVENTORY

2. For IBM v7000 add san_console information into the SDP /etc/hosts (both nodes):

CELCO-SDP1a:sdp1:/# grep -i san /etc/hosts 
10.1.1.125 san_console
10.1.1.138 v7000-1a san1 
10.1.1.139 v7000-1b san2

The san_console is an IBM storage enclosures VIP interface. Which can be obtained from the storage active enclosure node (password-less access setup for SDP_A only):

CELCO-SDP1a:sdp1:/# ssh superuser@san_console lssystem | grep console 
console_IP 10.1.1.125:443
CELCO-SDP1a:sdp1:/#

3. For IBM fs900 add san_console_flash information into the SDP /etc/hosts (both nodes):

CELCO-SDP23:sdp1:/# grep -i san_console /etc/hosts 
10.1.1.39 san_storage-23 san1 san_console 
10.1.1.45 san_flash-23 san2 san_console_flash 
CELCO-SDP23:sdp1:/#

The san_console_flash is an IBM flash storage enclosures VIP interface. This information can be obtained from the storage active node enclosure (console password-less access setup for SDP_A only by default):

CELCO-SDP23:sdp1:/# ssh superuser@san_console_flash lssystem | grep console 
console_IP 10.1.1.45:443
CELCO-SDP23:sdp1:/#

4. Beware that to some POWER8 SDPs both type of the storages (v7000 and fs900) can be connected to one SDP server (different VGs are located on different storages). Be sure that you have both san_console and san_console_flash IP addresses in /etc/hosts file on both SDP_A and SDP_B nodes for this type of servers.

5. Double check that SDP_A known_hosts file contains records for new san_console and san_console_flash hosts:

CELCO-SDP23a:sdp1:/# ssh superuser@san_console 'lssystem'| grep code_level 
code_level 7.8.1.10 (build 135.9.1905291321000)
CELCO-SDP23a:sdp1:/# ssh superuser@san_console_flash 'lssystem'| grep code_level 
code_level 7.8.1.10 (build 135.9.1905291321000)
CELCO-SDP23a:sdp1:/#

6. For CISCO FCS (Nexus modules only) create special inventory user and configure password-less access for SDP_A node on fcswa and fcswb FCSs:

CELCO-SDP23:sdp1:/# grep -i fcsw /etc/hosts 
10.1.1.57 fc-sw23a fcswa fcs23a 
10.1.1.58 fc-sw23b fcswb fcs23b
CELCO-SDP23:sdp1:/#

Login from SDP_A node to fcswa as admin user and list all connected users to define correct SDP_A IP address:

CELCO-FCS-23A# show users
NAME LINE TIME IDLE PID COMMENT
audit pts/0 Jan 21 20:37 . 6669 (10.1.1.56) session=ssh * CELCO-FCS-23A#

Copy SDP_A RSA certificate to fcswa node (use IP defined on previous step):

CELCO-FCS-23A# copy sftp://[email protected]/.ssh/id_rsa.pub id_rsa.pub 

Confirm certificate now exists on CISCO bootflash device:

CELCO-FCS-23A# dir ...
             391    Mar 20 17:27:44 2019  id_rsa.pub
      ...
CELCO-FCS-23A#

Create new audit user with reduced access permissions and stick RSA certificate to it:

CELCO-FCS-23A# conf t
CELCO-FCS-23A(config)# username audit password Blah-Blah-Blah role network-operator
CELCO-FCS-23A(config)# username audit sshkey file bootflash:id_rsa.pub 
CELCO-FCS-23A(config)# end
CELCO-FCS-23A#

Confirm new user has been created with reduced permissions role and RSA certificate:

CELCO-FCS-23A# show user-account audit 
        user:audit
        this user account has no expiry date
        roles:network-operator
        ssh public key: ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCxFUEqKCuvQiSE0
        ogU2oNplgN9caBmOUOQ556zD4PLzGS5SzBlah-Blah-Blah...
CELCO-FCS-23A#

Save new CISCO configuration:

CELCO-FCS-23A# copy run start
# [########################################] 100% # Copy complete.
CELCO-FCS-23A# exit

Perform the same steps for SDP_A but from fcswb (the second) switch.

Confirm password-less access is configured for both fcswa and fcswb switches from SDP_A node:

CELCO-sdp23a:/# ssh -q audit@fcswa 'sh inventory' | head -1 | awk '{print $4,$5}'; 
MDS 9148S
CELCO-sdp23a:/# ssh -q audit@fcswb 'sh inventory' | head -1 | awk '{print $4,$5}'; 
MDS 9148S
sdp23a:/#

FULL SITE INVENTORY

To run hardware inventory across all the onsite servers you have to execute audit.run script as superuser with short site name:

CELCO-UPM1a:upm1:# ./audit.run CELCO
Keep an eye on the progress. Human input might be required.
   Running HW Inventory on following units:
   SGU, DGU, SLU, DSLU, CRMOMAPP, ... CMVOEM, UPM, UPMDB, OAMAPP, SDP, CPM, WPDB, BF, ADMIN
   PROGRESS: 70%  [################################..............] RUNNING ON: UPM&DB

For help information - fire audit.run without any keys:

CELCO-UPM1a:upm1:# ./audit.run
   Runs Hardware Inventory checks across all onsite units.
Usage: ./audit.run SITE_ID
Where SITE_ID is short site name. AIX and LINUX inventory scripts will be updated
  with this short name on first audit.run execution.
    Examples:
      ./audit.run CELCO
      ./audit.run CELCO_PROD
      ./audit.run CELCO_TEST
    Prerequisites:
      aix_hw_au.sh - runs Hardware Inventory checks against any AIX-based servers.
      linux_hw_au.sh - runs Hardware Inventory checks against any Linux-based servers.
Be aware that SANbox and EMCds FCSs checks is deprecated in this version, as obsolete HW 
CELCO-UPM1a:upm1:#

As a result of this execution you’ll have two .CSV files. First with Linux based servers inventory, second with AIX based servers inventory information:

CELCO-UPM1a:upm1:# ls -rlt
-rwxrwxrwx 1 root root 5319 Jan 21 19:40 audit.run
-rwxrwxrwx 1 root root 15880 Jan 21 21:32 linux_hw_au.sh 
-rwxrwxrwx 1 root root 12436 Jan 21 21:32 aix_hw_au.sh
-rw-r--r-- 1 root root 87596 Jan 21 21:43 CELCO.LINUX_HW_LIST.csv 
-rw-r--r-- 1 root root 20161 Jan 21 21:47 CELCO.AIX_HW_LIST.csv 
CELCO-UPM1a:upm1:#

Both CSV files will contain all the inventory data with pipe (|) symbol used as the columns delimiter:

CELCO-UPM1a:upm1:# head -2 CELCO.LINUX_HW_LIST.csv
SITE |HOSTNAME |IP ADDR    |ROUTE    |HW TYPE              |HW SN |LNX SCORE |KERNEL               |HW ARCH |APP VERSION |APP INSTALL DATE(M/D/Y) |UP VERSION |ORA CLI    |ORA DB |TT DB |WL VERSION |JAVA VER  |RAM     |CORES |THREADS |ENA CORES |CPU            |HDD SIZE |HDD MODEL         |HDD HEALTH |ACTIVE UEFI BANK |UEFI/BIOS VERSION |FILE-MAX (sysctl.conf) |FILE-LIMIT (ulimit -n)|UPTIME   |NIC DRVs                 |EMC MODEL |EMC SERIAL |EMC FLARE |V7k MODEL |V7k TYPE |V7k ENCLOSURE SN |v7K FW |V7k failed HDDs |V7k CONSOLE |DD MODEL |DD SERIAL |DD OS |DD DISK STATUS |DD UPTIME 
CELCO|sgu1a    |10.1.1.100 |10.1.1.1 |ProLiant BL460c Gen8 |OLOLO |6.2.1     | 2.6.32-220.el6.i686 |i686    |7.0.5       | Mon Apr 10 2017        |4.120.0    |11.2.0.3.0 |NA     |NA    |NA         | 1.6.0_31 |3983136 |6     |12      |6         |E5-2620Xeon(R) |300.0GB  |HP LOGICAL VOLUME |OK         |HP NA            | 1.51             | 20000                 |8192                  |327 days |2.1.11 2.7.0.3 1.70.00-0 |NA        |NA         |NA        |NA        |NA       |NA               |NA     |NA              |NA          |NA       |NA        |NA    |NA             | NA
CELCO-UPM1a:upm1:#

LINUX HOSTS INVENTORY

To run Hardware Inventory checks against any Linux-based servers you have to execute linux_hw_au.sh script. For help information, run linux_hw_au.sh without any keys:

CELCO-UPM1a:upm1:# ./linux_hw_au.sh
   Runs Hardware Inventory checks against any Linux-based servers.
Usage: ./linux_hw_au.sh HOSTNAME SITE_ID Where:
      HOSTNAME is server to run inventory on or mask for the group of hosts from the /etc/hosts
      SITE_ID is optional parameter, will be inserted as first column of output. PROD_SITE is used
      by default
     Examples:
      ./linux_hw_au.sh sgu21b CELCO
      ./linux_hw_au.sh slu CELCO_PROD
      ./linux_hw_au.sh sgu23
CELCO-UPM1a:upm1:#

Once you read all the help, you can execute linux_hw_au.sh script as superuser. Beware the script will not save any data to .CSV files, it will send all the output, about every server to console:

CELCO-UPM1a:upm1:# ./linux_hw_au.sh sgu3 CELCO
  SITE |HOSTNAME |IP ADDR  |DEF GW   |HW TYPE                  |HW SN        |LNX SCORE |KERNEL                     |HW ARCH |APP VERSION |APP INSTALL DATE(M/D/Y) |UP VERSION |ORA CLI    |ORA DB      |ORA TT DB   |WL VERSION |JAVA VER |RAM      |CORES |THREADS |ENA CORES |CPU            |HDD SIZE |HDD MODEL         |HDD HEALTH |ACTIVE UEFI BANK |UEFI/BIOS VERSION   |FILE-MAX (sysctl.conf) |FILE-LIMIT (ulimit -n)|UPTIME    |NIC DRVs                  |EMC MODEL |EMC SERIAL     |EMC FLARE      |V7k MODEL          |V7k TYPE          |V7k ENCLOSURE SN |v7K FW  |V7k failed HDDs |V7k CONSOLE      |DD MODEL       |DD SERIAL      |DD OS          |DD DISK STATUS |DD UPTIME
 CELCO |sgu3a    |10.1.1.1 |1.4.33.1 |DPM3 PFS-379/380         |See IPMI FRU |5.4       |2.6.18-164.2.1.el5PAE      |i686    |6.0.2       | Thu Dec 15 2011        |4.109.3    |10.2.0.3.0 |10.2.0.3.0  |NA          |NA         |1.4.2    |4019116  |2     |2       |NA        |T7400Core(TM)2 |120.0GB  |SEAGATE-MDB       |OK         |DPM3 NA          |1.00.08             |8192                   |8192                  |1155 days |1.9.3 2.0.1e 1.48.105     |NA        |NA             |NA             |NA                 |NA                |NA               |NA      |NA              |NA               |NA             |NA             |NA             |NA             |NA
 CELCO |upm1     |10.1.1.5 |1.4.33.1 |INTEL BALLENGER T5000PAL |AZD666OLOLO  |2.0.7.22  |2.6.18-164.el5PAE          |i686    |3.8.4.2     | Wed Jun 04 2017        |4.109.3    |NA         |10.2.0.5.0a |NA          |NA         |1.4.2    |16622832 |4     |4       |NA        |5128Xeon(R)    |73.5GB   |FUJITSUMBB2073RC  |OK         |BALLENGER NA     |10.0                |131072                 |65536                 |306 days  |1.9.3 2.0.1e 1.48.105     |CX300     |CK2000666OLOLO |2.26.300.5.020 |NA                 |NA                |NA               |NA      |NA              |NA               |NA             |NA             |NA             |NA             |NA
 CELCO |upmdb1a  |10.1.1.3 |1.4.33.1 |ProLiant BL460c Gen8     |CZD666OLOLO  |6.2.2     |2.6.32-220.46.1.el6.x86_64 |x86_64  |3.8.4.2     | Fri Sep 01 2015        |2.0.0      |NA         |11.2.0.4.12 |NA          |NA         |1.6.0_31 |32839312 |6     |12      |6         |E5-2620Xeon(R) |300.0GB  |HP LOGICAL VOLUME |OK         |HP NA            |1.51                |200006815744           |65536                 |585 days  |2.1.11 2.7.0.3 1.70.00-0  |NA        |NA             |NA             |NA                 |NA                |NA               |NA      |NA              |NA               |DD2200         |FLD221OLOLOSHA |5.5.0.9-471508 |Normal         |32 days
 CELCO |oam1     |10.1.1.4 |1.4.33.1 |ProLiant BL460c Gen8     |CZJ666OLOLO  |6.2.1     |2.6.32-220.el6.x86_64      |x86_64  |3.8.4.2     | Wed Oct 06 2017        |4.110.2    |11.2.0.3.0 |NA          |NA          |NA         |1.6.0_31 |16292520 |6     |12      |6         |E5-2620Xeon(R) |300.0GB  |HP LOGICAL VOLUME |OK         |HP NA            |1.51                |20000                  |8192                  |35 days   |2.1.11 2.7.0.3 1.70.00-0  |NA        |NA             |NA             |IBM Storwize V7000 |control 2076-524  |control 7LOLOKA  |7.4.0.2 |0               |10.1.1.99:443    |NA             |NA             |NA             |NA             |NA
 CELCO |sapi6    |10.1.1.2 |1.4.33.1 |BladeCenter HS22 -[7Z5]- |06W666OLOLO  |5.4       |2.6.18-164.2.1.el5         |x86_64  |3.8.4.2     | Thu Oct 01 2015        |4.110.2    |10.2.0.1.0 |10.2.0.3.0  |NA          |10.3.0.0   |1.4.2    |12142660 |8     |16      |4+4       |E5620Xeon(R)   |600.1GB  |IBM-ESXSMBF2600RC |OK         |Primary          |P9E165BUS-1.29-     |5000                   |8192                  |3 days    |2.0.24b 2.6.2.4c 1.62.16  |NA        |NA             |NA             |NA                 |NA                |NA               |NA      |NA              |NA               |NA             |NA             |NA             |NA             |NA
 CELCO |slu14    |10.1.1.8 |1.4.33.1 |ProLiant BL460c Gen8     |CZD666OLOLO  |5.8       |2.6.18-400.1.1.el5PAE      |i686    |3.8.4.2     | Wed Apr 22 2017        |4.110.2    |10.2.0.1.0 |10.2.0.3.0  |NA          |NA         |1.4.2    |33111736 |8     |16      |8         |E5-2658Xeon(R) |600.0GB  |HP EG0600FBVFP    |OK         |HP NA            |1.51                |65000                  |65000                 |271 days  |2.1.11 2.7.2.2 1.72.51-0  |NA        |NA             |NA             |NA                 |NA                |NA               |NA      |NA              |NA               |NA             |NA             |NA             |NA             |NA
 CELCO |eci16    |10.1.1.9 |1.4.33.1 |ProLiant BL460c Gen9     |CZD666OLOLO  |6.6       |2.6.32-504.16.2.el6.x86_64 |x86_64  |3.8.4.2     | Wed May 06 2017        |2.0.0      |11.2.0.3.0 |NA          |NA          |NA         |1.6.0_31 |32751916 |6     |12      |6         |E5-2620Xeon(R) |600.1GB  |HP LOGICAL VOLUME |OK         |HP NA            |2.50                |65000                  |65000                 |133 days  |2.2.5l 2.10.1.0 1.710.71  |NA        |NA             |NA             |NA                 |NA                |NA               |NA      |NA              |NA               |NA             |NA             |NA             |NA             |NA
 CELCO |dtr12    |10.1.1.4 |1.4.33.1 |ProLiant DL360 Gen10     |CZD666OLOLO  |6.9       |2.6.32-696.el6.x86_64      |x86_64  |5.5.4       | Mon Dec 07 2017        |4.120.0    |11.2.0.5.0 |NA          |11.2.2.8.12 |NA         |1.6.0_31 |32543264 |4     |8       |4         |5122Xeon(R)    |300.0GB  |HP EG000300JWSJP  |OK         |HP NA            |FW: 2.14 BIOS: 2.34 |65000                  |65000                 |176 days  |2.2.6 2.7.10.1 1.712.30-0 |NA        |NA             |NA             |NA                 |NA                |NA               |NA      |NA              |NA               |NA             |NA             |NA             |NA             |NA

You can print necessary inventory data only:

CELCO-UPM1a:upm1:# ./linux_hw_au.sh urp | awk -F '|' '{print $2"|"$5"|"$6}' 
HOSTNAME |HW TYPE                  |HW SN
    urp1 |IBM eServer BladeCenter  |OLOLO
    urp2 |BladeCenter HS22 -[7Z5]- |OLOLO1
    urp3 |DPM3 PFS-379/380         |See IPMI FRU
CELCO-UPM1a:upm1:#

Or forward output into the file for further analysis:

CELCO-UPM1a:upm1:# ./linux_hw_au.sh dslu CELCO > CELCO.LINUX.`date +’%d.%m.%Y'`.csv 
CELCO-UPM1a:upm1:# ls -lrt *.csv
-rw-r--r-- 1 root root 6310 Jan 20 22:36 CELCO.LINUX.20.01.2015.csv 
CELCO-UPM1a:upm1:# wc -l CELCO.LINUX.20.01.2015.csv
42 CELCO.LINUX.20.01.2015.csv
CELCO-UPM1a:upm1:#

AIX HOSTS INVENTORY

To run Hardware Inventory checks against any Linux-based servers you have to execute aix_hw_au.sh script. For help information, run aix_hw_au.sh without any keys:

CELCO-UPM1a:upm1:# ./aix_hw_au.sh
   Runs Hardware Inventory checks against any AIX-based servers.
Usage: ./aix_hw_au.sh HOSTNAME SITE_ID Where:
      HOSTNAME is server to run inventory on or mask for the group of hosts from the /etc/hosts
      SITE_ID is optional parameter, will be inserted as first column of output. PROD_SITE is used
      by default
     Examples:
      ./aix_hw_au.sh sdp1b CELCO
      ./aix_hw_au.sh sdp CELCO_PROD
      ./aix_hw_au.sh CELCO_TEST
CELCO-UPM1a:upm1:#

Once you read all the help, you can execute aix_hw_au.sh script as superuser. Beware the script will not save any data to .CSV files, it will send all the output, about every server to console:

CELCO-UPM1a:upm1:# ./aix_hw_au.sh sdp1 CELCO
 SITE |HOSTNAME |HW TYPE |SYSTEM MODEL |SERIAL |NGSCORE |DBCORE |ORACLE DB       |ORACLE CLIENT |UP VERSION |JAVA VERSION |FIRMWARE                                              |UAC EXP DATE |AIX OS LEVEL    |BLU MODEL       |BLU SERIAL |NSR LICENSE EXP |NETWORKER VERSION |FCSWA MODEL    |FCSWA SN    |FCSWA FW LEVEL |FCSWB MODEL    |FCSWA SN    |FCSWB FW LEVEL |EMC MODEL |EMC SERIAL     |EMC FLARE       |V7k MODEL          |V7k TYPE                                                                                     |V7k ENCLOSURE SN                                                              |v7K FW    |V7k failed HDDs |V7k CONSOLE     |V7k2F MODEL         |V7k2F TYPE       |V7k2F ENCLOSURE SN |v7K2F FW  |V7k2F failed SSDs |V7k2F CONSOLE  |CLUST IP   |NODE IP   |HMC IP    |LPAR INFO  |AUTO RESTART |CPU CLOCK |NUM OF CPU |RAM SIZE  |GOOD RAM SIZE |NUM OF RAM MODULES |SIZE OF RAM MODULES(MB)                                                                                                                                                                                                                        |PAGE SIZE      |COUNT ERRPT | UNIQ ERRPT |UPTIME
CELCO |sdp1a    |POWER8  |IBM,8284-22A |OLOLO  |V7.2.4  |4.56.0 |11.2.0.4.191015 |Not installed |4.110.2    |1.6.2        |sys0!system:SV860_205 (t) SV860_205 (p) SV860_205 (t) |20210401     |7200-03-03-1913 |IBMULT3580-HH7  |31666OLOLO |No Exp Date     |NA                |cisco MDS 9124 |FOX15666LOL |5.0(1a)        |cisco MDS 9124 |FOX12666LOL |5.0(1a)        |NA        |NA             |NA              |NA                 |NA                                                                                           |NA                                                                            |NA        |0               |NA              |IBM FlashSystem 900 |control 9843-AE3 |1666LOL            |1.6.1.0   |0                 |10.1.1.122:443 |10.1.1.138 |10.1.1.32 |NA        |1 78-D13BX |true         |3891 MHz  |12         |253952 MB |253952 MB     |8                  |32768 32768 32768 32768 32768 32768 32768 32768                                                                                                                                                                                                |s 4 KB m 64 KB |32          |1           |329days
CELCO |sdp1b    |POWER8  |IBM,8284-22A |OLOLO  |V7.2.4  |same2a |11.2.0.4.191015 |Not installed |4.110.2    |1.6.2        |sys0!system:SV860_205 (t) SV860_205 (p) SV860_205 (t) |20210401     |7200-03-03-1913 |IBMULT3580-HH7  |31666OLOLO |No Exp Date     |NA                |see node A     |see node A  |see node A     |see node A     |see node A  |see node A     |NA        |NA             |NA              |NA                 |NA                                                                                           |NA                                                                            |NA        |0               |NA              |see node A          |see node A       |see node A         |see node A|see node A        |see node A     |10.1.1.139 |10.1.1.33 |NA        |1 78-D13CX |true         |3891 MHz  |12         |253952 MB |253952 MB     |8                  |32768 32768 32768 32768 32768 32768 32768 32768                                                                                                                                                                                                |s 4 KB m 64 KB |32          |1           |329days
CELCO |sdp2b    |POWER5  |IBM,9117-570 |OLOLO  |V3.0.4  |3.5.50 |10.2.0.5.0      |Not installed |4.100.0    |1.5.0        |sys0!system:SF240_338 (t) SF240_332 (p) SF240_338 (t) |NA           |6100-06-01-1043 |IBMULTRIUM-TD3  |27666OLOLO |No Exp Date     |7.6.Build.142;    |NA             |NA          |NA             |NA             |NA          |NA             |CX3-40f   |CK2000666OLOLO |3.26.40.5.025   |NA                 |NA                                                                                           |NA                                                                            |NA        |NA              |NA              |NA                  |NA               |NA                 |NA        |NA                |NA             |10.1.1.140 |10.1.1.45 |NA        |1 06-9B300 |true         |1900 MHz  |8          |63872 MB  |63872 MB      |32                 |2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048 2048                                                                                |s 4 KB m 64 KB |34          |2           |642days
CELCO |sdp3a    |POWER6  |IBM,9117-MMA |OLOLO  |V3.0.5  |4.35.0 |11.2.0.3.12     |Not installed |4.100.0    |1.5.0        |sys0!system:EM350_108 (t) EM350_108 (p) EM350_108 (t) |NA           |6100-06-01-1043 |IBMULTRIUM-TD3  |27666OLOLO |No Exp Date     |7.6.Build.142;    |NA             |NA          |NA             |NA             |NA          |NA             |CX3-40f   |CK2000666OLOLO |3.26.40.5.032   |NA                 |NA                                                                                           |NA                                                                            |NA        |NA              |NA              |NA                  |NA               |NA                 |NA        |NA                |NA             |10.1.1.141 |10.1.1.48 |10.1.1.88 |2 CEL-SDP3 |true         |4208 MHz  |8          |190464 MB |190464 MB     |48                 |4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096 4096|s 4 KB m 64 KB |43728       |5           |629days
CELCO |sdp10a   |POWER7  |IBM,8233-E8B |OLOLO  |V3.0.6  |4.56.0 |11.2.0.3.15     |Not installed |4.110.2    |1.5.0        |sys0!system:AL730_154 (t) AL730_154 (p) AL730_154 (t) |NA           |6100-09-03-1415 |HPUltrium4-SCSI |27666OLOLO |No Exp Date     |8.2.1.0.Build.681;|cisco MDS 9124 |FOX15666LOL |5.0(4c)        |cisco MDS 9124 |FOX15666LOL |5.0(4c)        |CX4-480   |CKM001666OLOLO |04.30.000.5.529 |NA                 |NA                                                                                           |NA                                                                            |NA        |NA              |NA              |NA                  |NA               |NA                 |NA        |NA                |NA             |10.1.1.142 |10.1.1.28 |NA        |1 06-4C53R |true         |3220 MHz  |8          |127744 MB |127744 MB     |8                  |16384 16384 16384 16384 16384 16384 16384 16384                                                                                                                                                                                                |s 4 KB m 64 KB |19          |2           |159days
CELCO |sdp23a   |POWER8  |IBM,8284-22A |OLOLO  |V3.0.11 |4.55.0 |11.2.0.4.5      |Not installed |4.100.0    |1.5.0        |sys0!system:SV860_118 (t) SV860_118 (p) SV860_118 (t) |NA           |6100-09-03-1415 |HPUltrium6-SCSI |27666OLOLO |No Exp Date     |8.2.1.0.Build.681;|cisco MDS 9148S|JPG21666LOL |6.2(17)        |cisco MDS 9148S|JPG21666LOL |6.2(17)        |NA        |NA             |NA              |IBM Storwize V7000 |expansion 2076-24F expansion 2076-24F control 2076-624 expansion 2076-24F expansion 2076-24F |expansion 71LOL expansion 71LOL control 71LOL expansion 71LOL expansion 71LOL |8.2.1.10  |0               |10.1.1.77:443   |NA                  |NA               |NA                 |NA        |NA                |NA             |10.1.1.143 |10.1.1.70 |NA        |1 78-2521X |true         |3891 MHz  |6          |189696 MB |189696 MB     |6                  |32768 32768 32768 32768 32768 32768                                                                                                                                                                                                            |s 4 KB m 64 KB |69          |3           |701days
CELCO |sdp23b   |POWER8  |IBM,8284-22A |OLOLO  |V3.0.11 |3.6.10 |11.2.0.4.5      |Not installed |4.100.0    |1.5.0        |sys0!system:SV860_118 (t) SV860_118 (p) SV860_118 (t) |NA           |6100-09-03-1415 |HPUltrium6-SCSI |27666OLOLO |No Exp Date     |8.2.1.0.Build.681;|see node A     |see node A  |see node A     |see node A     |see node A  |see node A     |NA        |NA             |NA              |see node A         |see node A                                                                                   |see node A                                                                    |see node A|see node A      |see node A      |see node A          |see node A       |see node A         |see node A|see node A        |see node A     |10.1.1.144 |10.1.1.71 |NA        |1 78-2523X |true         |3891 MHz  |6          |189696 MB |189696 MB     |6                  |32768 32768 32768 32768 32768 32768                                                                                                                                                                                                            |s 4 KB m 64 KB |69          |3           |701days
CELCO |sdp29a   |POWER9  |IBM,9009-22A |OLOLO  |V7.2.4  |4.55.0 |11.2.0.4.200414 |Not installed |4.100.0    |1.6.0        |sys0!system:VL930_048 (t) VL930_048 (p) VL930_048 (t) |20210401     |7200-03-03-1913 |IBMULT3580-HH7  |11666OLOLO |No Exp Date     |NA                |cisco MDS 9148S|JPG23666LOL |8.1(1a)        |cisco MDS 9148S|JPG23666LOL |8.1(1a)        |NA        |NA             |NA              |NA                 |NA                                                                                           |NA                                                                            |NA        |NA              |NA              |IBM FlashSystem 900 |control 9843-AE3 |2666LOL            |1.6.1.0   |0                 |10.1.1.123:443 |10.1.1.145 |10.1.1.96 |NA        |1 78-580B0 |true         |3000 MHz  |8          |252928 MB |252928 MB     |8                  |32768 32768 32768 32768 32768 32768 32768 32768                                                                                                                                                                                                |s 4 KB m 64 KB |482         |2           |497days
CELCO-UPM1a:upm1:#

You can print necessary inventory data only:

upm1:# ./aix_hw_au.sh sdp | awk -F '|' '{print $2"|"$3"|"$44"|"$45"|"$46}' 
HOSTNAME |HW TYPE |CPU CLOCK |NUM OF CPU |RAM SIZE
sdp1a    |POWER8  |3891 MHz  |12         |253952 MB
...
sdp99b   |POWER8  |3891 MHz  |6          |186624 MB
CELCO-UPM1a:upm1:#

Or forward output into the file for further analysis:

CELCO-UPM1a:upm1:# ./aix_hw_au.sh sdp CELCO > CELCO.AIX.`date +’%d.%m.%Y'`.csv 
CELCO-UPM1a:upm1:# ls -lrt *.csv
-rw-r--r-- 1 root root 6310 Jan 20 22:43 CELCO.AIX.20.01.2015.csv 
CELCO-UPM1a:upm1:# wc -l CELCO.AIX.20.01.2015.csv
14 CELCO.AIX.20.01.2015.csv
CELCO-UPM1a:upm1:#

CISCO SWITCHES INVENTORY

Scripts are ready to use (cisco_hw_au.sh). Manual - TBD

JUNIPER SWITCHES INVENTORY

Scripts are ready to use (juniper_hw_au.sh). Manual - TBD

Known issues:

  • Junos 12.3R4.6 not compatible for Junos $base_os version get. You have to upgrade Junos
  • QFX switches returns "not valid not valid" for $boot_from - this is normal as per QFX hardware design
  • If script does not retrieve all the vars - set system services ssh rate-limit 50 on your Juniper

HOW TO IMPORT .CSV Inventory file into EXCEL

To import Inventory data from your .CSV file open Excel and go to Data > From Text/CSV: image

Choose your .CSV file and press “Open” - new window will appear. In new window choose --Custom-- as a delimiter, from the list, enter pipe (|) in the field right below and then press “Load”. image

The new Tab will be opened with your data.

#Thats all folks!