How does Snow determine the workstations which have individually subcomponent of Office not the part of Suite?

Discussion created by McCormick on Nov 17, 2017
Latest reply on Nov 17, 2017 by mark.potts

Like • Show 0 Likes0
Comment • 9

I have to create a report of all the computers/servers which have subcomponent of Microsoft Office installed which are not the part of Suite. Let's understand thru an example:

I need to get the workstations/ servers details where:

1- Microsoft Office 2007 Professional suite installed

2- Individual subcomponent of Office 2007 Professional installed let's say Excel 2007 Professional.

So when I search computers which have application name "Excel 2007 Professional " installed, result returns me the list of computers which have Office 2007 Professional suite as well + Excel 2007 Professional, which is kind of duplicate data.

There are other ways where I can play with Excel and get the result but I am looking for any custom report / query. any help would be appreciated.

Thank you.

Outcomes

mark.potts

Nov 17, 2017 5:00 AM

Hi Saurabh,

If I understand your question correctly, this is standard out of the box functionality, so you should not need a custom report for this one. If a product is part of a bundle (e.g. office suite) then Snow sets the "Part of bundle" flag to yes, so by using the standard Applications per Computer report, and setting the criteria to only show software where "part of bundle" = no, then it will exclude the products that Snow have identified as part of the office suite.

Mark.

Actions

McCormick @ mark.potts on Nov 17, 2017 5:23 AM

Hi Mark,

Thanks for replying.I tried this before but if select criteria "Part of bundle" = No, then computer list displaying is subset of result of report "Part of bundle"= Yes

Regards,

Saurabh

Actions

mark.potts

@ McCormick on Nov 17, 2017 5:30 AM

Hello again, I am not sure I understand the issue.

If you want to include those that are both in and not in a bundle, then just don't use the "part of bundle" in the criteria, but add it into your report using the column selector, click on Column Selector (Top right of your report) find "Part of Bundle" in the list, and drag it into your report, you can then see both those in and not in a bundle. Does that help?

Actions

McCormick @ mark.potts on Nov 17, 2017 6:14 AM

Hi Mark,

So here when I ran this report I am getting below result.

So above report says "Microsoft Office 2013 Access" installed on a computer name " PC0JZUW6" as a part of bundle and not the part of bundle (since check box unchecked)

So question was how come it's possible to have one application installed on the same computer as a bundle and as not part of bundle. It should be either part of bundle or not part of bundle.

Regards,

Saurabh

Actions

mark.potts

@ McCormick on Nov 17, 2017 7:12 AM

Hi,

Are you able to include a screenshot showing your report options and some example of the data? because it is not like that on my estate.

Thanks

Mark.

Actions

McCormick @ mark.potts on Nov 17, 2017 7:19 AM

Oh it's beard, screen shot is showing on my estate: Below is the screen shot I am referring to:

Regards,

Saurabh

Actions

mark.potts

@ McCormick on Nov 17, 2017 7:29 AM

Sorry, still no screen shot , you can email it to me if you like, address is on my profile.

Actions

McCormick @ mark.potts on Nov 17, 2017 7:30 AM

Oh it's beard, screen shot is showing on my estate: Below is the screen shot I am referring to:

Regards,

Saurabh

Actions

mark.potts

@ McCormick on Nov 17, 2017 7:46 AM

OK got it that time thanks, it sure is a strange one, I can see from the usage information that these are two distinct records otherwise the usage data would be the same. I think you will need to log this with Support to get them to look at your data.

The only scenario(s) that make sense in my head are

1) The application has recently been replaced with the office bundle version, but the recent usage history of the standalone version is still included in the report

2) They have different versions installed e.g. the runtime and the full product?

It may be worth just looking at the inventory data for that one computer to see what the full product details are for Access. If you want to post another screenshot of the computer record showing installed software with the different versions of Access I can try to assist further?

Mark.

Actions

9 Replies

mark.potts Nov 17, 2017 5:00 AM
Hi Saurabh,

If I understand your question correctly, this is standard out of the box functionality, so you should not need a custom report for this one. If a product is part of a bundle (e.g. office suite) then Snow sets the "Part of bundle" flag to yes, so by using the standard Applications per Computer report, and setting the criteria to only show software where "part of bundle" = no, then it will exclude the products that Snow have identified as part of the office suite.

Mark.
Like • Show 0 Likes0
Actions
- McCormick @ mark.potts on Nov 17, 2017 5:23 AM
  Hi Mark,
  
  Thanks for replying.I tried this before but if select criteria "Part of bundle" = No, then computer list displaying is subset of result of report "Part of bundle"= Yes
  
  Regards,
  Saurabh
  Like • Show 0 Likes0
  Actions
  - mark.potts @ McCormick on Nov 17, 2017 5:30 AM
    Hello again, I am not sure I understand the issue.
    
    If you want to include those that are both in and not in a bundle, then just don't use the "part of bundle" in the criteria, but add it into your report using the column selector, click on Column Selector (Top right of your report) find "Part of Bundle" in the list, and drag it into your report, you can then see both those in and not in a bundle. Does that help?
    Like • Show 0 Likes0
    Actions
    - McCormick @ mark.potts on Nov 17, 2017 6:14 AM
      Hi Mark,
      So here when I ran this report I am getting below result.
      
      So above report says "Microsoft Office 2013 Access" installed on a computer name " PC0JZUW6" as a part of bundle and not the part of bundle (since check box unchecked)
      
      So question was how come it's possible to have one application installed on the same computer as a bundle and as not part of bundle. It should be either part of bundle or not part of bundle.
      
      Regards,
      Saurabh
      Like • Show 0 Likes0
      Actions
      - mark.potts @ McCormick on Nov 17, 2017 7:12 AM
        Hi,
        
        Are you able to include a screenshot showing your report options and some example of the data? because it is not like that on my estate.
        
        Thanks
        Mark.
        Like • Show 0 Likes0
        Actions
        McCormick @ mark.potts on Nov 17, 2017 7:19 AM
        Oh it's beard, screen shot is showing on my estate: Below is the screen shot I am referring to:
        
        Regards,
        Saurabh
        Like • Show 0 Likes0
        Actions
        mark.potts @ McCormick on Nov 17, 2017 7:29 AM
        Sorry, still no screen shot , you can email it to me if you like, address is on my profile.
        Like • Show 0 Likes0
        Actions
        McCormick @ mark.potts on Nov 17, 2017 7:30 AM
        Oh it's beard, screen shot is showing on my estate: Below is the screen shot I am referring to:
        
        Regards,
        Saurabh
        Like • Show 0 Likes0
        Actions
        mark.potts @ McCormick on Nov 17, 2017 7:46 AM
        OK got it that time thanks, it sure is a strange one, I can see from the usage information that these are two distinct records otherwise the usage data would be the same. I think you will need to log this with Support to get them to look at your data.
        
        The only scenario(s) that make sense in my head are
        1) The application has recently been replaced with the office bundle version, but the recent usage history of the standalone version is still included in the report
        2) They have different versions installed e.g. the runtime and the full product?
        
        It may be worth just looking at the inventory data for that one computer to see what the full product details are for Access. If you want to post another screenshot of the computer record showing installed software with the different versions of Access I can try to assist further?
        
        Mark.
        Like • Show 0 Likes0
        Actions

How does Snow determine the workstations which have individually subcomponent of Office not the part of Suite?

Outcomes

Related Content

Recommended Content