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
kashif Ali 4 weeks 2021-03-19T17:59:38+05:30 4 Answers 22 views Beginner 0

Answers ( 4 )

  1. kashif Ali
    1
    2021-03-30T16:00:36+05:30
    Reply

    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

    • Anoop C Nair
      0
      2021-03-30T16:25:34+05:30
      Reply

      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.

      Best answer
  2. kashif Ali
    0
    2021-03-22T18:30:07+05:30
    Reply

    Thanks anoop.

    Will check and update.

  3. Ankit Shukla
    1
    2021-03-20T04:23:35+05:30
    Reply

    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/

Leave an answer

Sorry, you do not have a permission to answer to this question .