Configuration Manager – Change the Approve/Deny Status of an Application Catalog Request
If you are a Configuration Manager administrator, the chances are that you are using the Application Catalog to allow users to install their own software.
In here there is all the information about your users requests include a column called:
These may also help you...
- How to Mass Unfollow on Instagram Online
- Windows Server 2008 R2 Evaluation Product Keys
- How to Mass Unfollow Everyone on Twitter
There are four numbers that make up the current state of a user application request – they are:
- 1 – Requested
- 2 – Cancelled
- 3 – Denied
- 4 – Approved
So, you can now run a query on your CM database like this to show you all Denied user approval requests:
SELECT * FROM UserApplicationRequests WHERE CurrentState = 3 ORDER BY LastChanged
In our example, we are going to use an extreme – we want to change ALL of our Denied CurrentStates back to Requested – then we can go into the Configuration Manager Console and manually approve or deny them.
To this, you can run the following query on your CM database:
UPDATE UserApplicationRequests SET CurrentState= 1 WHERE CurrentState = 3
What this query does is updates the UserApplicationRequests table to make CurrentState = 1 where the CurrentState is = 3.
If you now go into your Configuration Manager Console, you should see that all your Denied requests are now back into a Requested state.
If you have any questions or feedback about this post, or if you would like us to create any queries for you, please go ahead and leave us a message below in the comments section and we will get back to you as quick as we can.