Report of Wireless Mac Addy's

[scruffy]

Afternoon,

 

Would you know if there is a way to create a report with the following information?

 

Machine Name

Model

Serial Number

Operating System

Service Pack

Wireless Mac Address

 

The key here being Wireless Mac?

 

From what I can see SCCM only captures the wired nic's addy.

[RebelRenegade]

Just whipped this up w/o looking over your entire list of requirements. It just includes Name, MAC Address and Interface Name, but you can easily add Model, Serial Number, OS and Service Pack to it.

 

The other tables you want are dbo.v_GS_PC_BIOS.SerialNumber, dbo.v_GS_COMPUTER_SYSTEM.Model0 and dbo.v_GS_OPERATING_SYSTEM.Caption0. Don't know how to get SP level in there off the top of my head, but I'm sure it's under GS_Operating_System or something similar.

 

 

 

SELECT TOP (100) PERCENT dbo.v_R_System.Netbios_Name0, dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0,

dbo.v_GS_NETWORK_ADAPTER.MACAddress0, dbo.v_GS_NETWORK_ADAPTER.Description0

FROM dbo.v_R_System INNER JOIN

dbo.v_GS_SYSTEM_ENCLOSURE ON dbo.v_R_System.ResourceID = dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID INNER JOIN

dbo.v_GS_NETWORK_ADAPTER ON dbo.v_R_System.ResourceID = dbo.v_GS_NETWORK_ADAPTER.ResourceID

WHERE (((dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = '8') OR

(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = '9') OR

(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = '10') OR

(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = '14'))

AND ((dbo.v_GS_NETWORK_ADAPTER.Description0 LIKE '%WIFI%') OR

(dbo.v_GS_NETWORK_ADAPTER.Description0 LIKE '%Wireless%')) AND ((dbo.v_GS_NETWORK_ADAPTER.Description0 NOT LIKE '%Virtual%')))

ORDER BY dbo.v_R_System.Netbios_Name0