Tuesday, July 25, 2017

Count of installed software's

Count of installed software's  :

select
    DisplayName0,
    Version0,
    Count (Distinct arp.ResourceID) AS 'No Of Installed'
From
    dbo.v_Add_Remove_Programs ARP
Where
    DisplayName0 in ( 'Microsoft Office Professional Edition 2003','Microsoft Office Standard Edition 2003','Microsoft Office Enterprise 2007',
'Microsoft Office Standard 2007','Microsoft Office Professional Plus 2007',
'Microsoft Office Project Professional 2003','Microsoft Office Project Standard 2003',
'Microsoft Office Visio Professional 2003',
'Microsoft Office Visio Professional 2007','Microsoft Office Visio Standard 2003','Microsoft Office Visio Standard 2007',
'Microsoft Visual Studio 2005','Microsoft Visual Studio 2008',
'Microsoft Visual Studio 2005 Professional Edition – ENU','Microsoft Visual Studio 2005 Team Suite – ENU','Microsoft Visual Studio 2008 Professional Edition – ENU',
'Microsoft Visual Studio 6.0 Enterprise Edition','Microsoft SQL Server 2005','Microsoft SQL Server 2000',
'Microsoft Project 2000 SR-1','Microsoft Project 2000','Microsoft Office 2000 SR-1 Professional','Microsoft Office 2000 SR-1 Standard','Microsoft Exchange','Microsoft Visio 2010 Professional','Microsoft Visio 2010 Standard')

Group by
    DisplayName0,
    Version0
Order by
    DisplayName0,
    Version0

No comments:

Post a Comment

site backup job manually

Start a scheduled SCCM 2012 site backup job manually You might want to start a scheduled SCCM 2012 site backup job manually. off co...