Management Insights - copy results
Management Insights > Applications without deployments.
The results of this display in a small, unsizeable window and the text results cannot be copied out.
Adjust the window so that it can be resized, and allow the text to be copied out or exported to CSV.
Andrew Petersen commented
It would also be nice to know what criteria it's using to determine whether any given app has a deployment or not. In my environment, it appears to be excluding some apps that don't have deployments from its results, and *not* excluding some which are referenced by task sequences but don't have stand-alone deployments of their own. Obviously if an app is in a TS, you wouldn't want to delete it. Even given that the MI is not excluding some things that I am, the report I wrote to display apps w/o deployments before I knew about MI returns ~1.6X as many apps as the MI does, so I'm not convinced the MI is actually useful.
I have similar concerns regarding the empty collections MI - if I query v_Collections for collections with MemberCount = 0, I get ~2.5x as many collections as the MI provides.
None of the documentation I've been able to find so far gives any detail on how MI is making these determinations, so it's really hard to understand the differences in results, and without understanding, I'm leery of actually making use of MI.
You can create a report and add this to your dataset:
select distinct ObjectId from vSMS_ManagementInsightResultsList where QueryID='B585E3FF-585F-4CE9-AE2C-648A7CA2F143'
run this to grab the all the IDs and Names of the available Management Insight data:
SELECT ID,Name FROM vSMS_ManagementInsights
Charles Herrington commented
or at least make the results window non-modal so you can keep it open and still go back and implement the recommendations