Solarwinds service graph connector not populating required fields populating.

cmclean
Giga Contributor

We've been having issues with pulling data into the correct fields. 

I'm showing that the script is running this query and pulling the data, but the script doesn't populate the aliases with anything, so the data for these fields all show blank. Are there supposed to be variables there or some process of populating those aliases?

 

select Nodes.InstanceSiteId, Nodes.NodeID, Nodes.IPAddress, Nodes.IPAddressType, Nodes.DynamicIP, Nodes.Caption, Nodes.Category, Nodes.NodeDescription, Nodes.Description, Nodes.DNS, Nodes.SysName, Nodes.Vendor, Nodes.IOSImage, Nodes.IOSVersion, Nodes.CPUCount, Nodes.MachineType, Nodes.IsServer, Nodes.TotalMemory, Nodes.CMTS, Nodes.IP, Nodes.IP_Address, Nodes.LastSync, HardwareHealth.Manufacturer, HardwareHealth.Model, HardwareHealth.ServiceTag, '' AS HostName, '' AS SystemName, '' AS Domain, '' AS DNSName, '' AS DomainRole, '' AS AssetType, '' AS OperatingSystem, '' AS OSVersion, '' AS OSArchitecture, '' AS ServicePack, '' AS OSLanguage, '' AS HardwareSerialNumber, '' AS ProductNumber, '' AS ServerInformationManufacturer, '' AS ServerInformationModel, '' AS LastLoggedInUser, '' AS Contact, '' AS ProcessorCount, '' AS TotalMemoryB, '' AS VirtualMemoryB, '' AS PartOfDomain, '' AS DeviceType FROM Orion.Nodes AS Nodes LEFT OUTER JOIN Orion.HardwareHealth.HardwareInfo AS HardwareHealth ON Nodes.InstanceSiteId = HardwareHealth.InstanceSiteId AND Nodes.NodeId = HardwareHealth.NodeId  ORDER BY InstanceSiteId, NodeID WITH ROWS 1 TO 10000"}

1 REPLY 1

Community Alums
Not applicable

This could be the user credentials. while you configured the graph connector, it asked for Orion credentials. so the credentials should be domain-specific ones, otherwise, it's limited the data while you loading.