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

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
WHERE SF.FileName like '%EXCEL.EXE%'
ORDER BY MU.Domain, MU.UserName, SF.FileName
Posted Under

Bir Cevap Yazın

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