Re: SMS' Database views

Not all PCs use the System_enclosure to store the Serial number, some use PC
Bios and othe use BaseBoard. Also watch out for invaild SN #.



"Torsten [MVP]" <torsten.meringer@xxxxxxxxxxxxx> wrote in message
news:egsqgqrozqag.6x904d7dzphq.dlg@xxxxxxxxxxxxx
Hi,

column SerialNumber0 in the table v_GS_SYSTEM_ENCLOSURE.

Torsten
Microsoft MVP - SMS

Am Thu, 25 Jan 2007 10:46:04 -0600 schrieb German Suazo:

Hello!

We are working with a client on developing custom reports, and we would
like
to know what is the view and field where we could find the Serial number
of
all the machines inventoried by SMS. The thing is that our client wants a
report of all the PCs sorted by its serial number to use it like an
unique
identifier, so, if a PC is formated and installed as new, they will find
it
by its serial number instead of by its SMS ID or name.


Thanks.


.

Loading