osql -L and sqlcmd -L need to display verision type

I can run other command and return all the SQL servers on the network which is great. There of so many of them and I also need the verision (ie standard or enterprise) anyone have a powershell command or dos command that can do that? I have 2003 and 2008 boxes.
Who is Participating?
LowfatspreadConnect With a Mentor Commented:
have you considered using

sqlcmd -Q "select @@version" -dmaster -E  against each server?
MXadminAuthor Commented:
The idea is to run it from a remote server and display results. If have to log into each machine it defeats the purpose of the project.
Anthony PerkinsCommented:
In other words you are not prepared to copy the output from sqlcmd -L and modify it in a text editor to match what Lowfatspread is advocating?

Or perhaps you are saying that you do not have permission to log on to all those SQL Servers?  If that is the case you may be SOL.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.