andrew

Comments

  • Looks like that worked! I ran the INSERT INTO command and I got (7122945 row(s) affected). And when I check the NetFlowAddressToResolve table, it started at about 7 million and is going down slowly. The domain names are starting to show up in the NetFlow pages now. This is going to be fixed in a NetFlow v3 service pack,…
  • The CacheExpiration value for all the records is "8/21/2008 11:54:38 AM". That was about the time I ran your query. The only value in the NetFlowCorrelationState is "8/21/2008 1:29:16 PM" (the current time on the server). The MSSQL service is running on the Orion server itself.
  • For anyone else following this or reading it in the future, tonyreel is correct. The only way to do this is to add a seperate syslog rule ABOVE your existing rule(s) that includes "Stop Processing Syslog Rules" and optionally "Discard the Syslog Message". There does not seem to be any way to EXCLUDE syslog messages with…
  • I don't think this worked. I ran the first query and it updated about 7 million rows. Then I ran your second query and it says 0. I tried restarting the NetFlow service, but that didn't make any difference. I then ran: SELECT count(*) FROM FlowCorrelation WHERE Hostname = ''; and that returned "7026560". I have waited a…
  • Yes, that works perfect!!! Interestingly, the query returns 1190 results, but I only have 1151 components according to APM License Summary. I improved it a little bit by adding the server name in there and sorted it. SELECT n.Caption AS Server, a.Name AS Application, cd.Name AS Component, c.Name AS Credentials FROM…
  • So, how would this work? I am running Orion 9.1 and APM 2.0. I need to monitor Windows drive mount points. Ideally I would like them to show up list like normal drive letter disks in Orion. But based on the info in this thread it seems like it can only be done in APM. How do you set that up? Will it show up differently…
  • Thanks. Does that include all the modules or just core NPM? Also, do you support the new SP1 for SQL 2008?
  • Where would I put that? I have tried putting that string into the "Syslog Message Pattern" box in the Syslog alert GUI, but it does not match anything.
  • So, that means it is safe to run "TRUNCATE TABLE FlowCorrelation"?
  • Ok, I resolved the issue by clicking the "Update Report Schemas" button in the Custom Property Editor per the directions in . The Custom Properties now show up on the Orion web site. That is annoying.
  • You know what, you are correct. That query is returning 613 rows, but I have 1,151 components according to the APM licensing page.
  • I always specify it on one line. For example: copy tftp://1.1.1.1/file.bin flash:file.bin That way you don't have to deal with answering the prompts. On another note, I always use ftp or http instead of tftp now. Tftp is a lot slower compared to ftp or http, especially over a WAN.
  • Everything, modules included, will run on Windows Server 2008 and SQL Server 2008. What about 64-bit?
  • I am having the exact same problem. I just opened a ticket with support on this as well (actually opened it before I saw this post).
  • Thank you! That is EXACTLY what I was looking for.
  • Thanks that was exactly what I needed. FYI... you might want to make that more clear somewhere. I could not find it in the documentation and the text on the tab was confusing me.
  • This server is an Orion server, so I tried stopping all Solarwinds services, but it still would not work. Rather than disable all non-MS services and reboot as you suggested, I fired up ProcessExplorer and searched for all file handles with "solarwinds". It looks like the culprit was w3wp.exe (the IIS Worker Process). Even…
  • Interesting. I did not think regex by itself could exclude traffic, i thought it was just for complex patern matching. I want to exclude the text "A.DS2" (without quotes), but include everything else. Anyone know some regex to accomplish this?
  • Has anyone tried this in Orion v9? I added those three files to C:\Inetpub\SolarWinds\NetPerfMon\Resources\3-1-InterfaceDetails, but the "Edit a Custom Interface Property" option does not show up when trying to add a new resource under "Interface Detail Reports" on the Interface Details view.
  • I am having the exact same issue. Did you ever find a solution? How do you "truncate the FlowCorrelation table within the NetperfMon database". Are you talking about just removing all the records from that table? Is that going to cause any data loss?
  • Correction, I had the workingdirectory executablefile backwards in the examples above. I corrected that and still get the same error messages. BTW... your examples are wrong on the bottom of page: . That is what threw me off.
  • The memory issue was discussed in an earlier post. See www2.solarwinds.net/.../topic.asp. The problem was fixed in Windows 2000 Service Pack 4.
  • Any update on this one? I just upgraded from NPM 10.1.3 to 10.3.0 and I received the exact same error. Everything seems to be working, but that error concerns me.