My assumption is that you want the MAC Address returned in the results,
correct? If so, it should look something like this:
select distinct v_R_System.Netbios_Name0 AS "Computer Name"
, v_R_System.User_Name0 AS "Last Logged on User"
, v_GS_PC_BIOS.SerialNumber0 AS "Serial Number"
, v_GS_COMPUTER_SYSTEM.Manufacturer0 AS "Manufacturer"
, v_GS_COMPUTER_SYSTEM.Model0 AS "Model"
, v_GS_NETWORK_ADAPTER.MACAddress0 AS "MAC Address"
from v_R_System
inner join v_GS_PC_BIOS on (v_GS_PC_BIOS.ResourceID =
v_R_System.ResourceID)
inner join v_GS_COMPUTER_SYSTEM on (v_GS_COMPUTER_SYSTEM.ResourceID =
v_R_System.ResourceID)
inner join v_GS_LOGICAL_DISK on (v_GS_LOGICAL_DISK.ResourceID =
v_R_System.ResourceID)
inner join v_GS_NETWORK_ADAPTER on (v_GS_NETWORK_ADAPTER.ResourceID =
v_R_System.ResourceID)
where v_GS_LOGICAL_DISK.DeviceID0 = 'C:'
Order by v_R_System.Netbios_Name0
It looked like there was some unnecessary joins in your example code,
which are removed from mine. Also, it's worth noting that if a
workstation has more than one network adapter there will be seaprate
rows for each MAC Address.
Re: OT- Buying new computer, which way to go? ... least one more for image files.... My recent workstation is 4-500GB SATAII's ... I'd opt for a vid card with dual-head capability and 2 monitors. ... I believe that most of these recommendations will hold for a MAC,... (rec.photo.digital.slr-systems)
RE: WMI and Joining Domain (sysprep related) ... If you have a database of info like the MAC, Serial, Computer name, domain, ... I have vbscript examples for renaming the workstation and can manually ... (microsoft.public.scripting.vbscript)
Re: WMI and Joining Domain (sysprep related) ...Sysprep is performing a JoinDomain using a preset name with wildcards which works well - I simply logon to the pc after deployment and manually rename using our naming solution ... Is there any way to automatically have the systems named properly by querying the database for the info (I don't want db drivers installed on the workstation though so am willing to have the db exported to csv or to some flatfile for reading if necessary). ... One partial method I have available and can use after the fact is to open an IE window with an url containing the workstations mac address which returns the full workstation name in the innerhtml ... What I'd like is to have WDS or a post-install script run that will modify sysprep.inf or whatever else is needed to have the computer join with the appropriate workstation name. ... (microsoft.public.scripting.vbscript)
Re: Fastest PC - a Mac Pro ... making for an all-up price of the merest fraction ... That's the way it is for everything, not just Apple Macs.... equivalent of what they spent for that Mac, even if you can get it cheaper elsewhere. ... That the "fastest PC" being touted here is actually an expensive workstation.... (comp.sys.mac.advocacy)
Re: [OT] Problems with permissions etc ... Linux distros such as ubuntu use this scheme and I think MAC OS X does ...workstation that generates each transaction, so I am using the mac ... path for non-root users.... that I did this with a colleague who also has a user account on my machine, so the compile and install of wxPython was done from his home directory.... (comp.lang.python)
