Software Metering Test query

select 
  CS.Name0, 
  MRIB.ProductName,
  MD.* 
from
  dbo.v_GS_COMPUTER_SYSTEM CS
  join dbo.v_MeterData MD on CS.ResourceID = MD.ResourceID
  join dbo.v_MeterRuleInstallBase MRIB on MD.FileID = MRIB.MeteredFileID
where 
  MD.starttime > '2012-02-16'

Leave a Reply

Your email address will not be published. Required fields are marked *