WQL Query for VISIO and Projects installed machine report

select SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS_G_System_INSTALLED_SOFTWARE.InstallDate, SMS_G_System_INSTALLED_SOFTWARE.TimeStamp, SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName from  SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "%Visio Standard%" or SMS_G_System_INSTALLED_SOFTWARE.ProductName like "%Visio Professional%" or SMS_G_System_INSTALLED_SOFTWARE.ProductName like "%Visio Premium%" or SMS_G_System_INSTALLED_SOFTWARE.ProductName like "%Office Visio%" order by SMS_R_System.Name




---------------------------------------------------

' Projects '

------------------------------------------------------------

select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS_G_System_ADD_REMOVE_PROGRAMS.InstallDate, SMS_G_System_ADD_REMOVE_PROGRAMS.TimeStamp from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Project Standard%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Project Professional%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office Project%" order by SMS_R_System.Name