Hello,

I have a few laptops at work that do not report their service tag to the kbox. I'd like to report on these so I can manually look them up and replace them when their warranties expire.

Is it possible to do a SQL query and return this info?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
It's possible to query off ANY field in the database.

My question is, if there not reporting the service tag, how to we get the information?

If the service tag is truly being returned null in inventory, you may want to open a ticket.
Answered 01/17/2012 by: dchristian
Red Belt

Please log in to comment
0
I think it is a problem with the laptops more so than the KBOX. Our old inventory system did the same thing. For whatever reason the chipset forgets the service tag.

To be more specific, on the KBOX it simply says that it cannot retrieve the information from Dell's website, but if I check on our old inventory system (which is still running, for now) it shows the Service Tag as N/A.

A query with a null tag would also grab all of our BootCamp VMs but maybe we could also include a Manufacturer = DELL tag.
Answered 01/17/2012 by: BFonts
Senior Yellow Belt

Please log in to comment
0
This is a smart label "SerialBlank" we use to detect a blank serial number:

select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS
from MACHINE
where (( BIOS_SERIAL_NUMBER = '))


Note: That's two single quotes with nothing between them: BIOS_SERIAL_NUMBER = '
Answered 01/17/2012 by: RichB
Fourth Degree Green Belt

Please log in to comment
0
OOOOOOOOHHH

Now i get what your looking for.

Try this, see if it works.
SELECT M.NAME,
M.BIOS_SERIAL_NUMBER
FROM MACHINE M
WHERE M.BIOS_SERIAL_NUMBER IS NULL
AND CS_MANUFACTURER NOT LIKE '%DELL%'
Answered 01/17/2012 by: dchristian
Red Belt

Please log in to comment
0
ORIGINAL: dchristian

OOOOOOOOHHH

Now i get what your looking for.

Try this, see if it works.
SELECT M.NAME,
M.BIOS_SERIAL_NUMBER
FROM MACHINE M
WHERE M.BIOS_SERIAL_NUMBER IS NULL
AND CS_MANUFACTURER NOT LIKE '%DELL%'


I looked at the definition of BIOS_SERIAL_NUMBER and technically it can be NULL but not likely in practice. However, I did notice that it can contain a single space so this should CYA just in case:


SELECT MACHINE.ID, MACHINE.NAME,
BIOS_SERIAL_NUMBER
FROM MACHINE
WHERE (BIOS_SERIAL_NUMBER IS NULL OR BIOS_SERIAL_NUMBER=' OR LENGTH(BIOS_SERIAL_NUMBER)<2)
AND CS_MANUFACTURER NOT LIKE '%DELL%'


I also wrote it such that you could make a smart label out of it just by copying and pasting. If you see any weirdness not covered by this query then please let me know.
Answered 01/18/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity