3 Replies Latest reply on Oct 16, 2015 4:30 AM by juniordev

    Custom SQL Error (Report Writer) on Account Limitation

    juniordev

      Hi,

      I have a problem about showing custom sql report created report writer. There is Nodes.Department limitation on account. That below sql query correctly runs at SSMS/Database Manager and Report Writer. But if I save this report on Report Writer and check this report via limited account, I get an error like 'The multi-part identifier "Nodes.Department" coul not be bound.'.

       

      Can you help me about that problem?

      Edit: The version is NPM 11.5.2

       

      WITH tbl (NodeID)
      AS (
        SELECT nodelist.NodeID FROM (
        SELECT InterfaceID, NodeID FROM interfaces WITH (NOLOCK) WHERE InterfaceName LIKE '%GigabitEthernet0/1.%'
         UNION
         SELECT InterfaceID, NodeID   FROM interfaces WITH (NOLOCK) WHERE InterfaceName LIKE '%GigabitEthernet0/1%'
        AND NodeID NOT IN (   SELECT NodeID  FROM interfaces WITH (NOLOCK)   WHERE InterfaceName LIKE '%GigabitEthernet0/1.%'  )) intf , 
      (  SELECT NodeID FROM nodes WITH (NOLOCK) WHERE Nodes.Device_Type = 'MPLS_Router'   ) nodelist  WHERE intf.NodeID = nodelist.NodeID   )
      
      
      SELECT count(*) AS [COUNTOF]
      FROM tbl
      INNER JOIN nodes ON nodes.NodeID = tbl.NodeID
      WHERE Nodes.Device_Type = 'MPLS_Router'
      
      

       

      ME_Hatlar.png