OMS – Create a List of Assessment Recommendations For Alerting

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

Capture.PNG

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.

2016-07-27_15-01-43.png

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 RecommendationCapture

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s