Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Can I do this with ghost console?

Updated: 21 May 2010 | 3 comments
RobJCW's picture
0 0 Votes
Login to vote

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

Nigel Bree's picture
30
Sep
2009
0 Votes 0
Login to vote

 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.

mrguitar's picture
30
Sep
2009
0 Votes 0
Login to vote

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).

:)

RobJCW's picture
30
Sep
2009
0 Votes 0
Login to vote

I do not have the inventory

I do not have the inventory piece functional, so it is not an option for me.