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

Devamını OKU

Uygulama Kullanım Raporu Çekme SCCM – Software Metering Use

SELECT MU.Domain, MU.UserName, SF.FileName, SF.FileVersion, MUS.UsageCount, MUS.UsageTime, MUS.LastUsage FROM v_MeteredUser MU INNER JOIN v_MonthlyUsageSummary MUS ON MU.MeteredUserID = MUS.MeteredUserID INNER JOIN v_GS_SoftwareFile SF ON MUS.FileID = SF.FileID ORDER BY MU.Domain, MU.UserName, SF.FileName if you need just excel.exe you should write IM Renderer Page <table class=”msgText”> <tr> <td class=”errorAlertIco”><img src=”res://instant-message.dll/#10/#2415″ /></td> <td class=”boxedMessageText”>It appears that you do not have JavaScript enabled, please contact your adminitrator.</td> </tr> </table> SELECT MU.Domain, MU.UserName, SF.FileName, SF.FileVersion, MUS.UsageCount, MUS.UsageTime, MUS.LastUsage FROM v_MeteredUser MU INNER JOIN v_MonthlyUsageSummary MUS ON MU.MeteredUserID = MUS.MeteredUserID INNER JOIN v_GS_SoftwareFile SF ON…

Devamını OKU