Does anyone know how to create a collection that is based on software metering rule to add alll machines that have used a metered program but have not used the program in the last 90 days? Is this possible?Were trying to find a method of removing unused metered software.Thanks

Yes it is possible, I have created a collection to do that as a test but never used it. If someone doesn't beat me to it I will see if I still have it and post it. I think I recall someone else posting it several months ago.http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

It has been a while since I visited these queries so confirm they work for you.Software last run more the X days ago----------------select distinct SMS_R_System.ResourceId, SMS_R_System.Name from SMS_R_System inner join SMS_G_System_SoftwareUsageData on SMS_G_System_SoftwareUsageData.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareUsageData.FileName = "sol.exe" and SMS_G_System_SoftwareUsageData.StartTimeLocal > DateAdd(dd,-6,GetDate())Software NOT run in x days-----------------select distinct SMS_R_System.ResourceId, SMS_R_System.Name from SMS_R_System where SMS_R_System.ResourceId not in (select distinct SMS_R_System.ResourceId from SMS_R_System inner join SMS_G_System_SoftwareUsageData on SMS_G_System_SoftwareUsageData.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareUsageData.FileName = "sol.exe" and SMS_G_System_SoftwareUsageData.StartTimeLocal > DateAdd(dd,-6,GetDate()))http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com