Application Approval report
I am trying to fetch a report for all users who requested the application along with their comments that they have submitted in Software center. I know that these comments can retrieve from SCCM console under “Approval Request” or SQL table UserApplicationRequest. However, when I approve the same request with my comments under “approver’s comment” section it gets override. Now If I run the query, it will show only my comment and not the user’s.
I noticed, if I open the property of that particular request, I do see the comment made by user. That means it is recorded some where. I use WMI explorer to see if this is getting capture in any of the class but could’t find any.
Is there a way to pull the comments of all those users who requested the application at sometime and now it is in approved state.