SCCM Inventory Report

K

khisrawa

New Member
2
0
1
Hello

i need help on creating the query in sccm report.
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%'