SCCM Graph - Software usage data source

[fbelghait]

Hi,

   We are using the OOTB data source 'SG-SCCM SAMP Usage' in SCCM Graph version 3.4.0, and noticed the two following issues with this data source:

   1- the data source import the  v_MonthlyUsageSummary view, the transform map of the data sourcec requires the

       user name and the file name as a mandatory field however these two fields are not returned by the view

   2- if we put a valid query that brings the two missing field, the transform map works, but the on_start script of the

       data source at the end of the execution replace the query with the OOTB one that is not returning the two

       required field

  3. in the On start script there is this comment '

      /*The final query responsible for extracting data from SCCM table is formed at Run-Time. Query below should not

          be considered as the final query that executes.*/\n\n''

      but the query was never built in the run time

Does any one know how we can make this data source work? 

Thanks

[omar_h · Accepted solution]

@fbelghait , in order for that data source to pull in any data, you'll need to make sure there are two things configured: 

1. Software metering should be turned on for that product within SCCM. 
2. You'll need a reclamation rule created and associated with that product. 

Once you've confirmed both of those things are configured for the software product you are looking to collect usage from, you can run the job and start seeing data populate in the Software usage table (samp_sw_usage). 

Hope that helps! 

Omar H.