SOLVED CM 2309 Software Metering Reports are empty for the new rule

[Moham_79]

I have software metering reports that are working for the old software metering rules, but for any new rule added recently the reports for them are empty.
I checked the rules and all are enabled, no errors in swmproc.log not sure where else to look to find the issue and resolve it.

your help is appreciated.

 

[Garth]

Has it been at least 20 days since the rules was created? Are you seeing the data collected on client?

 

[Moham_79]

Hi Garth,
it's been 10 days since we created the rules.
the data is collected from the clients, I am getting some data when I am running the SQL query for software included in the metering rules.
Thanks.

 

[Garth]

Hi Garth,
it's been 10 days since we created the rules.
the data is collected from the clients, I am getting some data when I am running the SQL query for software included in the metering rules.
Thanks.

So just to be clear, some of the SW metering views are not populated until 30+ days. unless you force it,.Even then there will be no useful data for 82 days.

What exactly does your SQL query look like?

 

[Moham_79]

So just to be clear, some of the SW metering views are not populated until 30+ days. unless you force it,.Even then there will be no useful data for 82 days.

What exactly does your SQL query look like?

This is the query I am running to get the list of machines that have a software installed :
select distinct Netbios_Name0 as Machine_Name, User_Name0 as User_Name, DisplayName0 as Product_Name, Version0 as Version_Number, Operating_System_Name_and0 Version0
from v_R_System vrs inner join v_Add_Remove_Programs varp on vrs.ResourceID = varp.ResourceID inner join v_FullCollectionMembership vfcm on vrs.ResourceID = vfcm.ResourceID
where (varp.DisplayName0 like '%autocad%') and (varp.Version0 like '%%') and vfcm.CollectionID = 'ACS0004E'

 

[Garth]

This is the query I am running to get the list of machines that have a software installed :
select distinct Netbios_Name0 as Machine_Name, User_Name0 as User_Name, DisplayName0 as Product_Name, Version0 as Version_Number, Operating_System_Name_and0 Version0
from v_R_System vrs inner join v_Add_Remove_Programs varp on vrs.ResourceID = varp.ResourceID inner join v_FullCollectionMembership vfcm on vrs.ResourceID = vfcm.ResourceID
where (varp.DisplayName0 like '%autocad%') and (varp.Version0 like '%%') and vfcm.CollectionID = 'ACS0004E'

That query has nothing to do with SW metering. That use Hardware Inventory only.

 

[Moham_79]

Guys, any idea where to check why I am still not getting any data in the software metering reports?
it is been more than 20 days since the software metering rule was created.
Thanks.

 

[Garth]

Guys, any idea where to check why I am still not getting any data in the software metering reports?
it is been more than 20 days since the software metering rule was created.
Thanks.

Exactly which report/query are you looking at? Can you see the metered data in ConfigMgr?

 

[Moham_79]

Exactly which report/query are you looking at? Can you see the metered data in ConfigMgr?

Hi Garth,
This is one of the reports I am trying to run , it seems the ConfigMgr does not have the metered data!!


Thanks.

 

[Moham_79]

Hi Garth,
This is one of the reports I am trying to run , it seems the ConfigMgr does not have the metered data!!
View attachment 5987

Thanks.

I checked also this SQL Query :
SELECT Distinct(mu.FullName), MAX(mus.LastUsage) as Lastusage,SUM(mus.TSUsageCount) as TSUsageCount
FROM
v_MonthlyUsageSummary MUS
INNER JOIN v_GS_SoftwareUsageData SUD ON(mus.ResourceID=sud.ResourceID)
INNER JOIN v_MeteredUser MU ON(mu.MeteredUserID=mus.MeteredUserID)
WHERE
sud.FileName='EXCEL.EXE'
AND TSUsageCount >0
AND MONTH(mus.LastUsage)=2
GROUP BY
mu.FullName;

it is returning with no records

 

[Garth]

I checked also this SQL Query :
SELECT Distinct(mu.FullName), MAX(mus.LastUsage) as Lastusage,SUM(mus.TSUsageCount) as TSUsageCount
FROM
v_MonthlyUsageSummary MUS
INNER JOIN v_GS_SoftwareUsageData SUD ON(mus.ResourceID=sud.ResourceID)
INNER JOIN v_MeteredUser MU ON(mu.MeteredUserID=mus.MeteredUserID)
WHERE
sud.FileName='EXCEL.EXE'
AND TSUsageCount >0
AND MONTH(mus.LastUsage)=2
GROUP BY
mu.FullName;

it is returning with no records

Go to the raw data. Do you have anything with this query.

Select * from v_GS_SoftwareUsageData

 

[Moham_79]

Go to the raw data. Do you have anything with this query.

Select * from v_GS_SoftwareUsageData

yes, I have but for all old software metering rules not for the new one which was created lately!

 

[Garth]

yes, I have but for all old software metering rules not for the new one which was created lately!

Have you validated that the rule is right? E.g. See within the logs that the rule is triggered when exe is run?

 

[Moham_79]

Have you validated that the rule is right? E.g. See within the logs that the rule is triggered when exe is run?

Hi Garth,

I found this in if my machine


while the rule has been created in the SCCM:

 

[Garth]

you can see from the logs that it didn't detect excel. Your screenshot does not show if the rule is enabled or not.

 

[Moham_79]

you can see from the logs that it didn't detect Excel. Your screenshot does not show if the rule is enabled or not.

All of the rules are enabled:

 

[Garth]

And does the rule apply to that site? Is the EXE English? Why don't you create the rule with any language and any version?

 

[Wesleya]

Hello,

i'm facing a similar issue...my v_MonthlyUsageSummary is empty.

how can I get data?

tks in advance.

 

[Garth]

Hello,

i'm facing a similar issue...my v_MonthlyUsageSummary is empty.

how can I get data?

tks in advance.

Do you have SWM rules, has it been more than 42 days since you created the rules? What troubleshooting have you done already?

 

[Wesleya]

Do you have SWM rules, has it been more than 42 days since you created the rules? What troubleshooting have you done already?

Hi Garth,

thank you for answer.
I'm just a beginner on this topic....I need to collect some data but perfoming a select * from v_MonthlyUsageSummary I could see that there are no data inside.

I dont know if I need to add some MOF(WMI) to collect this data....I'm trying to get some document/information about how to implement this as we buildt this env more or less 7 months and this is the first time that we need to provide a "custom" report.

also, I've tried to setup a mof with the syntax that i found here with no success

SMS_MonthlyUsageSummary Class - Configuration Manager

The SMS_MonthlyUsageSummary WMI class is an SMS Provider server class that represents a monthly usage summary for a particular file.

learn.microsoft.com

any help will be welcome