When a customer requests with a Returns or a Regrade report, use this query (replace (Box #) with the box number), then copy and paste the results (with header) into Excel, name the file and tab(s) to the box(es) number(es). If more than 1 box, name the file the type (returns or regrade) and the date of the report.
select distinct main.box as 'Box #', main_table.serial as 'STS Serial #', main_table.MANUFACTURER_SERIAL as 'Manufacturer Serial', main_table. MANUFACTURER as 'Manufacturer', iif(main.Manufacturer like '%Lenovo%', main.system_family , main_table.model) as 'Model Name', main_table.FORM_FACTOR as 'Form Factor', main_table.cpu as 'CPU Type and Speed', main_table.ram as 'Total RAM', main_table.hdd as 'HDD Size', main_table.os as 'Operatring System'
from incoming_audit.dbo.main
inner join Production_Audit.dbo.main_table on main.serial=main_table.MANUFACTURER_SERIAL
where box='(Box #)' and Main_Table.MANUFACTURER_SERIAL<>'N/A' and main_table.MANUFACTURER_SERIAL<>'INVALID'
Comments
0 comments
Please sign in to leave a comment.