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.
2020 04 13 14 04 32 4a91dbadd1bc16d7259043ef1fd6df2b - How To Manage Devices Community Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - Application Approval report

solved 0
Srishti Sinha 12 months 2020-04-30T06:39:35+05:30 2 Answers 546 views Beginner 0

Answers ( 2 )


    Yes It worked. I had to create a SQL query to the right information together though.
    Thanks Anoop.


    I don’t have the answer to your question.

    But I understand the automatic deletion of approval data only happens for Canceled or Rejected actions after 30 days.

    Can you also check the table USerApplicationRequestHistory?

    Best answer

Leave an answer

Sorry, you do not have a permission to answer to this question .