Solved

SCCM 2012 - Reporting on Application Catalog installations

Posted on 2015-02-19
2
257 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to have a separate survey result in SharePoint 2013? 1 176
HP Server 9 151
Auto assign Category when openeing an email (Outlook) 7 58
VB.Net creating Contact in Outlook 1 93
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

738 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