Client Management Suite

Hi,

Is there a way to take one of the Application Metering reports and modify it so it runs against a specific collection?

The report View - Solutions - Application Metering - Reports - Application Usage - Application Usage by Computer

I've created a specific collection based on old hardware, and would like to run the report above against this collection.

regards Steve

yabru,
It is not too difficult to do.  Basically in the JOINs section of the report, you add a JOIN for CollectionMembership table:

JOIN CollectionMembership cm
ON d._ResourceGuid = cm.ResourceGuid
AND cm.CollectionGuid = '%_Collection%'

Then, in the report configuration you create a new "Item Picker"-type of parameter with a filter type of Collectionsm with a name of _Collection.  See this thread for lots of good info on customizing reports.

No luck here....

Hi, i've tried this a number of ways, and all i've achieved is the knowledge that i really need to start understanding this sql language.

Any chance someone can elaborate on K Schroeder's  comment above.

Or even better, the report i'm trying to modify is as follows (trying to apply it to a collection rather than %computer%

View - Application Metering - Reports - Application Usage - Application Usage by Computer

Thanks Steve

Try this:

SELECT Manufacturer, [Product Name], amms.[Product Version] AS [Version],
acid.Name AS [Computer Name], acid.Domain AS [Computer Domain],
SUM([Run Count]) AS [# of Uses], MAX(amms.[Last Start]) AS [Last Start] , acid._ResourceGuid
FROM Inv_AeX_AM_Monthly_Summary amms
JOIN Inv_AeX_AC_Identification acid
ON amms._ResourceGuid = acid._ResourceGuid
JOIN CollectionMembership cm
ON acid._resourceGuid = cm.ResourceGuid
AND cm.CollectionGuid = '%_Collection%'
WHERE amms.[Product Name] LIKE '%' + '%_AppName%' + '%'
GROUP BY Manufacturer, [Product Name], acid.Name, acid.Domain,
amms.[Product Version], acid._ResourceGuid
ORDER BY [# of Uses] DESC, [Name] ASC

You will need to create a new parameter named _Collection which has a Parameter Type of "Item Picker" and a class filter of "Collections", and another called "_AppName" which is a Basic parameter, with a "String" type.