SCCM how to find installed software?

Hi all. Prompt, please, a request. Which allows you to see installed software, or other method.
March 19th 20 at 08:28
2 answers
March 19th 20 at 08:30
Solution
Right everything? Try this:

SELECT sys.Name0, sys.AD_Site_Name0, FCM.SiteCode, ARP.DisplayName0, ARP.Version0, ARP.InstallDate0
FROM dbo.v_R_System AS sys INNER JOIN
dbo.v_Add_Remove_Programs AS ARP ON ARP.ResourceID = sys.ResourceID INNER JOIN
dbo.v_FullCollectionMembership AS FCM ON FCM.ResourceID = sys.ResourceID AND ARP.DisplayName0 LIKE '%reader%'

Replace the %reader% to another name, or void.

Source: https://social.technet.microsoft.com/Forums/ru-RU/...
Not all of course, but SQL and Visual. Just don't quite understand what it wants me to report. But the license in Asseto does not want to apply. I live in a state of confusion - Edgardo37 commented on March 19th 20 at 08:33
Good popytka, but writes that sintaxis errors - Edgardo37 commented on March 19th 20 at 08:36
@Edgardo37, throw that error. - Asha.Rolfs commented on March 19th 20 at 08:39
@Asha.Rolfs, No. Just says that the Syntax contains errors - Edgardo37 commented on March 19th 20 at 08:42
@Edgardo37, and you changed the domain name and website? - Asha.Rolfs commented on March 19th 20 at 08:45
@Asha.Rolfs, /Yes, sort of.

Will it run the query?
select SMS_R_SYSTEM.ResourceID,
SMS_R_SYSTEM.ResourceType,
SMS_R_SYSTEM.Name
SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName is like "Opera"
- Edgardo37 commented on March 19th 20 at 08:48
@Edgardo37, check, I don't know :) - Asha.Rolfs commented on March 19th 20 at 08:51
@Asha.Rolfs, I just realized, what do we somehow not run Software Scan - Edgardo37 commented on March 19th 20 at 08:54
March 19th 20 at 08:32
Why do you need to fence manually the reports when you can use a ready-made solution in SCCM. Report server + Software scan , already there are all ready reports on all occasions.

Find more questions by tags System Center Configuration ManagerSystem administration