Way to search db for all apps assigned to a group?

[gfpstech]

Is there a way, or if not add a way, to search, say a smart group, and show all the apps assigned to that group? Or have I just completely missed how to do it?

Thank you!

[jrwilcox]

It is possible to write a script to do this. There is no way I know of to get this info using the provided GUI.

[dan-snelson]

@gfpstech Don't know if it'll help … our TAM provided the following MySQL query which returns app count per computer:

select r.computer_id, count(a.application_name) as app_count from reports r inner join applications a on a.report_id = r.report_id inner join computers_denormalized cd on cd.computer_id = r.computer_id where r.report_id in (select last_report_id from computers_denormalized) group by r.computer_id ORDER BY app_count;

[jrwilcox]

We are cloud hosted. I actually have some bash scripts that work for my environment.