shaner3721 Posted November 15, 2011 Share Posted November 15, 2011 Hello All, I am new to automator, but I have learned to use it to some extent. What I need to do is take an inventory of certain machines (i.e.: serial number, computer name, ip address, mac address, etc.) and put it in an excel spreadsheet to be uploaded to an asset management system. I have written a vbscript to do this on the windows machine, but I am unable to use that for Mac OS X. Using Automator I would like to look up the system information and then place it in specific cells within an already created excel spreadsheet. Any insight on how to do this would be greatly appreciated. Please keep in mind, I am new at this so may need some additional explanations/information. Thank you, Shane Link to comment Share on other sites More sharing options...
shaner3721 Posted November 16, 2011 Author Share Posted November 16, 2011 Update: I have decided to try and use applescript for this process. I was able to pull the system information into an xml file by using the following line: do shell script "system_profiler -detailLevel full -xml > /users/skroening/systemInfo.xml" What I did was save it to my home directory. Now what I would like to do is tell applescript to look through the xml file and pull out certain information to put it in excel. Does anyone have any insight about doing this??? Thank you, Shane Link to comment Share on other sites More sharing options...
Recommended Posts