Configuration Manager – Change the Approve/Deny Status of an Application Catalog Request
If you are a Configuration Manager 2012 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:
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
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:
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 comments on this, please feel free to use our Disqus system below.