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.