Sign in
Microsoft.com
 
System Center Configuration Manager TechCenter
 
 
 
System Center Configuration Manager TechCenter > System Center Configuration Manager Forums > Configuration Manager Inventory > Custom Report to show Boundary Description
Ask a questionAsk a question
Search Forums:
 

AnswerCustom Report to show Boundary Description

  • Monday, October 19, 2009 10:46 AMsveske Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi

    I have made the following report which shows "Netbios Names" and "user names" in a specific AD-site (Boundary).
    But is it possible to also show the "Despription" of the Boundaries (the decription filled in when I create a new Boundary), f.ex. "Building 0" or "Country".

    SELECT     TOP (100) PERCENT sys.Netbios_Name0 AS [Netbios Name], sys.User_Name0 AS [User Name], sys.AD_Site_Name0 AS [AD Site],
                          dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System], dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0,
                          sys.Resource_Domain_OR_Workgr0 AS Domain
    FROM         dbo.v_R_System AS sys INNER JOIN
                          dbo.v_AgentDiscoveries AS agent ON sys.ResourceID = agent.ResourceId INNER JOIN
                          dbo.v_GS_OPERATING_SYSTEM ON sys.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
    WHERE     (sys.AD_Site_Name0 = @adsite)
    GROUP BY sys.Netbios_Name0, sys.Resource_Domain_OR_Workgr0, sys.AD_Site_Name0, sys.User_Name0, dbo.v_GS_OPERATING_SYSTEM.Caption0,
                          dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0
    ORDER BY [Netbios Name]



    I found a table in the Database called "Boundary" but could'nt get it to work, when I try to implement in the report above.

    Regards

    I
     

Answers

  • Monday, October 19, 2009 1:46 PMSherry KissingerMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    This will only work right because your boundaries are based on ad site names.  If you are using ip address ranges for boundaries, it won't display those.

    SELECT     TOP (100) PERCENT sys.Netbios_Name0 AS [Netbios Name], sys.User_Name0 AS [User Name], sys.AD_Site_Name0 AS [AD Site],
                          bound.displayname,
                          dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System], dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0,
                          sys.Resource_Domain_OR_Workgr0 AS Domain
    FROM         dbo.v_R_System AS sys INNER JOIN
                          dbo.v_AgentDiscoveries AS agent ON sys.ResourceID = agent.ResourceId INNER JOIN
                          dbo.v_GS_OPERATING_SYSTEM ON sys.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
    left join  v_boundaryInfo Bound on sys.ad_site_name0=bound.value
    WHERE     (sys.AD_Site_Name0 = @adsite)
    GROUP BY sys.Netbios_Name0, sys.Resource_Domain_OR_Workgr0, sys.AD_Site_Name0, sys.User_Name0, dbo.v_GS_OPERATING_SYSTEM.Caption0,
                          dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, bound.displayname
    ORDER BY [Netbios Name]
    Standardize. Simplify. Automate.
    • Marked As Answer bysveske Tuesday, October 20, 2009 8:40 AM
    •  
     

All Replies

  • Monday, October 19, 2009 1:46 PMSherry KissingerMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    This will only work right because your boundaries are based on ad site names.  If you are using ip address ranges for boundaries, it won't display those.

    SELECT     TOP (100) PERCENT sys.Netbios_Name0 AS [Netbios Name], sys.User_Name0 AS [User Name], sys.AD_Site_Name0 AS [AD Site],
                          bound.displayname,
                          dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System], dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0,
                          sys.Resource_Domain_OR_Workgr0 AS Domain
    FROM         dbo.v_R_System AS sys INNER JOIN
                          dbo.v_AgentDiscoveries AS agent ON sys.ResourceID = agent.ResourceId INNER JOIN
                          dbo.v_GS_OPERATING_SYSTEM ON sys.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
    left join  v_boundaryInfo Bound on sys.ad_site_name0=bound.value
    WHERE     (sys.AD_Site_Name0 = @adsite)
    GROUP BY sys.Netbios_Name0, sys.Resource_Domain_OR_Workgr0, sys.AD_Site_Name0, sys.User_Name0, dbo.v_GS_OPERATING_SYSTEM.Caption0,
                          dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, bound.displayname
    ORDER BY [Netbios Name]
    Standardize. Simplify. Automate.
    • Marked As Answer bysveske Tuesday, October 20, 2009 8:40 AM
    •  
     
  • Tuesday, October 20, 2009 8:42 AMsveske Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Thanks a lot,

    This works perfect.

    Haven't figured out to use: sys.ad_site_name0=bound.value

    And thanks regarding info on IP-address range.

    Regards