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.
UserApplicationRequests <br />
In here there is all the information about your users requests include a column called:
CurrentState <br />
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 <br /> ORDER BY LastChanged <br />
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 <br /> SET CurrentState= 1 <br /> WHERE CurrentState = 3 <br />
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.