Please reply using this URL only: http://bugs.wpkg.org/show_bug.cgi?id=61
[EMAIL PROTECTED] changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|LATER |
------- Additional Comments From [EMAIL PROTECTED] 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.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
wpkg-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wpkg-users
