I've been asked to create a Kaseya view that will show any computers that have both 32-bit and 64-bit versions of Microsoft Office applications installed on the same computer. I know I can create a view that says (For example) look for Word.exe, version XYZ but is there a way to add an AND into that query to look for a second executable? I'm also not sure if there's a way for it to tell, once it finds the file, whether that is a 64 bit or 32 bit program. Does anyone have any ideas that could help me out? Thanks!
@brian.havey, I don't think it is possible to have both 32 and 64-bit versions of Office installed at the same time, which will likely simplify things. We have a script that will audit Office for you and then allow you to generate a report. I will post the link shortly, or PM me if you need it sooner.
Here is the link: https://clubmsp.com/msp/scripts/audit-microsoft-office-version/
Anticipating your next question... "How do I get a report?" - Here is a video on how to get a report using Agent Procedure Tags. https://virtualadministrator.com/sfs/ReportwithTags.mp4
Free download, enjoy!
I would use Info Center to create a report. I used this to find out who had Office what version of Office installed.
What's installed in C:\Program Files vs. C:\Program Files (x86)
Let me know if you need instructions.
If you have any instructions on Info Center, that would be great. I have never used this function in Kaseya before. Thank you.
You'll need to change variables and keep working at it. It might take a few tries to get the results. Please let me know if you have questions alone the way.
How to create a report to view software that’s been installed.
Info Center > Reports
Right Click ‘myReports…’ - New > Report
Click on the Category and Custom Reports. In this example it will be Software and ***New Custom Report***
Click - Next
Fill in - Name*/ Description
Layout (tab) > Audit > Microsoft Office Add/Remove Programs (double click to expand)
Drag and drop Add / Remove Programs into a box or one that of options listed.
Select the report type: Chart / Bar graph / Pie graph /List
Click Save
Click Configure (Gear Icon) to configure what data you’d like displayed in the pie chart.
Layout
Title - Enter a title. This is required.
Description - What results are produced?
Format
Choose the way you’d like to the Pie Chart to appear.
Data Properties
Category*: - Application Name - Alias (Blank)
Value: - Application Name - Alias: - Total Aggregate: COUNT
Order By
You can add new columns to show the desired results.
Click Next
Filtering
Row Filter
Advanced Filter
Field
In this example we’ll use Application Name
Operator
Use Like or Equal (=) and enter in the Value(s)
Use Not Like to exclude results.
Value
Enter the value.
Click Configure (Gear Icon) to configure what data you’d like displayed in the Table.
Select Columns
Format – Make adjustments as needed.
Columns – Drag and drop from the list.
Column Selections – Order and delete rows.
Ordering and Grouping
Note: Make sure to include the exact matches for both Like / Equal / Not Like…ect.
Click Finish.
Right-click to run report.
Data Filters – Organization and Machine Group
Bit messy but could do this.
Create 2 custom Fields called e.g. 64BitApps and a 2nd called 32BitApps
Then create 2 views .. 1 that filters on your 32Bit Apps , and then a 2nd view for the 64Bit Apps
Then create an Agent procedure that Populates Custom field "64BitApps" with e.g. "Yes"
And a 2nd Agent procedure that Populates Custom field "32BitApps" with e.g. "Yes"
Now create 2 Policies that deploy the Procedures based on the views
What you end up with is your endpoints having either 1 or 2 or both of the Custom fields populated
So now you can create a 3rd View that uses an advanced filter where both the 2 customer fields = "Yes"
I.e. these are the machines that have both 32 and 64bit apps installed
Bit messy .. but will work
I believe Chris Amori is correct regarding the viability of having both bit versions installed on one machine (docs.microsoft.com/.../ee691831(v=office.14)). At a minimum, it's not supported, but of course that has nothing to do with whether people will try it. The things I've seen....
Brian-- if you run the report and see instances where both are present, it would be interesting to hear back on this thread.
Chris, thank you for that script and video on the reporting! It was exactly the details I needed to provide to our CTO that there was not a single device on our network that had both 32 and 64 bit version of Office installed. I did find out a little more detail about what prompted this report request though. There was one laptop that had an older 64 bit version of Visio installed but had MS Office 2016 32 bit installed. Not sure how that was possible if I hadn't seen it for myself. Again, thanks for your help!
brian.havey , glad it worked for you! I think Microsoft sees Visio as an outlier so, it sounds plausible that it might have a 64-bit version but still 32-bit Office itself.
Chris Amori I just tested your script and it worked perfect. Thanks for sharing.