Query SCCM 2012 for Deployments that Require Approval

I recently had the need to query the SCCM 2012 Database for All Application Deployments that require admin approval. Here’s a quick SQL Query that does the trick:

SELECT distinct CatalogAppModelProperties.Name, v_UserTargetedApps.RequireApproval
FROM CatalogAppModelProperties
INNER JOIN v_UserTargetedApps
ON v_UserTargetedApps.ModelName=CatalogAppModelProperties.OfferName
WHERE v_UserTargetedApps.RequireApproval = 1

This will return the “friendly” name of the application (i.e. the name that is defined for the Application Catalog):
ApprovalQuery

🙂

Advertisements

One thought on “Query SCCM 2012 for Deployments that Require Approval

  1. Invalid object name ‘v_UserTargetedApps’.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s