Dr. K's Korner - Ideas For Success

 You have Dell devices, so do we! What’s the first thing you need when you want to look something up, contact support, or report on something? The Service Tag or Express Service Code. I’ve had more than one customer ask for the Dell Express Service code to be displayed, so we created a report that will convert that service tag to the express service tag for you. Once you have the report it’s easy to import that to assets (which would be displayed in the Inventory if it is linked to a device record).

Let’s take a look at the SQL:

select
 NAME,BIOS_SERIAL_NUMBER,@ecode:=CAST(CONV(BIOS_SERIAL_NUMBER, 36, 10) as CHAR) as 'Base-10',
 CONCAT(LEFT(@ecode, 3), '-', SUBSTRING(@ecode, 4, 3), '-',
 SUBSTRING(@ecode, 7, 3), '-', SUBSTRING(@ecode, 10, 3)) as 'Express Code'
from
 MACHINE
where
 CS_MANUFACTURER like '%Dell%'select 

This filters out records that are not Dell devices, and reformats the Service Tag into the express code. Pretty neat, right?! You could do similar things for other types of computers if you aren’t using Dell devices (why wouldn’t you?!). There’s no shortage of other ideas and reports at ITNinja.com – there’s even a couple of solutions like this for non-Dell equipment, of course.

About the Author