Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
Software metering how

Answered Software metering how

  • Sunday, January 22, 2012 8:05 AM
     
     
    Sign In to Vote
    0

    We are metereing the usage of certain Software and ran a report on Which ones have not used on computers since Last 3 Months . The report gives inaccurate results. It shows the machines which do not even have the software installed. And also show s the machines that the software was installed on just 15 days ago.

    The Query of the report is :

    declare @TimeKey int

    set @TimeKey = 100*Year(@LastUsage)+Month(@LastUsage)

    select

    sys.Netbios_Name0, inst.SMS_Installed_Sites0

    from

    v_R_System

    sys

    left

    join v_RA_System_SMSInstalledSites inst on sys.ResourceID=inst.ResourceID

    where

    sys.ResourceID

    in

    (

     

    select ResourceID

     

    from v_MeterRuleInstallBase

     

    where ProductName=@ProductName     

    )

    and

    sys.ResourceID not

    in

    (

     

    select mus.ResourceID

     

    from v_MonthlyUsageSummary mus

     

    join v_MeteredFiles mf on mus.FileID=mf.MeteredFileID

     

    where mf.ProductName=@ProductName

     

    and mus.TimeKey>=@TimeKey

     

    and mus.LastUsage>=DATEADD(ss,@__timezoneoffset,@LastUsage)

    )

    and

    sys.Client_Version0 >=

    '2.5'

    order

    by sys.Netbios_Name0

     

     

     

     

    How can i validate the report is corect and only shows machines that have had the software installed for more than 3 months ...

     

All Replies

  • Sunday, January 22, 2012 8:52 AM
     
     
    Sign In to Vote
    1

    Go in the site maintenance under tasks and click on delete aged software metering data see if it is enabled and what is the schedule.

     

    Also go to the software metering client agent and see the settings there.

     

    Regards,

     

    Amim Muhammad Khan

    AMIM MUHAMMAD KHAN | CTTCNET USER GROUP LEAD | EVENT SPEAKER, MCT, MCTS, MCITP-ENTERPRISE, MCSA http://amimkhan.wordpress.com
     
  • Monday, January 23, 2012 2:34 AM
     
     
    Sign In to Vote
    0
    Have you added the specific executable to be metered?
    My Microsoft Core Infrastructure & Systems Management blog - blog.danovich.com.au
     
  • Monday, January 23, 2012 5:02 AM
     
     
    Sign In to Vote
    0
    Yes the exe is being metered. 
     
  • Monday, January 23, 2012 7:22 AM
     
     
    Sign In to Vote
    0
    try the default report with name  "Computers that have a metered program installed, but have not run the program since a specified date." report ID:120 .
    Please click on "vote as Helpful" if you feel this post helpful to you.

    Eswar Koneti | My Tech blog: eskonr.com | Linkedin: Eswar Koneti
     
  • Monday, January 23, 2012 8:45 AM
     
     
    Sign In to Vote
    0

    The Query posted is the same report. I am not sure why the report shows machines which dont even have the program installed ... 

    Suppose i run the report for last 3 months for application  "Microsoft Project"

    What i want to know is what that report actually shows:

    1.Will it show the machines that installed the product yesterday.

    2.Will it show the machine from which the product was removed 2 months ago.

    What should i check if i think that the report is not correct

     

     
  • Monday, January 23, 2012 11:24 PM
    Moderator
     
     Proposed
    Sign In to Vote
    0

    What does your Software Metering rule look like?

    http://www.enhansoft.com/
     
  • Monday, April 09, 2012 4:21 AM
     
     
    Sign In to Vote
    0

    It looks Like :

     
  • Monday, April 09, 2012 6:02 AM
     
     
    Sign In to Vote
    0

    This is what it looks like at my end except for the fact i have office 14, but why arent you using the default rules i think you have created this one manually. Use the default rule and enable those i think maybe the path to the file is incorrect....

    AMIM MUHAMMAD KHAN | CTTCNET USER GROUP LEAD | EVENT SPEAKER, MCT, MCTS, MCITP-ENTERPRISE, MCSA http://amimkhan.wordpress.com


     
  • Monday, April 09, 2012 11:46 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Your rule looks good. Why do you think it is giving you wrong results? Have you confirmed that your clients are reporting data back correctly?

    BTW there are no default rules, there are auto-created rules but it is no enabled by default and I don’t recommend enabled it either.

    http://www.enhansoft.com/

     
  • Sunday, April 22, 2012 6:10 AM
     
     
    Sign In to Vote
    0
    Yes teh clients are reporting the data , I dont know correctly or not , the reports show data which is not correct , that is the main issue we have
     
  • Sunday, April 22, 2012 4:35 PM
    Moderator
     
     
    Sign In to Vote
    0
    Why do you think that the rule is not showing the data correctly?

    http://www.enhansoft.com/