How to discover computers within a subnet

Hello fellas!

How can I discover all the PCs connected within my network's subnet and get results in a csv file with one 1st column displaying, 2nd, column IP and computer name and the third to show me whether is offline/online?

ie.

something like this
ping -a 192.168.1.1-254 result.csv | Find within result and sort strings...


In the output
result.csv
192.168.1.1 | WORKSTATION-A | ONLINE
192.168.1.2 | WORKSTATION-B | OFFLINE
192.168.1.3 | NOT FOUND | OFFLINE


Thanks,
If It makes it easier column 3 could be discard it

See Knowing the IP before logging in.. or a workaround!, it is not exactly same but last post may give you an idea. Also you can add a shutdown script that would append to the same file something like "hostname" shut down

GokAy,from your link, the sintax line thing I can come up with was this
ipconfig -all | find "Host Name" | find "IPv4 Address" >>iplist.csv

(before setting up a loop of course)
In my mind it should work, but in reality, I look like a sucker.... any ideas?