I was working with a customer today to create OMS alerts utilizing the recommendations provided by the OMS AD Assessment solution. During this working session, the customer requested a list of all AD Assessment recommendations so they could choose which individual workflows they wanted to configure for alerting. After a few minutes of query design, the following query will accomplish this task.
Note: If you are not seeing results you may need to adjust the time filter.
Type=ADAssessmentRecommendation | Dedup Recommendation | Select Recommendation,Description | Sort Recommendation
Of course we can easily export this list to Excel for review by clicking the Export icon on the top left of the Log Search page.
The same query will work for the SQL Assessment as well by simply chaing AD to SQL:
Type=SQLAssessmentRecommendation | Dedup Recommendation | Select Recommendation,Description | Sort Recommendation