Systems Management

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

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?

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

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?