Today I was working at a customer and configuring the Application Catalog using Configuration Manager 2012 R2. The customer was interested in the application approval process but was a little disappointed that out-of-the-box it’s not possible to receive notifications when an approval request arrives in Configuration Manager.
As the customer only has Configuration Manager it’s not possible to use any other System Center product like Orchestrator or Service Manager to get things going.
I created an alternative under the form of a Powershell script that runs on a specific schedule (eg. Once every day) to gather all application requests that have a pending approval. This report is emailed to the IT mailbox of the customer. This also makes sure that an administrator doesn’t have to check every now and then in the approval request section of the Configuration Manager console to see if anything new has arrived.
What the script does is basically the following:
- Reading all data from the WMI class SMS_UserApplicationRequest
- Filtering all requests which have a current state of 1 ( which means requested)
- Creating an HTML document which displays a table with all pending requests
- Sending an email to the IT mailbox with the table as contents. The table contains per request: username, application name, comments and last modified date
The report looks as follows
Anyone that might be interested in this script can comment below and I’ll be happy to help.