Symantec Management Platform (Notification Server)

 View Only
  • 1.  SMP 7.1 Report by Organizational View

    Posted Dec 12, 2011 12:03 PM

    We are using SMP 7.1 and I have created some Organizational Views and added computers to those views.  I am need of a report that lists the computers in a particular view.

     

    Can anyone tell me an easy way to do that?



  • 2.  RE: SMP 7.1 Report by Organizational View

    Posted Feb 24, 2012 11:15 AM

    I am also looking for this info.   I'm a newbie to altiris and 7.1 and trying to figure out how to manage software packages during their lifecycle  (test, prod, retirement).    I ended up making organizational groups and making the packages members.

    I'd like to create a report which has package name,  member of organizational group, package guid and I am struggling to figure out how to report on the organizational group name.

    Any help would be great!!!



  • 3.  RE: SMP 7.1 Report by Organizational View
    Best Answer

    Posted Mar 05, 2012 07:51 AM

    I worked with support and got the following query

     

    declare @Resource AS nvarchar (25)
    set @Resource = 'ENTER ORGANIZATIONAL UNIT HERE'
    
    select 
            pf.Name as 'Organization group structure'
           ,i.Name as 'Organizational View'
           ,r.Name as 'Resource'
           ,sm.ResourceGuid as 'Guid'
    from ScopeMembership sm
    join vItem i on i.Guid = sm.ScopeCollectionGuid
    join vResourceEx r on r.Guid = sm.ResourceGuid
    join FolderBaseFolder f on f.FolderGuid = sm.ScopeCollectionGuid
          AND f.ParentFolderGuid NOT IN ('D0E33520-C160-11D2-8612-00104B74A9DF', 'FEC994AE-1787-44C2-B5EC-E94D210838C9', '42441BEE-BC0F-469C-8A66-06288CB1B8AF', 'D8C07867-F25B-41AF-9C6A-82C1086B2179')
    join Item pf on pf.Guid = f.ParentFolderGuid
    where pf.Name like '%' + @Resource + '%'
    Order by pf.name, i.name, r.Name, f.Depth


  • 4.  RE: SMP 7.1 Report by Organizational View

    Posted Mar 07, 2012 08:16 PM

    Awesome, many thanks!