SCCM WQL Query

Robert Jenkins 0 Reputation points
2023-05-31T15:52:56.0233333+00:00

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.

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,142 questions
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,054 questions
0 comments No comments
{count} votes