Video Screencast Help

Export/Copy a list of comptuers form a filter in NS7

Created: 25 Jun 2010 • Updated: 30 Jul 2010 | 5 comments
mickwearn's picture
This issue has been solved. See solution.

Hi Folks, in NS6 I really like being able to copy, or export a list of the computers that were in a collection, this data was very useful to us and allowed us to manipulate it in MS Excel.

In NS7 I'm un able to find how to do this, Is there a way to copy or export a list of computers from a filter?

Thanks heaps for any advice or suggestions.

Mick.
 

Comments 5 CommentsJump to latest comment

vortex0007's picture

In the SMP7 database, filters are still named collections. You might want to check my joins on this one, but if you know the name of the filter you want to use, run this sql query and then you can copy the list out. It's not as simple at the 6.x days, but at least it gets the data out for you.
In my example below, I'm using the filter 'All Windows Computers' which you would substitute for the filter of your choosing.

SELECT vComputer.Guid, vComputer.Name, vCollection.Name AS Expr1, CollectionMembership.ResourceGuid,

vCollection.Description

FROM CollectionMembership INNER JOIN

vComputer ON CollectionMembership.ResourceGuid = vComputer.Guid INNER JOIN

vCollection INNER JOIN

Collection ON vCollection.Guid = Collection.Guid ON CollectionMembership.CollectionGuid = Collection.Guid

where vCollection.Name = 'All Windows Computers'

SOLUTION
Shobud's picture

What's up with that anyway? I've resorted to raw SQL, but why remove such useful functionality?
I'm sure the new 'good looking but incredibly slow for scrolling' data grid would support that functionality!

I swear the UI has taken a few steps backwords in places on version 7.

Dan

mclemson's picture

I agree that it would be nice.  Why not submit a feature request to Symantec support, or start an idea thread here on Connect?  They could add a report to the default report pack that generates a report on membership of a filter (select the filter from a drop-down) or lets you export to spreadsheet straight from Manage > Filter.  It wouldn't be too hard.

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

mickwearn's picture

Thanks Vortex, your query will work nicely...

I’ve never started an idea thread, before.. how do I do that?

 

mclemson's picture

There's a tab on Connect for Ideas, just like there's a tab at the top for Forums.  Then click 'Start a new idea' just like you would 'Start a new discussion.'

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com