Originally I think it was set to something like 7 days but last week we set it to every 6 hours.
I'm pretty sure out of the 130 machine out there with it installed they have had it for a few months already. Basically what we are trying to achieve is if someone hasn't used the software in 6 months then it will auto uninstall but at this stage we can't trust what the queries are giving us. From: [email protected] [mailto:[email protected]] On Behalf Of Garth Jones Sent: Tuesday, 30 June 2015 9:47 PM To: [email protected] Subject: [mssms] RE: Software Metering Query The rule looks right. How often are you collecting SWM data? Did you know that you WQL query that you have listed below is a Monthly summary of the data? How long have you test computers been running VLC? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Chad Beard Sent: Monday, June 29, 2015 8:12 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Software Metering Query This is how the rule was created [cid:[email protected]] Is there an SQL query I can run directly against the database to show the exact usage compared to the failing WQL query I have below? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Garth Jones Sent: Monday, 29 June 2015 9:32 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Software Metering Query It is mostly that there is a problem with your SWM rule. How exactly did you create your SWM rule? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Chad Beard Sent: Monday, June 29, 2015 2:54 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Software Metering Query 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.
