We need a report that print a this example, but with license key and product ID.

SELECT 
workstation.WORKSTATIONNAME,
manufacturer ,
workstation.MODEL,
aaaUser.FIRST_NAME,
deptDef.DEPTNAME,
softList.softwarename,
softList.softwaretypeid FROM systeminfo workstation
LEFT JOIN softwareInfo software ON software.workstationID=workstation.workstationID
LEFT JOIN softwareList softList ON software.softwareID=softList.softwareID
LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID
LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID
LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID
LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID
LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID
LEFT JOIN DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID
where softList.softwaretypeid IN ( "601", "602" ) ORDER BY workstation.WORKSTATIONNAME , softList.softwaretypeid

601= Operate System MS

602= Software aplication