Hi All, Hoping for some assistance with software metering. We have setup a test to query usage of VLC Player.
The first query shows us that there are around 130 installs out there. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceId = SMS_R_System.ResourceId WHERE SMS_G_System_SoftwareFile.FileName = "vlc.exe" The query for software metering shows us only 3 PC's when in fact we have had the vlc player running on a few different machines to test. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_SYSTEM inner join SMS_MonthlyUsageSummary on SMS_R_SYSTEM.ResourceID = SMS_MonthlyUsageSummary.ResourceID INNER JOIN SMS_MeteredFiles ON SMS_MonthlyUsageSummary.FileID = SMS_MeteredFile.MeteredFileID WHERE DateDiff(day, SMS_MonthlyUsageSummary.LastUsage, GetDate()) < 90 AND SMS_MeteredFiles.RuleID = 16777347 Anyone have any ideas why the difference in results? Chad Beard Infrastructure Support Officer - Adelaide Enterprise Services [cid:[email protected]] P. 0882305155 M. +61 434 076 370 E. [email protected]<mailto:[email protected]> Australian Rail Track Corporation 11 Sir Donald Bradman Drive Keswick Terminal SA 5035 artc.com.au<http://www.artc.com.au> The information in this email and any attachments to it is confidential to the intended recipient and may be privileged. Receipt by a person other than the intended recipient does not waive confidentiality or privilege. Unless you are the intended recipient, you are not authorised to disseminate, copy, retain or rely on the whole or any part of this communication. If you have received this communication in error please notify ARTC on +61 8 8217 4366. While we have taken various steps to alert us to the presence of computer viruses we do not guarantee that this communication is virus free.
