Custom report but won't list devices if warranty info isn't available
I have a custom report (below) that goes out to key people throughout our organisation that shows some basic information regarding what device belongs to who, its spec and its shipping date (so they know old teh equipment is)
However if KACE can't get the Dell Service information to identify the shipping date it just doesn't show at all on the report.
Is there a way I can still show the device but the column for shipping date would just be blank?
MACHINE.NAME As SYSTEM_NAME,
ASSET_OWNER.USER_NAME As ASSIGNEE_LOGIN,
ASSET_OWNER.EMAIL As ASSIGNEE_EMAIL,
round(Sum(MACHINE_DISKS.DISK_SIZE), 2) As MACHINE_DISKS_DISK_SIZE,
MACHINE Left Join
ASSET On ASSET.MAPPED_ID = MACHINE.ID
And ASSET.ASSET_TYPE_ID = 5 Left Join
USER ASSET_OWNER On ASSET_OWNER.ID = ASSET.OWNER_ID Left Join
ASSET_DATA_5 On ASSET_DATA_5.ID = ASSET.ASSET_DATA_ID Left Join
MACHINE_DISKS On MACHINE_DISKS.ID = MACHINE.ID Inner Join
DELL_ASSET On DELL_ASSET.SERVICE_TAG = MACHINE.BIOS_SERIAL_NUMBER Inner Join
DELL_WARRANTY On DELL_WARRANTY.SERVICE_TAG = MACHINE.BIOS_SERIAL_NUMBER