Need to scan for systems with MS Powerpoint 2007 and MS Visio 2010

Comments

9 comments

  • Shane Corellian

    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.

    Inv-Report-Visio.png

    Here is the Filter

    Inv-Report-Visio-Filter.png

     

    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.

    0
    Comment actions Permalink
  • Jason Bashaw

    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?

    0
    Comment actions Permalink
  • Shane Corellian

    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. 

    0
    Comment actions Permalink
  • Jason Bashaw

    I'm on 1.0 (release 2). Thank you so much for your help.

    0
    Comment actions Permalink
  • Shane Corellian

    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.

    0
    Comment actions Permalink
  • Shane Corellian

    Will you open a computer (in PDQ Inventory) that you know has Powerpoint 2007. Look at the Applications panel. Do you see an entry for Microsoft Powerpoint anywhere? If so, what is the name? (Probably something like Microsoft Powerpoint 2007)

    0
    Comment actions Permalink
  • Jason Bashaw

    Microsoft Office PowerPoint 2007 

    0
    Comment actions Permalink
  • Shane Corellian

    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. 


    0
    Comment actions Permalink
  • Jason Bashaw

    Seems to be working well, I will repost with any tweaks I make to them.

    0
    Comment actions Permalink

Please sign in to leave a comment.