Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Office XP Query

1 view
Skip to first unread message

tkutil

unread,
Aug 6, 2009, 1:17:01 PM8/6/09
to
I am trying to create a query for Office XP installations and cannot get
anyting to work properly. I have searched on WinWord.exe and Excel.exe and
get everything but the kitchen sink and what I'm really looking for. Here is
my latest attempt at creating a query that searches for a file description of
Excel. I have tried file name and get the same result.

select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName,
SMS_G_System_SoftwareProduct.ProductName,
SMS_G_System_SoftwareProduct.ProductVersion from SMS_R_System inner join
SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID =
SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on
SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_SoftwareFile.FileDescription like "%Excel%"

0 new messages