Need SQL expert advice please. Trying to create a report. Details Below:
SCCM Version MECM 2111 with Latest Hotfix
4 MP, 2 SUP, 40 DP, 1 Dataware House, CMG, Co-Management Enabled, SQL With Always ON
I am trying to fetch all the application deployments which are marked as “Require Approval” and the e-mail address defined under “Approver’s E-mail” at the time of application deployment. Screenshot of the application deployment page where we see all these information’s to select and define Approver.
If the screenshot not clear then use link https://snipboard.io/7t6IxY.jpg