wildersa

Comments

  • Hi, as a workaround, you can try this query to convert the value: SELECT DateTime, --NodeID, RowID, [CustomPollerStatus].Status, REPLACE(REPLACE(CONVERT(nvarchar(max), CONVERT(varbinary(max), [CustomPollerStatus].Status), 1), '00', ''), '0x', '') FiberWwn FROM [SolarWindsOrion].[dbo].[CustomPollerStatus] (NOLOCK) INNER…
    in Add Hex transforms to Custom UnDP pollers Comment by wildersa June 2019
  • These functionlaity will help me a lot, meanwhile, I found a workaround: 1. I created a "SQL Server User Experience Monitor" with a query, converting the table result to an XML; 2. I created a report converting this XML back in a table. It's working fine for me. Example: Monitor query with table as xml SELECT '1' test,…
    in Custom ODBC/SQL Table Monitor Comment by wildersa July 2020
  • did you manage to include it in the monitoring? If yes, what was the issue?
    in does SRM support to add array for IBM FlashSystem V5000? Comment by wildersa July 2023
  • "For example, consider a network discovery configured to search within the IP address range starting at x.y.z.0..." In this scenario, the a.b.c.45 device need to have some connectivity with the pooler or it's added because your IP is on the, for exemple, routing table of device x.y.z.20, without directly connectivy with…
    in What exactly does the "Hop Count" in Network Sonar Discovery? Comment by wildersa February 2018
  • Hi, you can try this query: SELECT DateTime, --NodeID, RowID, [CustomPollerStatus].Status, REPLACE(REPLACE(CONVERT(nvarchar(max), CONVERT(varbinary(max), [CustomPollerStatus].Status), 1), '00', ''), '0x', '') FiberWwn FROM [SolarWindsOrion].[dbo].[CustomPollerStatus] (NOLOCK) INNER JOIN…
    in MOXA EDS-P510 igmp Group joined ports UnDP Comment by wildersa June 2019
  • Hi, you can try this query: SELECT DateTime, --NodeID, RowID, [CustomPollerStatus].Status, REPLACE(REPLACE(CONVERT(nvarchar(max), CONVERT(varbinary(max), [CustomPollerStatus].Status), 1), '00', ''), '0x', '') FiberWwn FROM [SolarWindsOrion].[dbo].[CustomPollerStatus] (NOLOCK) INNER JOIN…
    in Creating a UnDP for monitoring a Hex String. Comment by wildersa June 2019
  • Try this: In my case, I changed the polling method from WMI to Agent and the SQL Server monitoring I added while the node was in WMI method. If the "Prefered Polling Method" was checked to Agent, the Orion'll try to use the agent credential instead the credentials provided in "SQL Server Credentials".
    in How to run AppInsight for SQL on an Agent System? Comment by wildersa March 2019
  • Hi, you can try this query: SELECT DateTime, --NodeID, RowID, [CustomPollerStatus].Status, REPLACE(REPLACE(CONVERT(nvarchar(max), CONVERT(varbinary(max), [CustomPollerStatus].Status), 1), '00', ''), '0x', '') FiberWwn FROM [SolarWindsOrion].[dbo].[CustomPollerStatus] (NOLOCK) INNER JOIN…
    in How to ingest hex strings in plain text in UnDP Comment by wildersa June 2019
Avatar