Sql query to get localized application name of all the application
Question
Hi Anoop,
Do we have any sql query so that I can get localized application name of all the applications in sccm.
I have tried getting the information from table v_applications however localized application name is not available.
Any help will be appreciated.
solved
0
Configuration Manager
4 weeks
2021-03-19T17:59:38+05:30
2021-03-19T17:59:38+05:30 4 Answers
22 views
Beginner 0
Answers ( 4 )
Hi Ankit,
Was unable to get the desired result.
I have additional requirement, to get object path of the localized display name of the application along with localized display name.
With powershell I was able to get the localized display name of the application but i am unable to get the object path.
Anoop C Nair please suggest
I think you need to develop the SQL query that is shared by Ankit. I mean you can check whether this information is collected and available in SQL DB or not.
If so, you can easily change the query or add additional columns to include the details that you need.
Thanks anoop.
Will check and update.
Can you check below query it may help you you might need to modify a little.
https://www.anoopcnair.com/sccm-sql-query-to-find-collections-used-for-app-deployment/