Hi all,
given that Drupal 7 is now in the wild and that module updates will be coming thick and fast over the coming months I'm trying to figure out how to get to grips with which of my sites have what modules installed.
In a perfect world I'd have a Drupal site which knows about all the other Drupal sites that I have, what modules are installed on them and what versions those are. A little like Aegir and Update Status for modules. Does such a thing exist?
These Drupal sites live on various servers and would ideally have a module installed on each that reports to the parent what modules it's using and whether they need updating. The parent site would then use views with filters or something similar to all you to drill down.
For example with the recent Webform Module security update, I'd love to be able to go to my parent site, choose "Webform" from a modules dropdown, "v3" from another and then get all sites with webform V3 installed, then I could easily go and update each of them.
I currently have a tool like this but it requires data to be input and maintained, which is not 100% reliable. I'd rather have it updated automagically. I'm sure I could hack Update Status with XMLRPC or some other kind of web service to do this but thought I'd check if "There's a module for that" first.
If not would anyone be interested in collaborating on one?
Happy new year all.
Col.

Comments
Upgrade status module
Can't recall who, but someone was telling me about http://drupal.org/project/upgrade_status recently... it helps you tell when your modules are available so you know when you can upgrade a site.
It's only made to work within the site in question, but I'm sure there'd be a way to embed that page into another site if you really wanted.
Aegir basically already does
Aegir basically already does this. It knows what version of which modules are installed on each platform. You'd just have to build an addon that would tell you which needed security updates and flag the appropriate platforms for that.
The Coder module does this
The Coder module does this within a site... but I bet the Network Manager module might have this capability. Although I believe it is limited to authorized access to sites on a particular network or server.
http://drupal.org/project/network_manager
http://drupal.org/project/coder
You can install Nagios.
You can install Nagios. http://www.nagios.org/ It will also send you an email if your site is down. Then for each Druapl site that you want to monitor, install the Nagios Drupal module http://drupal.org/project/nagios. The module will tell Nagios what modules are out of date and notify you by email if you want.
Take a look at Shepherd. I
Take a look at Shepherd. I haven't tried it out but it does look interesting.
For the problem "make it easy to know when a site needs attention" we're beginning to use Nagios and aggregate all the notifications on a single site. The nagios module won't tell us that a particular module needs upgrading but only that on a certain site there are contrib modules with available updates or security updates (and some other great notifications).
So we can't get a list of all the sites with Webform (but that's not part of the problem we're solving).
if you change the "UNIQUE ID"
if you change the "UNIQUE ID" in the Nagios module and your Nagios server setting, it will tell you which particular modules needs to be updated. This prevents any unauthorized users from knowing which of your modules are out of date.
I stand corrected. It seems
I stand corrected. It seems depending on the status of certain notices, Nagios will report on individual modules.
How about Droptor ?
Don't know how good this is but I just came across the module http://drupal.org/project/droptor
It uses an external provider but at $2 per month per site it might be worthwhile.
The reports and functions on their website look pretty good.
Hey all. I created Droptor.
Hey all. I created Droptor. If you have any questions, drop me a line.
Not tracking
You don't have all your sites under version control and know what is deployed in production?
In a perfect world.
I'm assuming that's a rhetorical question :). In my perfect world I do have all of them under version control, but even with version control I still wouldn't' have one central place to review and drill down through all of the sites and module versions in an easy to use (for non developers) interface.
All of the responses so far are very helpful and I'll look into them all, however I still think that they don't solve the issue at hand or fully understand the question. I need a report (like a view) that lists all of my sites and the modules installed on them, that has some filtering for modules and versions. This data would be pulled or pushed from these individual sites regularly (on cron run).
Cheers,
Col.