Sql question

[techmeone]

Lansweeper captures my Dell Computer service tag information, with no problem

However, I aslo need to track Dell ExpressServiceCode and Lansweeper does not capture that.
I decided to convert the service tag using a scalar-valued function and then update dbo.tblBIOS
with results.

So far I have:

1. created new view [dbo].[web30repexpressservicecode]
AS
SELECT [ComputerName] AS [Computer Name],[Manufacturer] AS [MFG],[SerialNumber] AS [Tag],
[ExpressServiceCode] AS [Express Service Code]
FROM dbo.tblBIOS

2. created new scalar- function called dbo.f_convert_to_base36

3. testd function by executing the following statement:

SELECT [SerialNumber] AS [hex], dbo.f_convert_to_base36([SerialNumber],36) AS [decimal]
from dbo.tblBIOS

Issue: I'm not sure how to call the function and update column ExpressServiceCode in tblBIOS
with those values?

[techmeone]

FYI

I was able to get this to work without creating a separate database by using
following statement:

USE lansweeper32
GO

SELECT [SerialNumber] AS [hex], dbo.f_convert_to_base36([SerialNumber],36) AS [decimal]
from dbo.tblBIOS

UPDATE dbo.tblBIOS
SET ExpressServiceCode=dbo.f_convert_to_base36(SerialNumber,36)

[Hemoco]

I would suggest to create a new custom table.
Even if your sql would work, it would be overwritten by a new scan.

You will need an "insert into <newtable>"

[techmeone]

RE: Do you know if "ExpressServiceCode" can be captured using WMI?

We uninstall the dell tools when we image PC's.
Therefore, the ExpressService Code is not stored on the PC anywhere.

The express service code is the base 36 equivalent of the Service Tag number
I created a function in sql to convert the Serial Number (Service Tag) to base 36.
The function works, now I need to update the table dbo.tblBIOS with the results.
And I can't find the right sql statement, I've tried UPDATE, INSERT, and even
tried casting it as a view?

[Hemoco]

Do you know if "ExpressServiceCode" can be captured using WMI?