Re: SMS' Database views

"German Suazo" <germans@xxxxxxxxxxxx> wrote in message
news:518672C4-4824-4E41-B0DC-1099586922D5@xxxxxxxxxxxxxxxx
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.

I see you posted an identical question in *.misc

As Garth mentioned, there is variation in where the serial number gets
stored, you could try this query as a starting point:

Here's an excerpt from a query that will give you that information (I had to
alter it here, so hopefully it still works :)

SELECT v_R_System.Netbios_Name0 AS [Computer Name],
v_GS_COMPUTER_SYSTEM.Model0 AS Model,
v_GS_PC_BIOS.SerialNumber0 AS [Serial Number]
FROM v_R_System INNER JOIN v_GS_PC_BIOS ON
v_R_System.ResourceID = v_GS_PC_BIOS.ResourceID INNER JOIN
v_GS_COMPUTER_SYSTEM ON v_R_System.ResourceID =
v_GS_COMPUTER_SYSTEM.ResourceID
WHERE ( v_R_System.Client0 = 1)


Steve



.

Relevant Pages

  • Re: How to add multiple computers into collection
    ... An alternative would be to build queries that expose the ... Package and Collection data from the database using WQL ... Put the following query code in to the respective query ... specify the sms site servers name. ...
    (microsoft.public.sms.admin)
  • Re: SMS Admin MMC cannot locate the site database
    ... Once you open WBEMTEST and connect to your namespace, ... main window and select the query button, then put it the query string I ... First confirm you have WMI connectivity to your site server. ... You should get an entry back with a namespace path to the actual SMS ...
    (microsoft.public.sms.admin)
  • Re: SQL query in web reporting
    ... > It seems as though it is an Internet Explorer error instead of a query ... So again, I thank you for fixing my query syntax error, ... Has it something to do with permissions on the tables or SMS ... Is your user account a member of the sms reporting users group on the ...
    (microsoft.public.sms.admin)
  • Re: How to add multiple computers into collection
    ... simplified the SMS administration. ... An alternative would be to build queries that expose the ... Put the following query code in to the respective query ... that script will dump the collection names + ID's ...
    (microsoft.public.sms.admin)
  • Re: QUery for DC
    ... I meant in SMS. ... "Terry Matthews" wrote in message ... > Steps to Create a Query to Find All Domain Controllers at a Site ... Attribute class: Computer System ...
    (microsoft.public.sms.admin)
Loading