tporritt · Senior System Specialist

Wearing too many hats, it's death by 1k cuts. Not enough time to get into flow and stay there without some request or question derailing the effort.

I'd start with something like this: https://wiseservices.co.uk/post/a3a10db6-02b5-4162-9773-cc3e2c618a47 Then instead of emailing the results, write the data to a location that SolarWinds can reach such as Sharepoint and use another Powershell monitor to parse the file and if entries greater than 1, send alert (with…

Be aware, if you are self hosted legacy, trying to call it from another system that does not support self-signed certificates; you will need to generate and assign a new certificate to an alternate SWIS endpoint port. Configure the SolarWinds Platform Web Console to use HTTPS

As I intend to use this in a report, SQL would work however I am not familiar with TSQL, I asked ChatGPT but it doesn't have a good handle on SWQL to convert it. Here is what I got for the joined field but it doesn't work and I don't know where to start with it. SELECT NodeID, Name, Installed_KBs = STUFF(( SELECT ', ' +…

SELECT [N].Caption , CONCAT('', [N].NodeID, '') AS col1 , [N].AssetInventory.Enabled , [N].ObjectSubType , [N].Status FROM Orion.Nodes AS [N] WHERE [N].AssetInventory.Enabled IS NULL AND [N].ObjectSubType NOT IN ( 'ICMP', 'SNMP' ) AND [N].Vendor = 'Windows' AND [N].Staus <> '9' -- This is my filter on the Node's Custom…

Well, I had not been limiting by vendor=Windows and after doing so I only end up with 13 nodes showing. I then tried a couple for List Resources and they time out or had been marked unmanaged. Added Status to the query and only have a few showing status of 1 and those seem to have some kind of polling issue. I guess I was…

That is worth exploring if we can do it from Powershell but I cannot seem to find the flag that would include Asset Inventory. The example for single node import doesn't include such a thing: https://github.com/solarwinds/OrionSDK/blob/master/Samples/PowerShell/CRUD.AddNode.ps1 Similar with the singe node…

I spot checked 5 of the 36 nodes and got the same 'false'. Here is the XML 5077

Unfortunately this gives the same 'false' message that I had before (and of course no context about why). Still not seeing anything in that log that seems to pertain to this action. With my initial query I was seeing 110 nodes without AssetInventory polling enabled, your query returns 36 nodes. After plugging the resulting…

We use a server at each remote location, as we were already monitoring them with SAM and an agent, it made sense to use the same servers as a Netpath endpoint.

I would double check the authentication that the SMTP server requires. It sounds like either the message is getting rejected because of an authentication issue or spam classification. Maybe your email admins have some logs they can review if either of those do not fix the issue. Good luck!

Your SMTP server might need to have the sender (main poller) whitelisted.

Ok, thanks, I will also try that OID.

Thank you for the detailed response, I will certainly try this out!

I believe I solved it after installing the SDK, watching a couple of videos, reading some Thwack and browsing a few blogs. Here is what I came up with: SELECT DISTINCT RawMAC, PortName, PortDescription, NodeName, NodeStatus, MACVendor, IsCurrent FROM Orion.UDT.MACAddressInfo WHERE IsCurrent = '1' AND (MACVendor = 'Polycom,…