Need to scan for systems with MS Powerpoint 2007 and MS Visio 2010
I'm having trouble scanning for installations of Powerpoint 2007 and Visio 2010. I need these counts for a license audit, and I am not sure how to start looking.
-
Hi Jason,
The Visio report is an easy get. You can just create a new report by going to the Report menu and selecting New Report / Basic.
See the two screenshots for the columns and filters that I used.
Here is the Filter
Now as for Powerpoint... Did you mean to say Microsoft Project? Just curious. Powerpoint is installed with Microsoft Office, by default, so the application names will probably say Microsoft Office. If you aren't seeing Powerpoint then a good way to look for PowerPoint is to scan for Files and specifically look for the PowerPoint executable. File scan require that you run Inventory in Pro mode.
By the way, the reason I used the filter Matches Expression (as opposed to the easier Contains) is because I wanted to exclude systems that had Visio viewer from being reported.
-
PowerPoint 2007 was sold individually as was PowerPoint 2003 as basic versions of MS Office did not include them.
What I am trying to do is subdivide my collections. For example the canned collection, 'Systems with Microsoft Office 2007' contains everything Office 2007. From there I need to break that into 'Systems with Microsoft Office Basic 2007', 'Systems with Microsoft Office Professional 2007', 'Systems with Microsoft Office Small Business 2007, 'Systems with Microsoft PowerPoint 2007', and 'Systems with Microsoft Visio 2007' because the licensing is different for each item.
I did not see the 'matches expression' option included in the filters for the collections, so your suggestion for Visio is not an option. What would be uber helpful in this process is a way for me to see what items from each machine are included in the collection query. Maybe a column that I can add to the results field that tells me A, B and C are why this machine came back in this query.
Also are we able to connect externally to the database? If so what is the procedure?
-
You can use Matches Regex (which is the Collection equivalent to the Reports term, Matches Expression. The Regex term is being changed to Expression in the next release. Sorry for the confusion.). Are you using PDQ Inventory 1.0.2? If so, I will build some Collections that you can import. If Powerpoint was installed separately then it should show up in the installed applications.
I will attach some Collection files in a bit.
-
Oh, really quick... Regarding the ability see what items are included in the Collection (such as the application name). This feature is addressed with Reports. The collections are only meant to group machines, largely as targets for administrative tasks. A Collection to show systems with Visio 2007 might be created so that you can target these systems for an upgrade to Visio 2010.
If you want to view the Computers with their respective Visio (or Powerpoint) versions then you would want to use a report.
-
Import the attached XML file into your Systems with Microsoft Office collection. (you can select the Collection and then hit CTRL+i or right click and select Import). This will create another collection called Systems with Microsoft Office 2007 collection. It will have some child (or sub) collections. I included the common implementations of Office 2007. Some of the filters are different so this is a good opportunity for you to peruse the filters.
Note that all the child collections EXCEPT "Powerpoint 2007" have the "Drill down from parent collection" checked. That means that only computers that are in the parent collection are going to have the filter applied. I unchecked this with Powerpoint since it is possible that a computer with Powerpoint won't have Office installed.
If you'd like help with creating a report let us know and we'll help you out.
Please sign in to leave a comment.
Comments
9 comments