List of PCs with Excel (WQL)

select
    R.NetbiosName,
    R.LastLogonUserName,
    SP.ProductName,
    SP.ProductVersion
from 
    SMS_R_System R
    inner join SMS_G_System_SoftwareProduct SP on SP.ResourceID = R.ResourceId
    inner join SMS_G_System_SoftwareFile SF on SF.ResourceID = R.ResourceId and SP.ProductID = SF.ProductID
where
    SF.FileDescription like “%Excel%”
Order by
    R.NetbiosName,
    R.LastLogonUserName,
    SP.ProductName,
    SP.ProductVersion

Leave a Reply

Your email address will not be published. Required fields are marked *