Software Reports - Purchased vs Installed software

Software Reports - Purchased vs Installed software

Hi There,

I need the ability to report on the Microsoft Office software we have installed on all PC's.
 
I need this filtered and displayed by Region and Site, so I can see which Region and corresponding site are using our licences and where any freefall we have may lay.
 
Can someone provide the SQL for this?

Many Thanks,
Allan

                  New to ADSelfService Plus?