Symantec Management Platform (Notification Server)

 View Only
  • 1.  SQL gurus: How do I find target membership?

    Posted Nov 10, 2011 10:40 AM

    I'm trying to get some of my reports to be more accurate. Currently I join some tables and am able to pull up the members of a filter. I would like to instead pull the members of the target. Here is an example of the filter type of joins:

    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'

     

    Does anyone have a snippet of SQL of how they are able to pull target membership, instead of filter membership?



  • 2.  RE: SQL gurus: How do I find target membership?

    Posted Nov 10, 2011 05:13 PM

    A target is scoped by security, depending on who is applying it.  So the membership is going to change.  For example, an administrator might see 8400 computers while a limited role for a region might see 1200.

    What are you trying to improve in your reporting, out of curiosity?  Any new report starts with scoping as part of the definition, so it would scope the filters you included just the same as if you pulled just the filters.  Of course, if you used computer lists or organizational groups, there's that to consider.

    Stored procedures are going to be what populate targets, and I'm not sure which one at the moment.  In the meanwhile, if you have more details, it should get us further along.