I just need to create the collection for Last 30 day Adobe.exe application not used machine data.. I have already enabled the metering rule.. But im not getting any out put..
I can ble to see the data from the default report.. But when i create the collection using below query ,not populating any data.. Any Help ? *http://www.myitforum.com/articles/1/view.asp?id=10909* To create a collection we need to base this on the SYS_R_System class. We also introduce a WHERE clause to limit by Operating System, to exclude servers: SELECT DISTINCT SMS_R_System.* FROM SMS_G_System_SoftwareFile INNER JOIN SMS_R_System ON SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID INNER JOIN SMS_MeteredFiles ON SMS_G_System_SoftwareFile.FileID = SMS_MeteredFiles.MeteredFileID WHERE SMS_MeteredFiles.RuleID = 6 AND DateDiff(day, SMS_G_System_SoftwareFile.ModifiedDate, GetDate()) > 30 AND SMS_R_System.OperatingSystemNameAndVersion LIKE '%Workstation%' AND SMS_G_System_SoftwareFile.ResourceID NOT IN ( SELECT DISTINCT SMS_MonthlyUsageSummary.ResourceID FROM SMS_MonthlyUsageSummary INNER JOIN SMS_MeteredFiles ON SMS_MonthlyUsageSummary.FileID = SMS_MeteredFile.MeteredFileID WHERE DateDiff(day, SMS_MonthlyUsageSummary.LastUsage, GetDate()) < 90 AND SMS_MeteredFiles.RuleID = 6 )
