Re: Search for a Service Tag in PC_BIOS by Computer Name
- From: "Garth" <Spam@xxxxxxx>
- Date: Tue, 18 Dec 2007 11:34:16 -0500
It is a matter of perspective, I have clients who want to know the serial number of each docking station since they trace that information, however there are way to reduce/remove docking station SN. First step stop using System Enclosure as this is where docking stations SN are coming from normally.
Serial number for PC is one of the hard things to get only because manufacturers do not follow any standards and the SN in one table might not match what is listed in a second table! The question is which one do you pick and there are ~4 or 5 places to pick serial number from too, so...
Ultimately what are you trying to achieve? A list of PCs with SN?
"David Schmidt" <DavidSchmidt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1E951533-F9B6-4EAC-8A64-26FA117DB254@xxxxxxxxxxxxxxxx
hi Garth
Thanks for this explanation
The amount of duplicate entries is reduced when the "distinct" statement is
used.
We have more laptops than desktops, and all laptops are using docking
stations.
so I guess most reports will be rendered useless in this case :(
Bummer
"Garth" wrote:
Try adding the "Distinct" key word, However note that this might not get rid
of all of you duplicates, for example laptop with docking stations might
show up twice. PCs with the same name but two different serial numbers, etc.
SELECT Distinct ....
.
- Follow-Ups:
- Re: Search for a Service Tag in PC_BIOS by Computer Name
- From: David Schmidt
- Re: Search for a Service Tag in PC_BIOS by Computer Name
- References:
- Re: Search for a Service Tag in PC_BIOS by Computer Name
- From: David Schmidt
- Re: Search for a Service Tag in PC_BIOS by Computer Name
- From: Garth
- Re: Search for a Service Tag in PC_BIOS by Computer Name
- Prev by Date: Re: Search for a Service Tag in PC_BIOS by Computer Name
- Next by Date: Re: Search for a Service Tag in PC_BIOS by Computer Name
- Previous by thread: Re: Search for a Service Tag in PC_BIOS by Computer Name
- Next by thread: Re: Search for a Service Tag in PC_BIOS by Computer Name
- Index(es):
Relevant Pages
|
