[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SCCM 2012 - Reporting on Application Catalog installations

Posted on 2015-02-19
2
Medium Priority
?
427 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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 …

656 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