Please reply using this URL only: http://bugs.wpkg.org/show_bug.cgi?id=61 arthur.van.dongen at tsolve.com changed: What |Removed |Added Status|RESOLVED |REOPENED Resolution|LATER | ------- Additional Comments From arthur.van.dongen at tsolve.com 2007-03-09 17:20 ------- Getting the information into the wpkg_web looks feasible. This is the query to get the information into the hosts list: select hosts.id as id,priority,regex,prof_id,profiles.name as name, count(installed_packs.package_idtxt) as pack_cnt from hosts left join profiles on ( hosts.prof_id=profiles.id ) left join installed_packs on (installed_packs.hostname like replace(hosts.regex, '.*', '%')) group by hosts.id order by priority , making use of the regular expressions in MySQL to match host regex to the installed hosts. This is what I intend to do: - Add columns with the number of installed packages in the hosts, profiles and packages overviews, using queries similar to the one above; - When you click the count, you get a list of hosts, packages and versions filtered on the view you had before. -- Configure bugmail: http://bugs.wpkg.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact. _______________________________________________ wpkg-users mailing list wpkg-users at lists.wpkg.org http://lists.wpkg.org/mailman/listinfo/wpkg-users |