Jan_Pelousek ✭✭✭✭✭

Hello Scott, I'm not sure about usecase of your query (used aggregation function doesn't make much sense to me for such report), however this should work for you: SELECT TOP 100 IFT.InterfaceID, Sum(IFT.InAveragebps) AS SumOfInAverageBPS FROM Orion.NPM.InterfaceTraffic IFT WHERE IFT.DateTime >= '2014/01/21' AND IFT.NodeID…

Hello, NCM before version 7.3 is still based on SWISv2, so in your case you need to use -v2 switch in your connection for calling the NCM verb (in your case e.g. $targetv2 = Connect-Swis -certificate -v2). After upgrade to NCM 7.3+ it should work with just one v3 connection. I hope it helped. Honza

Hello ian, it's most probably because of the typo in the name of the navigation property. Just modify your query to: SELECT Nodes.CustomProperties.AlertRules FROM Orion.Nodes WHERE NodeID='990' Let know if it helped. Michael: Ian needed SWQL querym but your query is SQL. The principle here is a bit different.

I would go here the way of Orion SDK (GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in Powe… ) script. E.g. in case of PowerShell I can imagine it would look like(not tested for your purpose, so please test first (and adjust if needed) via SWQL studio if…

Hello orionfan, there's possible to create and define permissions and individual settings using AD group. In case the Engineers are a part of some group on AD, you just add this AD group to Orion and all users in this group will inherit it's settings. In case of need of individual settings, there's still possible to add…

Hello, from my experience this may happen, when the Remote server machine and the Client machine don't have the same system time (are out of sync.). May that be your case? H.

Hello, the upgrade advisor is helping to solve the inter-version compatibility obstacles, which may appear during the upgrade (e.g. some of your products may not me compatible with the planned version). The mentioned products, which you didn't see in the advisor (but not sure what's the 2.1.1 - maybe Patch Manager?) are…

Hi shivrael, I'd start with Orion SDK documentation (shipped with it's installer). Some info and download links are located here http://thwack.solarwinds.com/thread/39001 . SWQL studio should be the good start point to play with SWQL. In addition the SDK contains PowerShell, C#, Java, VB and Perl API to work with SWIS. I…

What comes to my mind is to set up on these devices shutdown/sleep action to run the script (using Orion SDK) against Orion server which will make them unmanaged on shutdown/sleep and a startup/wake up script which would remanage them again.

Hi NetJoerg, in your case I expect that your previously used NPM 10.3 was installed in English. Then the displaying language (you report is mostly German) depends on the language preffered in your Web Browser. NPM 10.4.1 supports German and Japanese localization. In case you need to display the website in English, you have…

Please open the support ticket, so we can identify the problem. The issue might be caused by incorrect job migration or by some "enviromental" specifics, which the new scheduler can't handle with. Opening the ticket, collecting the diagnostics and troubleshooting will help us a much. Many thanks. Honza

Hello, the information you're requesting is not exposed via API as it's really just internal, but you can find the info you need from the Information Service schemas(by default stored in c:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas\). For your personal research you can use them (just read only),…

Hello, since you're new I assume you have the latest SDK. Go to Orion SDK samples (by default c:\Program Files (x86)\SolarWinds\Orion SDK\Samples\PowerShell\) and follow the CRUD.AddNode.ps1 example. Just to the "$newNodeProps = @{ }" hashtable add the DNS property and set the DynamicIP=$True Some more info about…

Hello, not sure which part of code doesn't work, but I can see you're using $CPNodeUri - it's format is fine... For setting of ImportedFromScript CP you're using the $newNodeUri, which I expect you're getting directly from New-SwisObject command and it's not correct. For updating you always need to have the uri in…

Hi Steve, it seems to me you have typo in swis connection variable in following line because the connection was previously built as $swis and you use $swish. Similar problem is in Remanage function ($swis1 vs $swis). Can you, please check it or are the used variables global? Problem part: $nodeid = Get-SwisData $swish…

