Thanks! That produces no errors but I can no results...
*-----------------------------------------------* *Adam Juelich* Pulaski Community School District <http://www.pulaskischools.org> Client Management Specialist 920-822-6075 On Mon, Mar 23, 2015 at 11:30 AM, Beardsley, James < [email protected]> wrote: > This’ll probably work for you. Just pop it into SQL Management Studio. > You could create a report out of it too if you’d like. > > > > Someone can correct me if I’m wrong but I believe where DeviceId0 = 12 > means it’s a wireless adapter – at least it appeared that way on my systems > – so that’s why I limited it to 12. You can comment that part of the where > clause to see if you get the same results. > > > > SELECT [SystemName0] > > ,[Manufacturer0] > > ,[Name0] > > FROM v_GS_NETWORK_ADAPTER > > WHERE SystemName0 <> 'NULL' > > AND Name0 not like 'Bluetooth%' > > AND DeviceID0 = 12 > > ORDER BY Name0 > > > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Juelich, Adam > *Sent:* Monday, March 23, 2015 10:59 AM > *To:* [email protected] > *Subject:* [mssms] Report all Wireless NIC's > > > > Hello Everyone, > > > > Does anybody have an existing report, or an easy way to create a report > that lists the Wireless NIC manufacturer and model for all devices in a > given site? I need to go through and confirm whether all our NICs support > the 5Ghz band. > > > > Thank you! > > *-----------------------------------------------* > > *Adam Juelich* > > Pulaski Community School District <http://www.pulaskischools.org> > > Client Management Specialist > > 920-822-6075 > > > ------------------------------ > > *Confidentiality Notice:* This e-mail is intended only for the addressee > named above. It contains information that is privileged, confidential or > otherwise protected from use and disclosure. If you are not the intended > recipient, you are hereby notified that any review, disclosure, copying, or > dissemination of this transmission, or taking of any action in reliance on > its contents, or other use is strictly prohibited. If you have received > this transmission in error, please reply to the sender listed above > immediately and permanently delete this message from your inbox. Thank you > for your cooperation. > >
