tomas.mrkvicka

I am not sure if it is what you want, but you could create clone of your actual database and new NPM installation could be run against cloned database. Of course original database and cloned database won't be related in any way.

I am afraid PluginConfigurations column in DiscoveryProfiles table is only place where you get all information (since version 10.2). We did big changes in Discovery in version 10.2 and this is one of them. Storing configuration in XML allow us to be more flexible (we need it because discovery is now pluggable).

There is dedicated forum on thwack about Orion SDK. Basic information can be found here On forum you can found lot of interesting information. So if you master any programming or scripting language it could be good way for you.

Hi, I am not aware of any such data model. Honestly database is our implementation detail (which can be changed from version to version) and therefore I wouldn't expect any detail information. For 3rd parties we provide Orion SDK (but even in it you won't find any schema description). Anyway you can always ask question to…

Have you tried this: UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%' Then run DB Maitenance. To turn off defragmentation: UPDATE dbo.Settings SET CurrentValue = 0 WHERE SettingID LIKE 'dbm-defragmentation-enabled%' Via this you enable our automatic defragmentation system which…

Here is pattern for cursor going through all nodes: DECLARE mainCursor CURSOR LOCAL FAST_FORWARD FOR SELECT NodeID FROM Nodes WITH(NOLOCK) OPEN mainCursor DECLARE @actualNode AS INT FETCH NEXT FROM mainCursor INTO @actualNode WHILE @@FETCH_STATUS = 0 BEGIN -- here you can execute procedure for given node stoed in…

Hi, it seems to me like this condition is little bit weird. You want to have Fullname containing Satcom or Radiolink and you want also to have Seadrill inside it. Btw. shouldn't you use % instead of character *?

Do you know more details about that error while creating database? Are you sure you use SQL Account which has permissions to create new database etc.?

Hi, I recommend you to open support ticket for this issue. We have already seen very similar issue and therefore there is big probability that our support will be able to help you. Please don't forget to put ticket number here.

Hi Karl, could you please open support ticket for your issue and paste number of ticket to this forum? For us it will be easiest way how to help you. Thanks.

Hi, this is not bug. On "Managed groups" page there is setting "View mode" which defines how are groups displayed. By default it is set to "All groups" which shows all main groups and subgroups. You can also select to display only main groups or flat view (where hierarchy of groups is not displayed).

Hi, there were made big changes in Discovery in NPM 10.2 which means new tables are used. Base entry point for all discovery data is table DiscoveryProfiles which contains list of your profiles (key is <ProfileID>) Second important table is DiscoveredNodes which contains all found nodes for all profiles (key is tuple…

Hi, you can either create support ticket for your issue (and somebody from development will help you) or you can try to solve it yourself. It should be good enough to use application called Process Monitor (http://technet.microsoft.com/en-us/sysinternals/bb896645) which tells you many information about accessing files,…

Hi, I am afraid this information is not stored in database directly but it is computed from table CPUMultiLoad_Detail. There are columns NodeID and CPUIndex - so number of distinct CPUIndex values for one NodeID is equal to number of CPUs on given node. Of course in order to get best performance it is good approach to get…

Hi, if name of your custom field is "CustomLocation" then you can use following query: SELECT CustomLocation, COUNT(*) AS NumberOfItems FROM dbo.Nodes WITH(NOLOCK) GROUP BY CustomLocation

Hi, even there is error message about Job Scheduler it is actually not the one Job Scheduler displayed in services. This is Job Scheduler from Job Engine v2. Job Engine v1 has separated Job Scheduler service but Job Engine v2 has integrated Job Scheduler (invisible in services). Therefore you should check status of Job…

Hi, which version of NPM do you have? There were big changes in discovery for version NPM 10.2 and later. If you have older version you could try newer one.

Hi, officially we don't support this but I don't think there should be any issue with it. Only one issue could potentially be during upgrade to next version. So I would say that change could be fine but before any upgrade you should remove these default constraints from database (in order to be sure everything will be ok).

I am afraid there is no such feature. Our maps dont support any kind of layering.

Button "Add New Group" should be located between combo box "View Mode" and "Edit Properties". On your screenshot I can see only blank space - is there any error message in your browser (probably related to JavaScript error)?

Hi, there can be various reason for slowness of your system so it is difficult to invastigate it without further details. But there two obvious problems in your system: 1) RAID 5 is not recommend for data storage because it is very slow, we recommend to use RAID 1+0 for data storage disk (or better say for all disk you…

Hi, these stored procedures usually requires @id parameter which identifies entity (node, interface etc.). You must call given procedure for every entity (you can do it in database cursor). Here is brief description: For ResponseTime procedures you must call procedure for each NodeID from table Nodes (if stored procedure…

Hi, it can be for various reasons. First of all - is there any node with MachineType = 'Cisco 3845'? You can check it by executing this query: SELECT NodeID FROM Nodes WHERE MachineType = 'Cisco 3845' If there are some results then you should check data in ResponseTime view. You should start by elimination of unnecessary…

Hi, this is probably related to SQL meaning of operator "not equal" and NULL. If some column has NULL value (blank) then comparison this column to any value is always defined as FALSE. Sometimes it can be weird for people outside database world. If you set it to condition 'is empty' (what you have done) it is equal to…

Are there any additional details for this error? Which version of NPM do you have?

Hi, there can be some places wher old address would be stored. If you say that this is cause by Information Service I would recommend you to check table Subscriptions in Orion database. Following query can be used: SELECT [EndpointAddress] FROM [dbo].[Subscriptions] If you see your old IP address in result then given…

Hi, you are right, this is SQL Server error. What is even worse is the fact that this is very probably IO error (that means hardware error). I would recommend you to start repairing your DB as soon as it is possible. Of course first you should check status of your hardware and if there is something wrong just use new…

Hi, performance issues can be caused by many factors. What about average load on servers? Does it seem to be issue on application server or on database server? Do you have any table with lot of data (Traps, SysLogs etc.)? Do you have lot of groups (let's over 100)? From slow web page it could seem like slow database or…

Hi, what about to set rediscovery interval for given node to very high value? By default it is set to 30 minutes, so if you set to something like 1 000 000 minutes it could work.

Hi, which process/service has highest CPU utilization?