Help auditing for MS Visual Studio

Comments

8 comments

  • Greg Mills

    So this is what I've come up with so far. It looks a bit clunky to me, but seems to work. Is there a better way though? enter image description here

    0
    Comment actions Permalink
  • Greg Mills

    Resulting report.

    enter image description here

    0
    Comment actions Permalink
  • Greg Mills

    Hm, so I created a collection from this report, and whereas the report shows 27 machines with VS installed, the collection only shows 11. Why is that?

    0
    Comment actions Permalink
  • Christian Bacher

    Are you sure about 27 "machines" inside your report? For me it looks more like we are talking about 27 applications matching your filter on 11 maschines. You can have 2,3 or even 4 times a application match on one Device.

    Run the report again and add the computer name in the result to check this.

    0
    Comment actions Permalink
  • Greg Mills

    Hi Cristian,

    Here're the report results.

    enter image description here

    The collection, which has the same filters applied, shows just 11 machines.

    enter image description here

    0
    Comment actions Permalink
  • Chris James

    What appears to be happening is some of the Not Any filters are not being excluded once you add the Application Name column. If you remove the Application Name column the correct workstation names are displayed. However, I know seeing the matched application names are important and excluding that column is silly. Knowing that, this appears to be unintended behavior. We've already escalated the ticket you opened with us.

    0
    Comment actions Permalink
  • Bryan Mason

    Hi Greg, 

    I'm late to this post but hope I can help explain this if it's still a problem.

    The report shows different results than the collection because of the way it joins on the Application table. By definition, this Visual Studio Collection excludes any computer that matches the Not Any group even if has applications matching the Any group.

    By contrast, the report needs to join on the applications table to get the application name. The join will allow it to show multiple results for each computer. Matching applications will show, but excluded applications don't. The whole computer doesn’t get excluded if it has an excluded application.

    One way to fix the collection results is to move all the 2010 filters into the same group filter. This will include all variations of "VS 2010 Shell (...)" without your known exclusions.

    0
    Comment actions Permalink
  • Greg Mills

    Hi Bryan, thanks for taking the time to post. I had filed this in my 'try again later' tray, so your comment has reminded me to have another look. Thanks!

    0
    Comment actions Permalink

Please sign in to leave a comment.