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
LVL 4
deanomacAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.