Client Management Suite

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.
 

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'

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

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.

Thanks Vortex, your query will work nicely...

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

 

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.'