Hello all,
First post and totally NOOB here!
I'm currently using the query below to find the LAN MAC address by entering the computer name in a prompted value.
select distinct SMS_R_System.MACAddresses, SMS_R_System.Name from
SMS_R_System where SMS_R_System.Name = ##PRM:SMS_R_System.Name## order by
SMS_R_System.Name
Is it even possible, and if so I'm hoping someone can help me figure out how to, query to find all MACs using the computer name in a prompted value?
Currently if I run the query on a laptop, it will not return the wireless MAC and this is what I'm looking for. Also, I have seen ways of running such queries but they do not differentiate between which MAC is which. Would it be better to write a script in PowerShell for this task?
Thank you!