I am having an issue with creating a custom report and collection based on software metering for firefox. since firefox doesnt auto update unless its being used we are looking to remove firefox from systems if its not used. so i am tring to remove it from systems that havent used it in more then say 200 days to start. when i run the sql query it gives me different results for the collection i am running it against depending on the days i pick.
inner join v_MonthlyUsageSummary MUS on RV.ResourceID = MUS.ResourceID
inner join v_MeteredFiles MF ON MUS.FileID = MF.MeteredFileID
JOIN v_FullCollectionMembership ON rv.ResourceID = v_FullCollectionMembership.ResourceID
left outer join dbo.v_GS_OPERATING_SYSTEM OS on RV.ResourceID = OS.ResourceID
MF.RuleID = 16777418 and rv.Netbios_Name0 = ‘xxxx’
Group by RV.Netbios_Name0, RV.User_Name0, RV.Resource_Domain_OR_Workgr0, OS.Caption0, MUS.LastUsage
as you see i get multiple dates. what would be the best way to truly get the systems that havent used software in more then x amount of days.