As per the title, really. Haven't been able to find a way to create an SCCM 2007 R3 (System Center Configuration Manager) that will list all Windows 2008 and 2008 R2 systems with the Hyper-V role installed. Any help would be appreciated.
Probably the easiest way to get a simple list would be to take advantage of one of the built-in reports, such as the "Services - Computers running a specific service" report. You can then just input a service common to Hyper-V hosts, such as "Hyper-V Virtual Machine Management" (note that I know more about SCCM than Hyper-V this might not be the right service to look for, I just got it from looking at the running services report from a few of our Hyper-V servers).
You should be able to access this through SCCM's web reports with a URL like:
Alternatively if you're trying to create a collection query, the equivalent WQL would be:
If you just need to know which machines are virtuals, from http://blogcastrepository.com/blogs/mayki/archive/2008/09/17/tricks-sccm-query-for-virtuals.aspx: