bobmarley ✭✭✭✭✭

If I were to ask Santa for something for myself I think it would be a < $400 drone with as many features as possible but I don't know which one I would ask for? Anyone have any suggestions or favorites?

Upload Custom Properties - Scripts - The SolarWinds Platform - THWACK Take a look at the script and how it is updating custom properties. Adding custom properties to the is best dome via the Web Console. You can add them directly to the database but that is risky. The safest method is via the GUI. The above link can help…

Do you have additional polling engines? Is the NetFlow service running on those? It was my experience if I did not have it licensed it would show up briefly in the SolarWinds Service Manager then would disappear and that was normal behavior for an unlicensed one. If you have HCO and yours is not working, then possibly…

One big issue we faced is that we have dozens of engineers adding different node types every day. Some were good at it, some were not, and some forgot altogether. The same happened during node retirement, all three flavors again. Our node inventory changes daily, what can we do to keep it relevant to what is actually out…

This will get you started. Use Custom Query widget and this SWQL SELECT top 100 n.Caption AS [Node Name], n.DetailsURL AS [_LinkFor_Node Name], '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node Name], i.InterfaceName AS [Interface Name], i.DetailsURL AS [_LinkFor_Interface Name],…

If you simply want to send syslog messages, there is an existing alert action for that. You just need to configure it. 

I just applied the license and then rebooted all of the servers just for good measure and everything was fine.

San Francisco is still there :)

Way more fun to meet people in person. 

This is the logic I am using in my SQL Replication alert, which is driven by the SAM template above. Once the alert is created you can send the email directly from SolarWinds as an alert action and you don't need an external email script. If you are trying to use external scripts in your alert actions, there is a security…

I'm not currently using it bit it may be the table below, give it a try in SWQL Studio SELECT TOP 100 LogEntryID, LogEntryTypeID, LogEntryLevelID, NodeID, MessageSourceID, DateTime, MessageDateTime, Message, Level, LevelKey, DisplayName, Description, InstanceType, Uri, InstanceSiteId FROM Orion.OLM.LogEntry

If you have SAM possibly use a SAM template to look for error 1676 in the System log? Then just create alert for it under Manage Alerts and then create an alert action send the text part. 

Select n.Caption AS [Node] ,n.DetailsURL AS [_linkfor_Node] ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node] ,n.IP_Address AS [IP Address] ,n.DetailsURL AS [_linkfor_IP Address] ,n.StatusDescription AS [Status Description] ,n.ObjectSubType AS [Collection Type] ,e.Servername ,n.StatCollection AS…

Give this a try SELECT T.[Node Name], T.[Start of Downtime], T.[End of Downtime], T.[Duration] FROM ( SELECT N.Caption AS [Node Name], E.EventTime AS [Start of Downtime], ( SELECT TOP 1 EventTime FROM Events AS EndEvent WHERE EndEvent.NetworkNode = E.NetworkNode AND EndEvent.EventTime > E.EventTime AND EndEvent.EventType =…

If it is a group activity I would love to be involved

Almost all monitoring tools have an API. If there is not an existing integration into one of the other toolsets it is always possible to move data between the tools via the API. 

Brand new install or connecting to an existing database ? I have usually used the Domain then ComputerName to directly connect to a SQL server or to a SQL Listener for a SQL Cluster. I see no reason why a DNS alias would not work. Permissions issues? The account needs to be DB_Owner at a minimum after the installation but…

There are many useful events in that table such as FROM Orion.AuditingEvents Where AuditEventMessage like '%unsuccessful attempt to login%' 

The M is Millions of packets

Here is the SWQL Table for accounts. You can create a custom SWQL report and remove any values that you do not need SELECT TOP 1000 AccountID, Enabled, AllowNodeManagement, AllowMapManagement, AllowOrionMapsManagement, AllowUploadImagesToOrionMaps, AllowAdmin, CanClearEvents, AllowReportManagement, AllowAlertManagement,…

Active Directory?

Give this a try SELECT WLC.DisplayName AS ControllerName, WLC.ThinAPsCount AS TotalThinAPs, COUNT(AP.ID) AS DownAPCount, (1.0 * COUNT(AP.ID)) / WLC.ThinAPsCount AS DownPercent FROM Orion.Wireless.Controllers AS WLC INNER JOIN Orion.Wireless.AccessPoints.Thin AS AP ON WLC.ID = AP.ControllerID WHERE AP.Status = 2 -- 'Down'…

I have used a similar method to what @"Lofstrand" suggested. Once you set up your report you can schedule it to run at any interval you wish. As a Save option if you chose to write to disk you can save the data out to a network share that the PowerBI can also access to import. Another option is to write your query in SWQL…

The first three should be collecting if you have Hardware Health monitoring turned on at the node level. High Packet Loss done on all nodes out of the box. Latency, Disk I/O is collected by default if it is a 'Smart' node license (not using only ICMP Ping). Voltage and Battery Health, assuming its a UPS, you may need to…

Our company typically promotes from within unless we can't find someone to meet our needs internally. Once we do go outside it's all in the HR department to screen candidates and then they typically only present us with 4-6 to interview. Since SolarWinds is one of the tools specifically spelled out as desired in the job…

Very nice work @"iamprince" 

The link that @"donrobert5" posted should fix your issue. Had the same thing happen to me. Once the certs are fixed the problem should go away. Good luck.

Another thing you can try as a good measure is put all of your SolarWinds servers in the Hosts file. Both long and short name. Adding static entry for hosts that are not resolving by DNS on Orion Platform

Try Port 17774 for the SDK SolarWinds Port Requirements