SCCM report help

We need a report from SCCM 2007 R3 that lists all clients with IPX drivers loaded - doesn't appear any of the available reports have this - is it possible?
thanks!

Yes it is possible, I hate pointing you to a shop site but... ??
http://shop.enhansoft.com/products/network-logon-collection
 
 
BTW as a myITforum member you get a 20% discount by using the discount code “Brushy2012”

Thanks for the reply and link Garth - I checked the product and the price is very reasonable but based on the name "Network Logon Collection" and brieft description not sure if it will gather the information we are looking to get. Can you confirm the product reports on all machines with IPX protocol loaded and not just machines that have logged on using IPX protocol? (Should I contact Enhansoft to discuss?)

Using WMI you can see the two are linked:
(I dont have IPX installed so I am using UDP/IP for this example)

 
Associators of {Win32_NetworkProtocol="MSAFD Tcpip [UDP/IP]"}  
WHERE resultclass = Win32_NetworkAdapter 

 
However taking a look at my sms_def.MOF file, Win32_NetworkProtcol isn't reported on by default you'll enable that. You probably just need to report on the Name (and/or caption field) field.
I think this results in a view called "v_GS_PROTOCOL".
 
Assuming that the layout of this view is similar to v_GS_Network_Adapter, your query will look something like:
 

 
SELECT vrsys.Name 
FROM v_R_System vrsys 
INNER JOIN v_GS_PROTOCOL vgsp ON vrsys.ResourceID = vgsp.ResourceID 
WHERE vgsp.Name like '%IPX%' 

 
I dont have the class enabled for reporting in my PROD environment and my lab is out of action atm so this is a rough guess. If you do get it working please do post the final solution here.
I'll try and get my lab up and running again to test this tonight but no promises.

I did double check this today and it would only get the logon network details. Therefore it would show you every PC that has Novell client installed upon it.

Thanks Pvt_Ryan - will take a bit of time to get into production but based on tests this method looks to be the answer.
cheers