Lofstrand · Solutions Architect · ✭✭✭✭✭

Comments

  • Nice one @"jm_sysadmin" I have extended the query some. This one assumes you want the IPAM network field "location" to go to Node custom property "City". I first check that location field is not null or blank, then I check if the two fields are the same or not. Only updating the nodes that need updating. SELECT n.NodeID,…
  • Hi Todd Looks like the old web page is not even on the webservers drive. So I guess there is no way of restoring it (If you can't find the file, copy it in there and get it to work....) If you hoover over a network you will see the description: If you use the "advanced search" it will search all subnets:
  • I strongly suggest that you use SQL authentication here instead of windows/integrated authentication. As the servers are not domain joined. And as @"maciej.sandecki" says, without domain you can't use Kerberos and thus SPN is of no interest. Run the config wizard again, make sure that you use SQL authentication and that…
  • Hi, I see "N/A" on some "DefragmentIndex" operations. Defrag typically only happens on indexes that are more fragmented than a threshold and larger than another threshold. (don't know the numbers). When I look at a few of the indexes from SQL management studio, that has N/A on them, they are not very fragmentet and small…
  • Hi, You can use the same account. Combining what the two products require. One advantage of using separate account can be that it's easier to see what each application is doing. But using one account is less accounts to administer. So it's up to you.
  • One thing to consider when thinking about using an online SMS provider is: How are you going to send an SMS alert that the network is down, when you can't reach the SMS provider due to the network is down? My suggestion is to purchase a hardware device for sending SMS, placing is as close to the SolarWinds server as…
  • Try using the variable ${N=SwisEntity;M=NodeID} instead of ${Nodeid} I found that this made a difference.
  • Microsoft now recommend disabling STS on "..Servers that use time as part of data processing..." Secure Time Seeding Recommendations for Windows Server - Windows Server | Microsoft Learn
  • Hi, no you don't need to assign a resource pool just because you are using memory optimized tables. You CAN if you want to but there is no recommendation to do so. Resource Governor and related Resource Pool features are available in Enterprise (and Developers) Edition only!
  • Hi, as @"maciej.sandecki" said, you are stating that it's a SQL query when it's actually a SWQL query. Here is a simple one: ${N=SWQL;M=SELECT N.caption from Orion.Nodes as N WHERE N.nodeid=${N=SwisEntity;M=NodeID} }
  • Hi, since a couple of years there is a limitation to what html features you are allowed to use. See this link for more information: Custom HTML