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
Subscribe to:
Post Comments (Atom)
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...
-
Application app enforcement deployment status with installation errors select distinct vrs.user_name0,fn.machinename,fn.applicationnam...
-
select SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS...
-
select Name0, netbios_name0,user_name0,ProdID0 ,Displayname0, installdate0,publisher0,version0 from v_r_system inner join v_Add_Remove_Prog...
No comments:
Post a Comment