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:

Screen Output:

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)