Sccm Application Filter Report Query

select distinct P.DisplayName0 as ProductName,

P.InstallDate0 as InstallDate,

S.Netbios_Name0 as ComputerName,

S.User_Name0 as LastUser,

S.Operating_System_Name_and0 as OperatingSystem,

S.Last_Logon_Timestamp0 as LastSeen

from [dbo].[v_Add_Remove_Programs] as P,

[dbo].[v_R_System] as S

where

S.ResourceID = P.ResourceID

and

(P.DisplayName0 like 'Microsoft Visual Studio %Premium%'

or P.DisplayName0 like 'Microsoft Visual Studio %Ultimate%'

or P.DisplayName0 like 'Microsoft Visual Studio %Professional%'

or P.DisplayName0 like 'Microsoft Visual Studio %Express%' )

and P.InstallDate0 is not null

order by S.Netbios_Name0
Posted Under

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir