Network Monitoring Tool, calculate PC disconnections.

[mexiro]

Hello Guys,


I have somehow a complex question {As per my opinion }


I have created a tool, which monitors PCs in a network if they have a ping or not. Each 10 min. Then some macro writes in a sheet the pc name, and the time disconnected (no ping response)


Example is below:
PC NAME TIME of Disconnection
AFT00017 26/Oct/14 10:26
AFT00018 26/Oct/14 10:26
AFT00017 26/Oct/14 10:36
AFT00018 26/Oct/14 10:36
AFT00017 26/Oct/14 10:46
AFT00017 26/Oct/14 10:56
AFT00019 26/Oct/14 11:06
AFT00017 26/Oct/14 11:16
AFT00019 26/Oct/14 11:16
AFT00017 26/Oct/14 11:26
AFT00018 26/Oct/14 11:26
AFT00019 26/Oct/14 11:26


As you see here, macro is running each 10 min, and recording offline pcs. Example above: AFT00017 is offline between: 10:26-10:56, then goes online, then again offline in 11:16-11:26.


So from the above list I would like to have a summary (each week) like the below


PC Name Time of Disconnection Duration
AFT00017 26/Oct/14 10:26 30min
AFT00018 26/Oct/14 10:26 20min
AFT00019 26/Oct/14 11:06 30min
AFT00017 26/Oct/14 11:16 20min




After this summary comes the second part,


I need to visualize this as a gannt chart but again there is a problem. As you see in the above data AFT00017 is repeated twice, so in Gannt chart will be displayed as separate job (x axis). I would need some type of Gannt chart which could see in details (min hour) during a week or a month of time. So details are needed and the chart be very long so scrollable to see details on when the disconnections are.


Some google charts get close to it. There are some google chart which may display somehow what I want but I don't know if that is possible for very big data.
https://developers.google.com/chart/interactive/docs/gallery/timeline


or even Calendar chart of google gets close to it


https://developers.google.com/chart/interactive/docs/gallery/calendar




If you know some tips that would be very valuable


Thanks in advance!

 

[martindwilson]

cross post @
http://www.excelforum.com/excel-for...itoring-tool-calculate-pc-disconnections.html

 

[mexiro]

cross post @
Network Monitoring Tool, calculate PC disconnections.

Sorry, I am closing this thread then!