Solarwinds service graph connector not populating required fields populating.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 06:36 AM
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"}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2023 12:40 AM
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.