Application Catalog to manage licensed products

Hi,

Anyone knows what view to query for "user category" in SCCM 2012? we have specific category called "license" and wondering where I can find it along with application name in SQL DB?

Thanks

August 28th, 2015 1:10pm

I would try one of those views (sorry can't test it right now)

v_UserTargetedApps

Lists each Configuration Manager application that has been deployed to a user. Includes the application ID (CI_ID), the collection to which the application has been deployed (if any), and whether the application requires approval.

This view can be joined to other views by using the CI_ID or CollectionID columns.

v_UserTargetedClassicApps

Lists each package and program that has been deployed to users. Includes the program ID, the category, the publisher, the package and program name and more.

This view can be joined to other views by using the ProgramID, PackageID, or CollectionID columns.
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 9:15pm

Thank you for the info but unfortunately I don't have any of these views in my DB. Do you know if they are from specific SCCM version? Ours is SCCM 2012 R2 SP1, it might be by different name?

thanks

August 28th, 2015 11:32pm

Thank you for the info but unfortunately I don't have any of these views in my DB. Do you know if they are from specific SCCM version? Ours is SCCM 2012 R2 SP1, it might be by different name?


I can confirm that both of those views existing in CM12R2 SP1
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2015 1:38pm

Any suggestion as why it would not show in my DB? See below the image

.

  • Edited by IHunzai 12 hours 3 minutes ago
August 29th, 2015 3:44pm
My bad, I was looking at the CAS.. it exists on PRI.. thanks. I still would like to see SQL query on CAS if possible,  to search for apps with custom "user category".
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2015 4:05pm
Are you doing all you management on the CAS? If not, why not?
August 29th, 2015 7:00pm

Any suggestion as why it would not show in my DB? See below the image

.

  • Edited by IHunzai Saturday, August 29, 2015 7:46 PM
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2015 7:44pm
Yes, all our managements like deployments, package/application creations, reporting, collection creations everything is done on CAS.
August 30th, 2015 9:57pm
Then I don't know why.. You might want to open a support call with CSS to find out why.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 8:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics