1 Reply Latest reply on Apr 5, 2018 10:44 AM by jamesatloop1

    An identifier in solarwinds database for router and switch

    mohitsingh

      Hello All,

       

      I do have an integration with Solar winds database to service now to populate the available record(devices) in Service Now.

       

      now i am in a situation where i am not able to identify the devices between router and switch. I know this is a switch and this one is a router, but i am not able to find a field or identifier which says yes this one is router and this one switch in solar winds Database.

       

      Can someone please help me on that?

       

      regards

      Mohit Singh

        • Re: An identifier in solarwinds database for router and switch

          here you go under Machine type.

           

          SELECT TOP (1000) [NodeID]

                ,[ObjectSubType]

                ,[IP_Address]

                ,[IP_Address_Type]

                ,[DynamicIP]

                ,[UnManaged]

                ,[UnManageFrom]

                ,[UnManageUntil]

                ,[Caption]

                ,[DNS]

                ,[Community]

                ,[RWCommunity]

                ,[SysName]

                ,[Vendor]

                ,[SysObjectID]

                ,[Description]

                ,[Location]

                ,[Contact]

                ,[RediscoveryInterval]

                ,[PollInterval]

                ,[VendorIcon]

                ,[IOSImage]

                ,[IOSVersion]

                ,[GroupStatus]

                ,[StatusDescription]

                ,[Status]

                ,[StatusLED]

                ,[ChildStatus]

                ,[EngineID]

                ,[MachineType]

                ,[IsServer]

                ,[Severity]

                ,[StatCollection]

                ,[Allow64BitCounters]

                ,[SNMPV2Only]

                ,[AgentPort]

                ,[SNMPVersion]

                ,[TotalMemory]

                ,[External]

                ,[EntityType]

                ,[CMTS]

                ,[BlockUntil]

                ,[IPAddressGUID]

                ,[CustomStatus]

                ,[Category]

                ,[CustomCategory]

                ,[EffectiveCategory]

            FROM [mydatabase].[dbo].[NodesData]