KACE Product Support

I'm trying to write a custom SQL for:
- For all computers with French operating system (I can only seem to look up by OS_NAME LIKE ''%Professionnel%'' - Is there a better way?)
- Supply a list of software grouped by name/version/language and give the count of each.

There's a view called SAM_VIEW_INVENTORY_ADD_REMOVE_PROGRAMS which contains the software language, but I can't figure out how to get this data myself. I've looked through all the tables and can't figure it out.

Does anyone have the source for the query SAM_VIEW_INVENTORY_ADD_REMOVE_PROGRAMS which I could look at and try to figure this out?

Thanks.