Solved

Excel 2010: identify location network was accessed

Posted on 2014-11-10
6
113 Views
Last Modified: 2014-11-11
My client has a building with 2 floors and 200 desks. Everyone has the exact same laptop that can dock/use the internet at any desk whenever they want. This concerns my client, but IT mentioned to my client that they can detect when/where people dock at any time and can detect people that dock/use the internet but don't belong to the building. I'm thinking if the IT departments claim is true, then there is something unique at each desk. (i.e., a special address, number, something special about the connection there etc.,) Nonetheless, I didn't notice any special device at any desk other than the dock.

To prove IT is correct, my client would like for me create an Excel file with a button. When the button is pressed, it will display something unique about the place that was docked and/or internet was used.

Anyone have any ideas on how to do this? I'm willing to explore API. Below is a little piece of code I created originally, but it does not provide any information that is unique/representative of the location I docked or internet was used.

For x = 1 to 100
debug.print environ(x)
next
0
Comment
Question by:ouestque
  • 2
  • 2
  • 2
6 Comments
 
LVL 37

Assisted Solution

by:Neil Russell
Neil Russell earned 250 total points
ID: 40433634
The fact that IT can do it does not mean that YOU can do it.

It will, if the network is configured correctly, be able to log the MAC address of every computer that connects to the network and to what port on what switch they connected. From that they will know what docking station is connected to what wall/floor port and therefore what switch port. Now they can say that the computer with a mac address of BB:CC:DD:11:22:33 (For example) was connected to port 5 on switch 2 on the first floor from 09:00 to 12:00

The rest is easy,
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 40433679
Could you explain a little about the relationship? When you say "IT" do you mean the companies internal IT department?
You say "My Client", what is your role? What are you contracted to the company to do/provide?
0
 

Author Comment

by:ouestque
ID: 40433746
Thanks Neilsr. Based on your answer, My understanding is that there is no VBA or API calls I can use to figure out which switch or port I'm connected too?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 23

Accepted Solution

by:
DanCh99 earned 250 total points
ID: 40433950
The IT guys will almost certainly be pulling the logs off the switches to see who connected.  Some docking stations contain their own network ports, (and therefore MAC addresses), and so it's unlikely to be tracking those.  However, checking for hostnames would also work.  

There's also a whole bunch of network mapping tools from people like Solarwinds or SpiceWorks that will interrogate networks in real time.  

I'm not quite sure what using Excel to find something unique out about where you're working will prove to your client.  Of course the system knows where you're working.  Otherwise it couldn't deliver mail or internet traffic to you.  And if it knows, then its administrators know.  

I think there's a bigger picture here.  Sounds like the IT Guys are saying that there's some unauthorised access going on?  Is that what actually needs solving?

to show what info is held, you should be perhaps using IPCONFIG /ALL, TRACERt, PING, NBTSTAT -A and so on... But all better at a command line than from Excel.  Or, look at the network mapping tools yourself?
0
 
LVL 23

Expert Comment

by:DanCh99
ID: 40433959
0
 

Author Closing Comment

by:ouestque
ID: 40434996
Thanks guys. It sounds like I need to learn more about how all this works. I would love to read more about it. f you have any advice on some reading that could enlighten me more on how all this works will you post it? Thanks again.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now