Re: Search for a Service Tag in PC_BIOS by Computer Name
- From: "Garth" <Spam@xxxxxxx>
- Date: Thu, 20 Dec 2007 08:36:30 -0500
Thanks and you can blame Steve T. and other local to me influencers for nominating me for the award. The funny thing is the MVP logo shows up now because I move to “Windows Mail” and you now have to “login” to the newsgroups and this s a “feature” of the newsgroup/forums.
For asset tag, without modifying your sms_def.mof, I believe that it only shows up in one place. For serial number, take a look at an old article of mine on myITforum.com called PC Serial Number, http://www.myitforum.com/articles/1/view.asp?id=5385 it still applies to SMS 2k3 and ConfigMgr. Once you break it open it will help show you how to filter out bad SN and calculate the correct SN for the PC.
"David Schmidt" <DavidSchmidt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0433CE3B-57AA-49A2-A6C3-241939BA52AD@xxxxxxxxxxxxxxxx
Again, you are a breath of fresh air to this SMS maze!!
Glad to see the new "MVP" icon next to your name... :) You deserve it!!
Ultimately, I am trying to get an accurate list of PCs with Serial Number
and Asset Tag number. ( Unfortunately the asset tag, to my limited knowledge,
can only be found in system enclosure= SMBIOSAssetTag0 )
With this working code, I can then tweak all of the pre-existing MS reports
to show valid "count" information.
===
On a side note, thank goodness we use standardize servers, laptops and
workstations. Dell one-stop shop here. But even with Dell's own products,
information is a hit or miss when using SMS.
"Garth" wrote:
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 ....
>>
>>
>>
.
- 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
- From: Garth
- 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
- Prev by Date: Re: Search for a Service Tag in PC_BIOS by Computer Name
- Next by Date: Count number of folder in sms 2003 sp2 report
- Previous by thread: Re: Search for a Service Tag in PC_BIOS by Computer Name
- Next by thread: Count number of folder in sms 2003 sp2 report
- Index(es):
Relevant Pages
|
