Comment exporter le nom des applications et la version depuis SCCM
SELECT
NormalizedName,
NormalizedPublisher ,
NormalizedVersion ,
COUNT( DISTINCT ResourceID) AS QTY
FROM
dbo.v_GS_INSTALLED_SOFTWARE_CATEGORIZED
GROUP BY
NormalizedName,
NormalizedPublisher ,
NormalizedVersion
ORDER BY QTY DESC
/***/
SELECT PRD .ProductName, PRD.ProductVersion
FROM
v_GS_SoftwareProduct PRD
inner join v_GS_Computer_System
where ProductVersion not like ‘%,%’ and ProductName not like ‘%,%’
/***/
select DISTINCT SYS .Netbios_Name0, SYS.Resource_Domain_OR_Workgr0 ,SP. CompanyName, SP.ProductName, SP.ProductVersion
FROM
v_GS_SoftwareProduct SP
JOIN v_R_System SYS ON SP .ResourceID= SYS.ResourceID
JOIN v_FullCollectionMembership fcm on sys. ResourceID=fcm .ResourceID
WHERE fcm. CollectionID = ”
ORDER By SYS. Netbios_Name0, SP .CompanyName, SP.ProductName , SP. ProductVersion
/***/
select distinct SYS .Netbios_Name0 computername, SP.DisplayName0 , SP. Publisher0, SP.Version0
FROM
v_Add_Remove_Programs SP
inner JOIN v_R_System SYS ON SP. ResourceID=SYS .ResourceID
WHERE
SP. Version0 not like ‘%,%’ and SP .DisplayName0 not like ‘%,%’
ORDER By
SYS. Netbios_Name0, SP .Publisher0, SP.DisplayName0 , SP. Version0