Anyone have a quick Analyses to get the version of Office 365?
Appreciate any help!
Thanks.
Sno
Here is a client relevance expression that can be used in an analysis to identify the version of Office 365 if it is installed on a Windows client device:
if exists keys "HKLM\Software\Microsoft\Office\ClickToRun\Configuration"
then (values of key “HKLM\Software\Microsoft\Office\ClickToRun\Configuration” whose (name of it = “ProductVersion”)) as string
else “Office 365 not found”
This expression uses the if exists keys operator to check if the key HKLM\Software\Microsoft\Office\ClickToRun\Configuration exists in the registry. If the key exists, it retrieves the value of the ProductVersion property using the values of key operator. If the key does not exist, the expression returns the string “Office 365 not found”.
The expression is designed to work with the Windows registry and may need to be modified if you are running a different operating system. Additionally, you may need to modify the expression to retrieve the version of a different Office product or a different release of Office 365.
2 Likes
There are some analysis that are HCL content provided…
Each of those have properties about office that you can include as a view in other content… Such as, I have a computer group that shows all systems that have office installed, then I add a column header (property) from the properties of these active analysis listed above, or any property available to you in the console.
In the screenshot below, I have a computer group and I have added the Office 365 Office 2016 Version from the (Application information for office 365 - 2016 analysis) (notice the text in the parenthesis are names of the analysis the property is from) and the "Microsoft Office Configuration Information" (Microsoft Office Configuration Information)
It is best to use the properties you already have instead of properties pulling the same data for different analysis.
4 Likes
thanks a million! appreciate the help.
thanks so much for the help!