http://www.myitforum.com/articles/8/view.asp?id=10909
Showing as a Typo error after replacing the Rule ID as well
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
INNER JOIN SMS_MeteredProductRule
ON SMS_MeteredProductRule.RuleID = SMS_MeteredFiles.RuleID
WHERE SMS_MeteredFiles.RuleID = 6
AND DateDiff(day, SMS_G_System_SoftwareFile.ModifiedDate,
GetDate()) > 30
AND DateDiff(day, SMS_MeteredProductRule.LastUpdateTime,
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
)
