bluefunelemental

1. A standalone instance of SAM which uses; * AppInsight for SQL to monitor your Solarwinds DB * AppInsight for IIS to monitor your Solarwinds IIS website * Orion Server template to monitor your Orion servers * Microsoft Messaging Queuing Events to monitor MSMQ * Microsoft Messaging Queuing Performance to monitor even more…

It seems besides the Maps - UDT fundamentally does not accept the unplugged status that NPM uses. Without a data mapping relationship that takes into account the Unpluggable field in OrionNPM.Interfaces table then it just sees down as down. Better integration and UI consistency would be nice between NPM and UDT in this…

Same happened to me - try going back to your main poller server - opening up the Advanced and/or basic alert manager app - and see if any are still enabled and/or alerting. If so work with support or manually recreate them in the web console then make sure to disable them in the win32 app. I guess you could also check the…

I don't have it in front of me but I just built this exact thing. Essentially I query the DB from a SAM powershell monitor This exports the query results as a csv file and compares it against the last run export. If there are any differences then it overwrites the saved csv with the new one. The beauty is an integration…

I have Hitchhiker's Guide to the Galaxy easter eggs all over my Orion - custom gif icons are the most fun to play with and easy to hide. There's endless phrases and names that could work as codenames here and could be funny taken literally by those not in the know. Don't Panic Mostly Harmless So Long and thanks for all the…

‌running into same issue and while this might not apply for your application I have been trying to create UX monitoring to cover me. Example, app owner reports issue where two systems stopped talking either due to service or process hanging. We determine that the communication between them is a soap call so we set up a…

If by trend slope then you mean the avg vs peak slope then this is what I would use the ForecastCapacity tables which are navigable straight from the Nodes so your alert looks something like this for CPU or memory percent used. Ultimately the data is in dbo.CPULoad_ForecastCoefficients (and related ram/interfaces tables)…

I have the same issue with my non-admin regional users. What is your account limitation based on exactly? Machinetype or vendor would make sense and I don't see why you would not see them then. If it's something like a custom property then it's what I see. Since you cannot add custom properties during discovery import they…

I've had some issues with group by in custom query resources. Try it with out the max and group by in the inner sub select to see if it works. Might need to group by both fields. Thanks, Christian

Go get UDT then add this Custom Query to a node details page. This will provide details from the nodes,interfaces, and UDT ports tables for the node you are viewing but the last column is the date when traffic was last seen on that interface. SELECT Interfaces.InterfaceName as InterfaceName , Interfaces.detailsurl as…

This is a tough one since you cannot filter on boolean values from what I can tell. However all valid nodes will be nodes or hosts or vcenters so I tested it over at http://systems.demo.solarwinds.com/Orion/ and this filter seems to work for me to filter out the 3 non-node guests. How about for you?

‌Todd, I do exactly this today with Sharepoint but have taken the approach of driving the links off pages names. For example we keep system documentation on sharepoint by the same system name as we use for our groups in Solarwinds - therefore on the groups detail page I added custom HTML resource with something like this…

I'Ve been playing with this off and on for the last week. If you are not getting anything passed are you using the correct powershell? Off the top of my head after your above query to populate the $imports variable you would call it then pipe for-each into to your add node script $imports | foreach-object { your add node…

My evolving approach is to add the node as one process through SDK. Then also add the IP to an existing Network Sonar Discovery profile. The profile is scheduled daily and has the autoimport field in the DB set to yes. While you don't then get to choose which interfaces it does seem to work well so far for WMI nodes.…

Found them in the Select * FROM [dbname].dbo.ResourceProperties WHERE PropertyName = 'SWQL' and used this SQL to collate them SELECT TOP 1000 r.[ResourceID] ,r.[ViewID] ,'/Orion/SummaryView.aspx?ViewID=' + CONVERT(varchar,r.viewID) AS [DetailsURL] ,r.[ViewColumn] ,r.[Position] ,r.[ResourceName] --,[ResourceFile]…

Polaris, According to the SWIS Studio it looks like Orion.Accounts does have a CreateAccount action you can call. Check out the SDK docs here Orion SDK Information and lab here Automation and the SolarWinds API

I think internalizing some of the recent devops strategies like minimum viable product and test,pivot,re-test will both help you create a service more reflective of your colleagues needs and evolve quicker then their system. At the end of the day - if your product is better and has provided new value more recently you'll…

‌where are you applying the query? tostring( is a SWQL function so it would not work in the database manager or sql. Try that query by opening up http://your-orion-server/Orion/Admin/Swis.aspx and replacing the query there with the volumes not responding one. I hear that having the nodes polled by WMI helps with this but…

YEah I would recommend your second suggestion so that you can use the naming convention of Location_ObjectType for your subgroups. * Create node custom properties for loocation and objecttype * create your location groups * create your location_objecttype groups * nest your groups as you want * create dynamic queries…

Have you tried removing the page view limitation and just adding that into the data source? Does it look ok in a standard web report with the same data source?

Manage Nodes, then two options: 1. locate the node and select the + button to see all interfaces, select the old ones and choose delete in the top menu 2. change the top search section to interfaces, type in your node name, in the search results select the interfaces below (beware of the connecting node interfaces)and…

Download and install the swis sdk app. connect to your instance and look for the Orion.container table. Those are the droids you are looking for.

not 100% here but just thinking if the syslog is incoming, and the IIS is only needed on the main poller (which you can just assign no nodes to) that leaves only the polling IP interface which needs the default gateway. If you subnet off your syslog then most everything it needs to poll should route out the default route…

Can you tell I have off work this afternoon Here's the custom resource version - pro - is it is quick to add to any site and modify when needed and it groups into any number of nodes per page you want con - unlike the above report you cannot make the IP address and/or hostname clickable to the IP Node details page.

Looks like you can do the same result without needing a custom SQL report.

Hostname as in dnsbackward? Here's a custom SQL that should work (assuming you wanted subnet location vs node snmp location?) : SELECT i.IPAddress,g.addressMask, i.dnsbackward, g.Location, i.Description, i.Vendor FROM IPAM_Node i inner join IPAM_group g on i.subnetid=g.groupid where i.dnsbackward is not null and…