zzz

Comments

  • It's likely that the data for last month has already been compacted to every 30 minutes. Check your NPM data retention settings. One way to see the exact width is to run a report on the interval with no interval, capturing every data point stored. That way, you can see exactly what data point(s) is being grabbed for each…
    in Interface Availability graph Issue Comment by zzz March 2013
  • This is how the built-in reports do Group by Month. SELECT CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101) AS SummaryMonth, ... GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101), ... ORDER BY SummaryMonth ASC, ... After that, you still need to extend…
    in Generate a report based on each month (not just the previous month) Comment by zzz May 2013
  • Look into NPM_NV_WL_CLIENTS_V That table contains the data for each client and has things like Client_SSID and Client_MAC to help create your table. Restrict LastUpdate to specify the timeframe. Note that I'm not sure how accurate NPM_NV_WL_CLIENTS_V is as historic data. NPM_NV_WL_REPORT_CLIENTS_V contains the throughput…
    in Wireless SSID Report Comment by zzz April 2013
  • When you click customize page, you are changing the layout for all pages that view. The only way to differentiate node detals views is by device type. (ex: all Cisco 2800, etc.) You can set which view is used for Node Details by Device Type on Settings -> Views. HOWEVER, for your problem, there is an alternative. You can…
    in Custom HTML view question Comment by zzz May 2013
  • If you mean in the "Nodes not up" resource window, you'll need to add a filter to it of Status <> 9. (by default it shows warning, down, unmanaged, etc.)
    in Remove Unmanaged Nodes From Down List Comment by zzz June 2013
  • The OR should be an AND. Currently only if the Node is BOTH disabled and Status = 9 (which shouldn't be possible anyway as its status = 2) will be filtered. Note that this alert is possible without using Custom SQL (status = Down, trigger when none -> status = unmanaged, disable=1). Unless you are really familiar with SQL,…
    in Why are my alerts not filtering properly???? Comment by zzz February 2013
  • 1. You can shrink and expand columns, but there is a max length for the columns for the editor. Best way around it would be to copy the table/columns to excel and edit it there. Then afterwards, paste back in the appropriate parts. 2. http://thwack.solarwinds.com/message/185925#185925 3. Why sum of recieve and transmit?…
    in Report writer and custom properties questions Comment by zzz January 2013
  • I am assuming you are going by MAC addresses and if I connect once at the beginning of the month and once at the end, I count as only 1 instance. Remember that Count (without Distinct) includes all the rows including multiple logins, multiple APs, multiple polls/sessions. Here is a simple report that gives the number of…
    in Wireless AP reporting Comment by zzz December 2012
  • It can do complicated SQL SELECT statements- with some restrictions. For one, it doesn't display tables. It'll automatically trunc it to the first entry. (so the first sql will only give the first engineID, while the second gives the node.caption) Unless the table is empty. Then it displays the query, which is what you are…
    in SQL Variable in an Email Comment by zzz January 2013
  • I have made custom views and atlases for use as Display accounts (to be put on a flat screen for the help to view general stats at a distance). For managers/teams of specific regions so that they only see what sites they are concerned with. For myself to test things without disrupting others and as the best solution to…
    in Custom Views Comment by zzz February 2013
  • NTA will use DNS for the labeling of endpoints on Netflow data. NPM will also use DNS for a Node's DNS field. It is likely that one of the netflows NTA is monitoring contained an endpoint for those domains. You can check this by searching for the Endpoint Domain on the search bar for NTA. This will also allow you to…
    in NPM Server doing questionable PTR lookups Comment by zzz January 2013
  • It is probably another alert that is sending the email. It may be another advanced alert, OR possibly a basic alert. You can check the event logs to see which ones are active when the node goes down. It should give you the alert name and grouping (premade advanced alerts are all under "advanced alerts" while basic ones are…
    in Built in alerts - how does it send email alerts when not added as trigger action? Comment by zzz April 2013
  • If the maintenence times are consist, you can set those servers to be unmanaged during those periods with the unmanage scheduler tool. Otherwise, any condition or suppression to fix the issue would likely be more complicated than just dividing it into 2 alerts. (are you really complaining about that?) If you just want…
    in Grouping applications and adding exceptions Comment by zzz January 2013
  • You can just create a object that doesn't check for status but links back to the parent (or wherever really- it's just a link). Just create an object, and in its properties don't add anything to status, but manually set the hyperlink.
    in Network Atlas navigation. Comment by zzz May 2013
Avatar