Hello, if you're already on the Orion Platform 2016.2.100 (NPM 12.0.1) with Web based licensink, I think similar SWQL query (you may create report from it, pass it to custom query resource or execute via SWQL studio, ...) could give you what you need. SELECT os.HostName, la.ProductName, l.LicenseName, l. LicenseType,…

Hello, I believe the action you want to perform (acknowledge alert -> clear its instance as well as ActiveAlerts records) can be done by using the verb from entity Orion.AlertStatus "AcknowledgeAlert". Arguments are alertDefinitionId,activeObject,objectType, accountId, Note, method At least this verb is used for…

Not sure what you mean by this, but SWISv3 code is property of SolarWinds company and is part of the platform architecture. It just provide the API, which allows you to build your own applications/scripts on top of that. See Orion SDK Information

That possibly may be caused by troubles with DNS resolution. Could you, please, add the IP - hostname pair into the c:\Windows\System32\drivers\etc\hosts file (on the main give it record for affected APEs and on the Additional Pollers add record for main). Finally run "ipconfig /flushdns" from cmd on both machines and…

If only in IE, maybe I'd focus on the IE security settings. Mainly I'm thinking about the Internet Oprions -> Security Tab. Check if the Orion website isn't in Restricted sites and try to add it into the Trusted sites.

hello, the syntax here is exactly the same as in SQL. After correcting few mistakes in your query it will look like SELECT NODE.NodeID as NODEID, NODE.Caption AS NODEFROM Orion.Nodes NODEwhere NODE.Caption like 'AMX-VZB-%'ORDER BY NODE.Caption Honza

Hi Ben, not sure if this can be done automatically for VIM objects like DataCenters, because filters does work only for Nodes and Interfaces, but as solution or workaround you can assign special custom property to the interfaces you wan't to monitor this way. Than you can add to your Custom view the resource Top XX…

Hello, also per Administrator guide SWI supports following collations: * English with collation setting SQL_Latin1_General_CP1_CI_ AS * English with collation setting SQL_Latin1_General_CP1_ CS_AS * German with collation setting German_PhoneBook_CI_AS * Japanese with collation setting Japanese_CI_AS Usage of other…

Hello guys. The most significant problem is in approach. The custom query resource doesn't query directly against SQL database, but against SolarWinds Information Service v3 (Reffer to the Help for this resource). The reasons are more, but the most signigicant is simple - SWIS (SolarWindsInformationService) query engine is…

Guys, I just found this thread. URLs are generated per content of the Websites table. NEVER EVER change the SwisUriSystemIdentifier record unless you exactly know what you're doing. The fact, that some people may claim the change helped them is given just by mixing of more updates at the same time. SwisUriSystemIdentifier…

Check NPM 12.0.1 Release Notes - SolarWinds Worldwide, LLC. Help and Support There's also info about the Upgrade advisor. NCM and NPM surely can be on the single server (of course compatible versions). How to best use the features is, I'm affraid, question for hours and hours of talking and also that depends on your needs…

Hello, the report scheduler stays untouched here and the PDF export (e.g. as email attachment) is still available. The release notes points just to the "Export to PDF" button on the website right corner, that's no more available. If you're still worried, you may evaluate current version on the fresh VM and try. Regards,…

Hello, It very depends on what you need to do. If you need to use database operations like "DELETE", "UPDATE", etc. in SQL syntax, then you should use rather DB manager shipped with Orion or SQL management studio. If you need to work with Orion objects as they are designed, you can use SWQL studio (part of Orion SDK) or if…

Hello, this kind of annoyness was introduced with the Manage Nodes grid extensibility. In a future version this will be handled much smarter way. Sorry for inconvenience, but please stay tuned. Honza

Hello, assuming the nodes aren't down in fact, your network might experience random peaks in the response time (e.g. wirelessly connected devices, long routes, etc...). You can for example try to increase the ICMP timeout (when ICMP packet doesn't return until this time, node is supposed to be down) to override the…