SELECT ( systeminfo.workstationname ) "Workstation",
( net.ipaddress ) "IP Address",
( softl.softwarename ) "Software Name",
( softwarelicenses.licensekey ) "LicenseKey" FROM softwareinfo
LEFT JOIN softwarelist softl
ON softwareinfo.softwareid = softl.softwareid
LEFT JOIN softwaretype
ON Softl.softwaretypeid = softwaretype.softwaretypeid
LEFT JOIN systeminfo
ON softwareinfo.workstationid = systeminfo.workstationid
LEFT JOIN resources resource
ON systeminfo.workstationid = resource.resourceid
LEFT JOIN networkinfo net
ON softwareinfo.workstationid = net.workstationid
LEFT JOIN resources ress
ON softwareinfo.licenseid = ress.resourceid
LEFT JOIN softwarelicenses
ON ress.resourceid = softwarelicenses.resourceid
WHERE softwarelicenses.licensekey IS NOT NULL
ORDER BY 1