frak

Additionally, a fresh install will work for a month in 'demo' mode before it stops working. If you can fit in the migration within a month it can be a valid strategy. You can also get that demo extended, though that can be a bit of a challenge to get an okay from SW on. Definitely worth talking to support first, though as…

There is a simple way to make a SAM monitor more scheduled. Designed this a while ago, for a monitor/clean-up script to run on our servers. Basically to clean up temp files, admin user profiles when not used for a few months, etc. * Schedule the monitor as high a resolution as you need. * Configure with a param, the times…

If you look at the status tables for Components, Applications, etc you will see a created and updated date. Updated date looks to be when the poll finished (it is a few seconds newer than the Create data, usually)

A bit hard to answer with no details of what you are doing. Most things you want to monitor can be done by SQL, so you can use SQL Experience Monitor components for that. You may end up running a lot of seperate queries though. Alternatively, if you go to one of the Script monitor components (eg Powershell), you can run a…

I had a problem a while back where the name of the custom property caused a clash. Try with a different named field.

Not looked at this from a SWQL point of view. I have some various reports using SQL, and can tell you that the folders are referred to as groups.

I am also looking to setup a pair of these for Solarwinds critical alerts. Not so much a fan of setting up a HTTP post for every alert with the password in it. Not encrypted an a pain to change every instance later. And hard to see the message in the URL. You can also use SMTP. This is what we are looking to do. Alert…

Code updated: I had accidentally used a SQL2017 function - trim. I have replaced that with an rtrim and ltrtim. They have been in SQL server forever.

Well found. Really not sure why TRIM is sometimes not available. What version of SQL Server is your Solarwinds install running on?

I can tell you what I planned to do but not got round to it. Assign a (note quite fake) Azure managment node, and a SAM powershell script to that. The PS script will pull down the details from the AZ API. That data can then be processed and shovelled into IPAM. The reason I like a monitor for that operations is it is easy…

As I understand you, you want a report that will show IP addresses that have gone from used to available and then back again within a 12 month window. I would do with with SQL. Also you need the history kept for 12 months to do that - default is a couple of months from memory.

It is a little hard to see as I have to sanitize the server name from the screenshot, however the server name appears on the IP address details screen. The list view shows the raw text - as I can't easily put javascript on that page.

I have updated the above solution to work completely. Just realised I should have posted a response to my comment above a month ago... (oops)

I expect Java will hang around a long as there are Java things to monitor. None of my solution uses Java though, it uses javascript like the rest of the Solarwinds front-end.

Partial function - ie a working link and Node popup can be restored by adding a Custom HTML box to the IPAM IP view. The following HTML/Javascript code will lookup the IP Address Custom Properties box, then find the NCM_NODE line, and convert it to a link. If the original text is in the form "<TEXT>|<LINK" ie has a "|" in…

As if the latest version - IPAM 4.8.1 HF1 - HTML custom data types have been removed. This turns the link into flat text, on the list and details screen. To get this working again will require some javascript on the page. When I get to that, I will update details here. Feature Request

lol. Actually no. Backups for some reason were setup to be VM snapshots in stead of SQL backups, and eventually the high activity of Orion SQL blew that out of the water so it could not keep up....

Damn good idea, thanks. I have made the edits.

Yes you should. That is why MSMQ is in step one - TURN OFF SOLARWINDS You can use Services to shut it down but it is simpler to use the Solarwinds tool for it.

acmtix​ to answer your question, never on purpose. I have had to do the first two steps a few times due to SQL server issues. Recently SW was off for about 20 hours because a vm-related issue for SQL that took all day for vmware to repair (it ended up with many snapshots within snapshots). Having it down for the first day…

I pulled out the WMI queries from that file, for some context. I think these would need tweaking for most people. SELECT DiskTransfersPersec FROM Win32_PerfFormattedData_PerfDisk_LogicalDisk WHERE Name="C:" SELECT AvgDisksecPerRead FROM Win32_PerfFormattedData_PerfDisk_LogicalDisk WHERE Name="C:" SELECT AvgDisksecPerWrite…

I don't have time to write something up right now, though I do have some powershell-related articles coming. I do have a powershell module that pulls in log files, then lays the result out in the same way and I do play to post that. (In that case I was looking to emulate the log views that the App Insight monitors have…

You will find the answer in [dbo].[IPAM_Group] - FriendlyName and comments field.

We have a new (ie current version - SAM 6.6.1) Solarwinds install, running off SQL2017. I added agent mode monitoring for the node running SQL, and just added App Insight. No issues that I can see. I don't recall if I manually added SQL App Insight, or it was suggested.

Check this query out - it will show you how to get the next and numbers for a componenet SELECT c.Name, dcs.Label ,ISNULL(pe.ErrorMessage, deM.StringData) msg ,ccs.ComponentID as ComponentID ,n.caption Node ,ccs.Availability ,pe.* FROM dbo.APM_CurrentComponentStatus ccs WITH(NOLOCK) left JOIN dbo.APM_PortEvidence pe…

It may be a good defensive idea to put an alert on the agent process, with a restart action on the agent.

The only thing you can do is make the second Solarwinds polling use WMI.

Setup a new alert Trigger condition as follows: Alert on: Custom SQL Alert (Advanced) Condition:Node SQL: WHERE NodeID in ( select NODEID from dbo.AssetInventory_SoftwareView where name = 'NAME OF SOFTWARE' ) Check for a green response when you press [Validate]

setup a Custom Poller. As long as all these values are available by SNMP (usually they are) then you can add them in. There are some standard classes (disk, etc) and if you are too different you will probably want to customise the node view.

There are two tables you could look at to get the data: - NPM_RoutingDefaultRouteChange - This will give you history of the changes for default route - NPM_RoutingNeighbhor - this gives you Node, Neighhour IP and the LastChange date/time. So if you want to just track the default route changes, then you have it in one…