PENDING SCCM query for objectPath

[quentin]

Hello

i found an SQL query that i adapted in order to get all the SCCM applications located in "Software library/Applications" and it works nicely but i need to retrieve the "ObjectPath" column because i have a few subfolders i need to filter.
here is the query:

SELECT v_Applications.DisplayName,
v_applications.Manufacturer,
v_applications.SoftwareVersion
FROM v_Applications
LEFT JOIN v_Applications as applications on applications.DisplayName = v_Applications.DisplayName
Order by v_Applications.DisplayName


i found out that this may be achievable by using the "vSMS_Folders" table but after a lot of researchs, i couldn't find what i need.

does anyone knows how to achieve this ? or am i completely in the wrong path and there's another easiest way to do it ?


thank you for your help

 

[Garth]

All the supported views are listed here. https://docs.microsoft.com/en-us/me...lviews/sql-server-views-configuration-manager

No other views should be used. There are technical issues using non supported views.

 

[quentin]

Hi
thanks for the link .
so "v-applications" is not on the list. i guess i shouldn't use it .
what table can i use instead to get the applications ?
the table "v_SMSPackage" gives me the packages but i didn't find any for applications .

thanks

 

[Garth]

it is NOT support to query the tables directly as it might cause record locking. If it is not on the list, there isn't a lot you can do. At best you can submit a user voice request to make it or another view with the details available. Make sure that you state what data you want, why is it important to you and last post the link back here for others to vote it up. https://configurationmanager.uservoice.com/forums/300492-ideas

 

[quentin]

Thanks
i opened the request
here is the link

Site Deactivated – Welcome to Configuration Manager Feedback

thanks