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 - HTMD 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

Answers ( 3 )


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


      Hello Srishti,

      Could you please share the query? I got the same requirement but somehow i am unable to get the desired output from USerApplicationRequestHistory no matter how much left join i do :)

  1. 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 permission to answer to this question .