/saltstack-mac2csv

Turns the yaml output of the saltstack command ```salt -G os:windows network.interfaces``` and turns into a csv file

Primary LanguagePython

SaltStack-MAC2CSV:

Takes the yaml formatted output of the saltstack command salt -G os:windows network.interfaces and turns it into a csv file for easy review within a spreadsheet

Why?

  • Having a list of the salt names correlated to hardware addresses in a spreadsheet allows one to quickly search a network for a specific resource

Dependencies

  • Requires python3.x
  • Attempts to install the csv, tabular & rich libraries if not already installed

Input of the yaml file:

image

Screen Output:

image image

Output of the salt_hw.csv file:

  • Outputs a csv file with the computer name, and hardware address of all the devices seen in the yaml file

Updates

  • Better handles large saltstack yaml output by truncating the screen output to 25 entries, directing users to the csv file to see the rest (04/19/22)
  • Bug fix (04/19/22)