• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

SCCM 2012 - Reporting on Application Catalog installations

Can anyone confirm whether I am able to report on whether a particular application has been installed onto a machine by the user via the Application Catalog and not a console driven deployment?

I've been scratching my head and going round in circles (neither of which helped) trying to find a particular flag or setting that would define whether the application in question, whether that be EXE, MSI or APP-V, has been deployed via the Application Catalog or via the console?

Please let me know if the above is not clear, and I'll do my best to elaborate.

Thanks,
Dean
0
deanomac
Asked:
deanomac
  • 2
1 Solution
 
deanomacAuthor Commented:
Stumbled across a possible answer myself.

If you run the following query, you will return all installations of the defined software that have been installed by the user and not the System account.

select *  from  SMS_AppDeploymentAssetDetails where SMS_AppDeploymentAssetDetails.AppName = "<APPLICATION NAME>" and SMS_AppDeploymentAssetDetails.UserName != "(SYSTEM)"

Open in new window


I'll have to do some more testing to see whether this query alone will differentiate between User initiated installations from the App Catalog and User targeted installations via the console, but it's a step in the right direction at least.
0
 
deanomacAuthor Commented:
This code expands on the above by adding a criteria that the deployment must be set to Available rather than Required.  This would mean that the user had to kick off the deployment rather than an engineer using the console and so would satisfy the purpose of the report required.

select *  from  SMS_AppDeploymentAssetDetails where SMS_AppDeploymentAssetDetails.AppName like  '%<APPLICATION NAME>%'  and SMS_AppDeploymentAssetDetails.UserName != "(SYSTEM)" and SMS_AppDeploymentAssetDetails.DeploymentIntent = 2 and SMS_AppDeploymentAssetDetails.CollectionName in (SELECT name FROM SMS_Collection  WHERE (CollectionType=1))

Open in new window


I'm now going to attempt to get the above into a report, expanding it to all applications and adding a count.  If i manage it, or someone is able to provide that, I will close this question.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now