Scripting

The WHERE clause is your filter - this is where you need to limit your results. I'm not familiar with the SCCM database, so I can't give you code.

Thanks Andy! I'll play with that....

I'm not entirely sure this is possible in a single SQL statement for a return result against multiple single column values (IE, computer names.) If you attempt to specify any number in the WHERE clause, you're going to only return results against all computers that have that number (E.G., if the minimum value of v_MonthlyUsageSummary.LastUsage is 6 days for any computer in your environment, then only computers with a value of 6 days will display.)

You might try digging through some SQL manuals and have a look at the available functions, and keep in mind that if you're going to use any aggregate clauses, you're going to have to use GROUP BY, and HAVING to keep the syntax correct. Try poking around here if you haven't already for ideas.

errrrm.....I don't use SCCM myself (so i don't know what v_MeteredProductRule.RuleID is....), but shouldn't the query look like this (note the second inner join)? Also, why are you ordering by the machine name?:
SELECT
v_R_System.Name0 AS MachineName,
DATEDIFF(day, v_MonthlyUsageSummary.LastUsage, GETDATE()) AS DaysSinceLastUsed,
v_MeteredProductRule.RuleID,
v_MeteredFiles.FileName
FROM v_R_System
INNER JOIN v_MonthlyUsageSummary ON v_R_System.ResourceID = v_MonthlyUsageSummary.ResourceID
INNER JOIN v_MeteredFiles ON v_MonthlyUsageSummary.FileID = v_MeteredFiles.MeteredFileID
INNER JOIN v_MeteredProductRule ON v_MeteredFiles.RuleID = v_MeteredProductRule.RuleID
WHERE (v_MeteredProductRule.RuleID = 173)
ORDER BY DaysSinceLastUsed


He's ordering by the machine name because .LastUsage returns multiple results for a given machine, this allows him to at least see each machine result in individual result blocks per machine name.