Re: SMS' Database views

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.
.

Relevant Pages

  • SMS Database views
    ... We are working with a client on developing custom reports, ... 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. ...
    (microsoft.public.sms.inventory)
  • SMS Database views
    ... We are working with a client on developing custom reports, ... 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. ...
    (microsoft.public.sms.misc)
  • Re: SMS Database views
    ... Not all PCs use the System_enclosure to store the Serial number, ... column SerialNumber0 in the table v_GS_SYSTEM_ENCLOSURE. ... Microsoft MVP - SMS ... We are working with a client on developing custom reports, ...
    (microsoft.public.sms.inventory)
Loading