Reporting Group

 View Only

  • 1.  SQL Report query

    Posted Oct 05, 2016 10:02 AM

    Hi All,

    I am trying to discover what all routers are available in the environment. I have the router asset serial number.

    I and try to get the columns as 

    (Router) Asset Serial 
    Host name
    IP Address
    Server name
    Model 
    Place of Installation
    Date of Installation

    I am not able to get the details. Anybody has tried this? 



  • 2.  RE: SQL Report query

    Posted Oct 07, 2016 10:29 AM

    Are you importing this data in the database through an import or discovery rule? 



  • 3.  RE: SQL Report query

    Posted Oct 31, 2016 07:05 AM

    What table are you targeting?

    Please provide the query that you are using.