|
List of PCs by IP Range and have Serial Number
Hello:
Our asset manager needs a report of PCs by location (all of our locations are broken down by VLAN, for example, 10.131.0.0 is Des Moines, 10.133.0.0 is Freeport etc....). She would like a report that lists all of the machines by location (ie, VLAN IP) has Computer Name, Exchange Info and Serial Number. I am not even a SQL novice. As such, I have no clue where to begin. Any help would be much appreciated.
Thanks,
__________________
Ronald Kolman ACE, MCSE
Sr. Associate-Systems Administrator
Clifton Gunderson LLP
Madison, WI
(nospam)ronDOTkolmanATcliftoncpaDOTcom
|