Jan_Pelousek ✭✭✭✭✭

Hello, the table you're looking for is most probably ContainerMemberSnapshots. This table contains current members, based on both Static and Dynamic group member definitions. I hope this helped.

Hello, current implementation allows creation of 2100 groups. This is caused by the limit on the SQL server side. This will be improved in future, however the biggest factor in performance below this number of groups, is the server performance. Basicly groups and dependencies are the ones of most expensive functionalities…

Hi dufer, it should be exactly as Pavel said. The displayed time format doesn't depend on OS regional settings, only on the regional settings of the browser you are using (remember your preffered language must be at top of the list of languages in the browser). I don't know your native language, but for the dd/mm time…

The configuration wizard is configuring the local IIS, so setting on one server won't impact your second server, however wih respect to hooked features, like report scheduler and so on + the fact you'll probably want to reach your web server the same way prior and after failover, I'd recommend you to set the bindings the…

It's designed as following: In Advanced Alerts Manager don't show the alerts, which were succesfully migrated to the web based format. The old ones aren't deleted (are still in the database, just aren't showing and are disabled). If some alerts weren't migrated for some reason, they should be still accessible and…

Can you please explain it? The upgrade issues aren't obvious (only environmental) andall settings you had in previous version you will have after upgrade.

Hmm... It is quite strange. In this case it will be probably the best to create support ticket for deeper investigation. To the SQL question: It very depends on the number of elements you wan't to monitor. The configuration is possible, supported, but with large number of elements or more modules installed it is not…

Hi Rockjjsolar, it looks like an error message from quite old NPM (I guess 10.1.3). Can you, please check the status of Module engine via Orion Service Manager? It usually takes quite long time until this service is fully started. In case you don't see this service, please try to restart your Orion server. In case it…

Have you tried to run the OrionPermissionChecker? (Default location is c:\Program Files (x86)\SolarWinds\Orion\OrionPermissionChecker.exe) this should check and repair the local permissions. Try to run it and let us know. H.

The list, which Tim posted in http://thwack.solarwinds.com/message/198138#198138 should be still valid.The missing functions are ToLocal() and ToUtc() and following ones which are available in NPM 10.6. DateTrunc2013.1SELECT DateTrunc('month', DateTime) FROM Orion.CPULoad Supported values for the DatePart argument: Minute,…

I'd like also add to the last comment, that in NPM 10.6 vs. SDK 1.7 there's possible to use the function toLocal() to convert the time from UTC to the client's local time and functions like DayDiff (or YearDiff, MonthDiff, WeekDiff, DayDiff, HourDiff, MinuteDiff, SecondDiff) to expand the WHERE condition to filter it by…

Hello, updating the properties within Orion.Nodes can be done easily via update operation as you do that... you just need to know the node uri, property name and value. In case you're switching the DynamicIP property to true, you must also set, or have set the DNS so it can't happen, that you have dynamicIP node without…

Hello, it's hard to guess, but until the support takes a look at your issue: 1. Make sure the NetBios name is resolvable to the primary IP and vice versa. Otherwise add the record to the Windows\System32\drivers\etc\hosts file. 2. Try to repair environmental permissions by c:\Program Files…

Hello, sure. If you're polling the network nodes by remote poller (the polling is assigned to those pollers), the response time and availability is monitored in it's context. The additional pollers are licensed separately, but you pay just the Core license. Not sure if there's possible to have APE license if your main…

Hello, I don't know which commands are you using, however for such cases is usually used switch "-force" when using the commandlet. Example: set-executionpolicy "bypass" -force Does it suit your reqs? Honza

IPAddress can't be array of strings. You need to for example create an array of addresses and then iterate through the array. e.g like. $Addresses = @("10.132.100.1", "10.123.0.2","10.345.2.6") $Addresses | Foreach-Object { $newNodeProps = @{ EntityType="Orion.Nodes"; IPAddress=$_; ....... } Ad pollers: -…

Hello... that should be possible via Orion API through Orion SDK (Orion SDK Information). You just need to know the uri of the object, which you're about to delete. The objects incl. their statistical data will be deleted with the next DB maintenance (e.g. interfaces are moved from Interfaces->DeletedInterfaces table)…

Hi, the information service is designed to return the data always in UTC regardless on the storage (it knows if it's UTC or local in the DB per schemas) and that's also what the resource returns. If you wish to convert the values to the client locale, you can use toLocal() function. Example: select ToLocal(keepalive) as…

And the syslog agent on that server is configured to send the syslogs to that NPM server? Syslogs and Traps is different from classic SNMP. In SNMP the device gives you the information on demand. For Syslogs and Traps - the devices must be configured to send the messages to Trap/Syslog server (in this case NPM Trap/Syslog…

Hi David, could you be please more specific which NPM version are you using? However query like : Select i.Caption, c.CircuitType, c.CircuitID, c.CircuitProvider from orion.npm.interfaces i join orion.npm.interfacescustomproperties c on i.interfaceid=c.interfaceid where c.CircuitType='VPLS' should work for you. (at least…

Hi folks, maybe some good news for you. In the latest version of NPM 10.4.1 which will be available on your Customer portals in upcoming days were done massive improvements of Group account limitations. I hope it will resolve your issues and answers your questions. AFAIK there are only a few known "issues" at this time -…

Hello, as far as I know the SDK at this time doesn't support subscriptions as they are used within the Orion.This is currently possible only via the SWQL studio connected via certificate, but the SDK API libraries aren't yet ready for implementation of the users subscribers via API. In my opinion there could be reused the…

Hello, the DB maintenance does a lot of things, but in general the main task is to aggregate statistic data according to the polling settings and deleting the old data. When enabled, the DB maintenance can also perform SQL indexes rebuilt. Periodic run is recommended to keep your database in good condition (smaller tables…

Hi, I just need to please you to stay tuned. The reason for crashing has been found and fixed version is currently being tested so I expect to make it public soon. Your steps don't look bad, BUT.... The uninstallers aren't perfect, so the outcome might be pretty unpredictable... Also not sure if that's supported from…

Hello, calling SQL delete queries aren't very safe as orphaned data may remain in your DB and can make troubles in future. There exists way how to achieve your goal via Orion SDK based scripts. I described snippet at Re: Manage resources list for multiple nodes in Orion . The filter condition is always up to you. For…

No, List resources is not designed this way. This function is disabled with multiple selection. Could you, please specify your usecase? List resources is designed for obtaining the information directly from the device.

Sorry I have no specific already cooked solution for you, however if you can't find the desired functionality in the product, I'd probably elaborate with creation of custom powershell SAM template (see), based on PowerShell Gallery | VMware.PowerCLI 6.5.4.7155375 module to meet exactly your requirements. Regards, Honza

Hello, assuming the old unused server is no more anywhere in the system (e.g. newly deployed additional website, HA server standby or so), please look at table OrionServers and clean the zombies from here. After that please check the license manager and eventually reshuffle the licenses. I believe this should resolve it.…

If you're existing paying customer, you can ask the support representative for the Temporary key to extend evaluation of the product. If you are not, contact the sales department (sales@solarwinds.com). After you'll have the key and have the latest release, you should be able to activate the licenses on the Web license…

Hello, per my knowledge the AP MSMQ doesn't need to talk to the Primary engine. However the AP needs to talk to the Primary Information Service and BusinessLayer (Orion Module Engine). I can't see the entire name of the queue, but if that belongs to the Information Service, that may mean, that AP is unable to deliver the…