/build/static/layout/Breadcrumb_cap_w.png

Collection based on Software Metering Rule?

Hello all,

Does anyone know how to create a SMS collection that is based on software metering rules, such as when an application was last used etc?

Please note, this needs to be in the form of a SMS collection (and query), and not just a SMS Report.

0 Comments   [ + ] Show comments

Answers (4)

Posted by: danr29 13 years ago
Purple Belt
0
Brent;

I've used this WQL statement before to view the application name (acrobat reader), end local time (which I think is the last time the application was used), and the netbios name of the system where the application was used;

select SMS_R_System.NetbiosName, SMS_G_System_SoftwareUsageData.FileName, SMS_G_System_SoftwareUsageData.EndTimeLocal from SMS_R_System inner join SMS_G_System_SoftwareUsageData on SMS_G_System_SoftwareUsageData.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareUsageData.FileName = "AcroRd32.exe" order by SMS_R_System.NetbiosName, SMS_G_System_SoftwareUsageData.FileName, SMS_G_System_SoftwareUsageData.EndTimeLocal

This probably isn't exactly what you're looking for just thought you may be able to get an idea from this.

-Dan
Posted by: brenthunter2005 13 years ago
Fifth Degree Brown Belt
0
Yes, good query, but unfortunately I find that the field SMS_G_System_SoftwareUsageData.EndTimeLoca is not populated in most instances.

Is this a problem with my configuration? I don't think so. Software Metering has been enabled since the beginning of the year. Also, the rule was created mid February as well. Any suggestions?
Posted by: danr29 13 years ago
Purple Belt
0
Is it just not populated at all for certain applications? Or are you querying for a specific application and the end local time for certain records comes up null? Either way Im thinking it's showing null because either the application in question hasn't been used at all or certain systems (or users - depends what you're basing the query against) havn't used the application.

-Dan
Posted by: brenthunter2005 13 years ago
Fifth Degree Brown Belt
0
Hello Dan,

I querying a specific metering rule for all computers that have run the executable since a specific time. I know the application has been used by about ~300 users/computers since February by manually checking some of the computers and also by using the SMS reports for software metering.

Yet, when I use the "End Local Time" I'm only able to return one record, ie: one computer.

What I've done as a "workaround" (and I prefer solutions to workarounds), is to create a VBScript (scheduled for every morning) that executes the neccessary SQL query (ie: sms report) and then uses the returned recordset to create a query based rule on the specific collection. This is working well, but obviously I'd like to keep it all within SMS itself.

I just can't believe that I can't query the neccessary information using a native SMS/WQL query statement. Is it true that not all SMS SQL Database fields are represented as SMS classes?
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