Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
29 rodolico 1 
select
2 
   device.name,
3 
   software.package_name,
4 
   software_version.version,
5 
   installed_packages.added_date
6 
from
7 
   device join installed_packages using ( device_id )
8 
   join software using ( software_id )
9 
   join software_version using (software_version_id )
10 
where
11 
   device.name = 'fileserver.primarycolors.local'
12 
   and software.package_name like '%samba%';