This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Report for unmanaged nodes

johnlad over 5 years ago

Ok hopefully someone can give me some direction, I am wanting to run a report to display all unmanaged and muted nodes and interfaces, I also need to see who they were unamanged by, wasn't sure if this can be created on the reports page or if I need to run report writer?

0 mesverrum over 5 years ago

Type the name of your question into the search box and I think you'll find at least a dozen threads with solutions. I usually use a custom swql query resource for this one.
Cancel
Vote Up 0 Vote Down

Cancel
0 jamesatloop1 over 5 years ago

Crack open a new custom table report and select custom sql as datasource. Enter the following and enter your database name instead of 'mydatabase'.
SELECT TOP (100000) [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] where status like '8'
Cancel
Vote Up 0 Vote Down

Cancel
0 sachsj over 5 years ago

I created this query and transferred into Report Writer. On the home page, I added a frame for 'Report from Report Writer' and selected the report I created.   This will show all currently unmanaged nodes.
The facility number is just a custom property so you can remove or add your own.
SELECT ni.[NodeID]
      ,ni.[StatusLED]
      ,ni.[Caption]
      ,ni.[IP_Address]
      ,ni.[Vendor]
      ,ni.[MachineType]
      ,ncp.[FacilityNumber]
FROM [SolarWindsOrion].[dbo].[NodesData] ni
Inner Join [SolarWindsOrion].[dbo].[NodesCustomProperties] ncp ON ncp.NodeID = ni.NodeID
Where
UnManageFrom <> '1899-12-30 00:00:00.000' AND
UnManaged = '1'
Cancel
Vote Up 0 Vote Down

Cancel
0 sachsj over 5 years ago in reply to sachsj

Sorry I didn't read your entire post.   In adding the AuditingEvents table, I was able to see the user account responsible for unmanaging the node.
SELECT TOP 1000 ni.[NodeID]
      ,ni.[StatusLED]
      ,ni.[Caption]
      ,ni.[IP_Address]
      ,ni.[Vendor]
      ,ni.[MachineType]
      ,ncp.[FacilityNumber]
     ,ae.[AccountID]
     ,ae.[TimeLoggedUtc]
FROM [SolarWindsOrion].[dbo].[NodesData] ni
Inner Join [SolarWindsOrion].[dbo].[NodesCustomProperties] ncp ON ncp.NodeID = ni.NodeID
Inner Join [SolarWindsOrion].[dbo].[AuditingEvents] ae on ae.NetworkNode = ni.nodeID
Where
UnManageFrom <> '1899-12-30 00:00:00.000' AND
UnManaged = '1' AND
ae.ActionTypeID = '28'
Order by ae.TimeLoggedUtc DESC
Cancel
Vote Up 0 Vote Down

Cancel
0 Jonathan.White over 3 years ago in reply to sachsj

This doesn't work for me on the Web Reports. I'm getting a query error. It states the query is invalid. Would you all be able to determine if there is an issue with the script when trying to run it through the Web Reports?
Cancel
Vote Up 0 Vote Down

Cancel