Housekeeping for SCCM Application Catalog Requests
If you are looking at doing some housekeeping on your Application Catalog within SCCM for user requests then you will find that there is not a Microsoft supported why of doing this.
This has been causing us problem recently having approved software for a user and then the users going onto different machines and installing the software on various machines. This becomes an issue if the software they are using is licensed per machine and very expensive. Your friendly IT Department then have to go and uninstall the software and sort everything out!
UserApplicationRequests <br />
First of all, you can run a SQL statement against your SCCM database to see what is in the table, to do this, run this SQL script:
SELECT * FROM UserApplicationRequests <br />
In this table, you will see your users information and the details of their software request from the Application Catalog. In the CurrentState column, this will give you the current state of the request. Each number is represented as per below:
1 – Requested
2 – Cancelled
3 – Denied
4 – Approved