SCCM WQL Query

Question

Good afternoon! So here is what I got going on. I am attempting to pull up a WQL query within MECM for Visio 2019, trying to see how I might be able to find out whom has access the program within the last 90 days. I am not making much progress, the only thing I believe I was able to find was if the Software was still running. Anyway, this is the query I got going so far.

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 inner join SMS_G_System_SoftwareUsageData on SMS_G_System_SoftwareUsageData.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "Visio.exe" and SMS_G_System_SoftwareUsageData.StillRunning = 1 and SMS_G_System_SoftwareFile.FileVersion like "16.%"

The only thing that I have change to this query has been and been SMS_G_System_SoftwareUsageData.StillRunning = 1. Any type of inputs or suggestions would be greatly appreciated.

Answer 1

You are welcome Robert and have a nice day.

Answer 2

No problem. Greatly appreciate pointing that out.

Answer 3

Good day Robert! I am glad to be able to provide assistance to you today. I would suggest to post this query to our neighbor forum from the link below as this is best suited in there. They are more oriented on with regards to this type queries/issues and there will be IT Pros/System Admins/Server Admins/AD Admins who are available that will be able to fulfill your query as we are more of home/personal consumer based forum.

https://learn.microsoft.com/en-us/answers/

Regards,

Paul R.