Monthly Archive 20 September 2018

ByPatrick

SCCM SQL products

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