?
Solved

SCCM 2012 - Reporting on Application Catalog installations

Posted on 2015-02-19
2
Medium Priority
?
368 Views
Last Modified: 2016-01-30
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
Comment
Question by:deanomac
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 4

Author Comment

by:deanomac
ID: 40620709
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
 
LVL 4

Accepted Solution

by:
deanomac earned 0 total points
ID: 40620866
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question