Guys,
I am trying to run a query that displays systems with which version of Office and IE.
I have tried querying for just the Office version so far.
SMS_G_System_SoftwareProduct.ProductName like "Microsoft Office %"
However, when I run the query certain systems will display a number of Microsoft Office entries. It seems that systems may have a number of results for Microsoft Office XP let's say. And some systems will have both Microsoft Office XP and Microsoft Office 2000.
Is my query correct? If so, how do I limit it to the one correct entry for each system.
Also, how can I get the same query to display the version of IE? I am not sure how to do this since my query is already based on my Microsoft Office criterium.
Thanks,
Paranoid
I am trying to run a query that displays systems with which version of Office and IE.
I have tried querying for just the Office version so far.
SMS_G_System_SoftwareProduct.ProductName like "Microsoft Office %"
However, when I run the query certain systems will display a number of Microsoft Office entries. It seems that systems may have a number of results for Microsoft Office XP let's say. And some systems will have both Microsoft Office XP and Microsoft Office 2000.
Is my query correct? If so, how do I limit it to the one correct entry for each system.
Also, how can I get the same query to display the version of IE? I am not sure how to do this since my query is already based on my Microsoft Office criterium.
Thanks,
Paranoid