Can I do this with ghost console?
Updated: 21 May 2010 | 3 comments
My supervisor informed me he would like a list of all the mac address of a current lab. This lab is in ghost console, how do I export all the mac address' of the lab I need to an excel spreadsheet for my supervisor using ghost console?
discussion Filed Under:
Comments
I don't believe you can do
I don't believe you can do this from within the console itself, but it's not very complicated to extract this information from the Console's database directly using Windows Script Host and then you can use any number of other techniques to put that data into a form that you can use from Excel (for instance you can write a simple script can write a .CSV text file that Excel can read, or you can write more complex script to either modify a worksheet using ADO or use the Excel object model to create or modify a worksheet).
The MAC address list for a machine - and bear in mind that it IS a list, since machines can have many network adapters - is stored in the console database in binary form, and you can see some code which queries the Machine table in the database and then converts the binary list field into a text string. That script contains all the elements you need to extract this kind of data from the console and then you can customize it to write out the data in the form you want.
Nigel, why not run an
Nigel, why not run an inventory report?
Under Inventory create a new view that contains: Network Adapter.MacAddress
Then create a report that uses your lab as the target, check use view, and browse to your new view. Run the report, and export to a CSV which will open perfectly in Excel. You may wish to clean-up the spreadsheet a little, but this is much faster than typing in all your MACs by hand & faster than writing a script (at least for me).
:)
I do not have the inventory
I do not have the inventory piece functional, so it is not an option for me.
Would you like to reply?
Login or Register to post your comment.