Application Approval report

Question

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 5 months 2 Answers 485 views Beginner 0

Answers ( 2 )

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

  2. 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?

    https://snipboard.io/KqoHbw.jpg

    Best answer

Leave an answer

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