ITNinja

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.

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.

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 = '

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%'

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.