[CampusManager] How I imported my At Risk list to Excel - UPDATE

OK,

The original list was not the registered but the unregistered.

When I just tried the registered, it pushed the last digit of the IP
address up against the first letter of the last name of the next person.

Using find and replace I can find this joining, but not insert anything
to be able to break the list down.

Anyone got any ideas other than by hand, which is what I just did. That
is ok when the list is 100 people. I was looking for something for some
of the other screens though.

Mark

This was an interesting process and I am not sure how it will work with
other screens

We did an RPC scan and wanted to export the list of MAC - IP pairs that
came up vulnerable.

I went to topology view
Chose campus manager from the left hand panel
went to plugins
security

I chose the registered "online at risk" icon and double clicked
This brought up the state summary page
do an edit select all
do an edit copy
open up a blank excel spreadsheet
put the cursor in any cell and do an edit paste special - text
this puts the entire text of that window in one cell
open the cell and highlight the entire selection

I opened a blank word document
paste
now you have everything - but it is a mess and runs together

highlight the whole thing
do a find and replace
I experimented with doing a find on 00: and replace with !!!00:
Then I do a find on !!! and replace with a manual line feed (more - special)

presto - a MAC and IP list

Was this a pain - yes.
Did it work - yes
The third time I ran it - it took me less than 30 seconds to have a text
list I could import to excel

I don't know if it works for the other views, but I am certainly going
to check.

There are probably easier ways but this got so quick I probably won't
look for them. Bradford will add export functionality sometime in the
future. Until then I don't do this often enough to need more than this.

-- 
--
---- Mark
++++++++++++++++++++++++++++++++++
Mark Bauer
Network Administrator
Skidmore College
815 North Broadway
Saratoga Springs, New York 12866
Phone: 518-580-5996
email: mbauer_at_skidmore.edu