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

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

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
Answered 06/13/2007 by: danr29
Purple Belt

Please log in to comment
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?
Answered 06/14/2007 by: brenthunter2005
Fifth Degree Brown Belt

Please log in to comment
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
Answered 06/14/2007 by: danr29
Purple Belt

Please log in to comment
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?
Answered 06/19/2007 by: brenthunter2005
Fifth Degree Brown Belt

Please log in to comment
Answer this question or Comment on this question for clarity