PENDING Query SQL - SCCM

[Rafael Moretto R Siva]

Dear, I need help building a query, could you help me?

There is a need to create a query via SQL to present the product code (present in regedit) of a specific software, for example:
The requirement is the partial name of the software and the presentation, the full name of the application, product version and its product code must appear.

ps: only three columns

 

[Garth]

What do you have now? What isn't working for you?

 

[Rafael Moretto R Siva]

What do you have now? What isn't working for you?

Hello, the queries I have in my database do not provide me with this information, that's why I asked for help.

 

[Garth]

Hello, the queries I have in my database do not provide me with this information, that's why I asked for help.

Since there is no query, Here is the listed of supported sql views.

SQL Server views - Configuration Manager

A Microsoft SQL Server view is a virtual table whose contents are based on the result from a SQL query.

learn.microsoft.com

 

[khisrawa]

can someone help me. i need to create a query code to identify all software installed in computer collection.
i dont know where to query this code
Select Distinct
sys.Netbios_Name0,
sys.User_Domain0,
sys.User_Name0,
sys.AD_Site_Name0

FROM
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
sys.ResourceID in (select sys.ResourceID
from
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
where
DisplayName0 like '%AppName%'
and Version0 like 'version')
and sys.Operating_System_Name_and0 like '%workstation%'

 

[Garth]

What is wrong with the built-in report for this?