Subversion Repositories computer_asset_manager_v1

select
   device.name,
   software.package_name,
   software_version.version,
   installed_packages.added_date
from
   device join installed_packages using ( device_id )
   join software using ( software_id )
   join software_version using (software_version_id )
where 
   device.name = 'fileserver.primarycolors.local'
   and software.package_name like '%samba%';