Force refresh Software Metering Reports

[CraigSCCM]

Hi guys, i'm currently going through a load of Licenses to remove MS Visio from users that don't need it anymore

 

So i ran a Software Metering Report for "Computers that have a metered program installed but have not run the program since a specified date"

 

Created an uninstall package and it removed ones from a specific date etc, that's fine.....

 

I have just ran a Query and a Report

 

Here's my Query:

 

select distinct SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.MACAddresses from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Visio Standard 2010" order by SMS_R_System.Name

 

This Query brings back 68 Results of people that have Visio Installed

 

I then ran this report

 

"Software - Companies & Products - Computers with a specific software registered in Add Remove Programs"

 

This report brings back 136 Results for people that Still have visio installed

 

Now i know full well i've removed it off about 50 people, but neither reports/queries are giving me correct information?

 

And they both are pointing to "Microsoft Visio Standard 2010" - so i'm really stumped as to what's going on?

 

How do i go about forcing a software refresh or cycle so it will give me the correct data?

 

Thanks

 

[GarthMJ]

You first query only finds x86 version of Visio. The report will find both x86 and x64.

 

Create a second WQL query to find x64 copies of Visio.

[CraigSCCM]

You first query only finds x86 version of Visio. The report will find both x86 and x64.

 

Create a second WQL query to find x64 copies of Visio.

 

Thank you mate, i've done it

 

I didn't realise you have to specify for x64

[CraigSCCM]

SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID

from

SMS_G_System_ADD_REMOVE_PROGRAMS_64

where

SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Microsoft Visio Standard 2010")

that's the part it had to add in