LadaVarga

Hello, Use "tolocal(AlertStatus.TriggerTimeStamp) as t" in custom query thanks Lada

Hello, If you have NPM 10.6 it is very easy create such report. I recommended create reports with Custom Table and Custom Chart resources. For more information you can look on How to use the SolarWinds Orion Report Writer - YouTube If you have any question don't hesitate to ask. Thanks

Hello, use [external] <> 1 External is some SQL keyword. thanks Lada

Hello ecklerwr1 You can use filter inside Top XX Volumes resource. 1. Click edit. 2.In Filter Volumes fill: Volumes.Caption<>'Cached memory' 3. Click submit.

Hello, With web-based reporting it is very easy. You can create datasource, where can you filter all nodes which are not Polled by SNMP. 1. Select custom table. 2. Advanced selector datasource. 3. Create table (Node Caption, Polling method). Is that enough for you? Lada

Hello, Alert will not be suppressed but all action will not be executed in default. This can be change in Settings-> Polling settings -> Allow alert actions for unmanaged objects. Lada

Hello, The easiest solution would be create table with list of your ipadresses under SolarwindsDatabase. You can use MSSQL managment studio, it is free and you can use UI. After creating IP table you can create SQL report under webbased reporting or in Report writer. 1. Create Table for example: Myips 2. Via Managment…

Hello ouberlord, You don't see anything in Add data series dialog? [SolarWindsOrion].[dbo].[CustomPollerStatistics_Detail].[Status] is nvarchar type. Please retype to int for example: cast([SolarWindsOrion].[dbo].[CustomPollerStatistics_Detail].[Status] as int) as STATUS After adding it. You have to pick time column and…

Hello, Could you please check which tables are the biggest? You can run this query which should give list of all tables with sizes.. Run against Orion database. <span class="kwd" style="font-style:inherit;font-weight:inherit;font-family:inherit;color:#101094;">SELECT</span><span class="pln"…

Hello, 1. Play sound action play sound only from audio output in Main poller. More info how setup in Windows Server 2008 in SolarWinds Knowledge Base :: Enabling audible alerts (Play a Sound action) on Windows Server 2008. 2. Another way is use Edit account and Enable "Alert sound". Open Alerts page in one tab. Every alert…

Hello, We store time in DB in UTC. You have to change your queries I recommended use one of function from this page: sql - Convert Datetime column from UTC to local time in select statement - Stack Overflow After changing timezone you will only change one number in function. I recommended use this one: <span class="com"…

Hello, If you want name of alert it is SELECT stat.AlertDefID, stat.ActiveObject, stat.ObjectType, stat.State, stat.WorkingState, stat.ObjectName, stat.AlertMessage, stat.TriggerTimeStamp, stat.TriggerTimeOffset, stat.TriggerCount, ResetTimeStamp, stat.Acknowledged, stat.AcknowledgedBy, stat.AcknowledgedTime,…

Hello, You can list resources nodes one by one OR Before every change we recommend backup your database. 1. Please download Orion SDK: http://knowledgebase.solarwinds.com/kb/questions/5811/Downloading+the+SolarWinds+Orion+SDK or from here https://github.com/solarwinds/OrionSDK/releases 2. Install it on machine where you…

Hello, SELECT Nodes.Description AS 'Occam Model', count(Nodes.description) as numberofoccam FROM Nodes WHERE Nodes.Vendor LIKE '%occam%' Group by Nodes.description

Could you please try something like this paste to Message in Action: Memory usage is ${PercentMemoryUsed} on serverxyz. Physical memory usage is ${SQL:Select round(volumepercentused,0) from volumes where nodeid=${nodeid} and volumetype='RAM'}%. Virtual memory usage is ${SQL:Select round(volumepercentused,0) from volumes…

Hello It can be done but it looks different. I pick All Disk Volumes Inventory Report and slightly modified it. I added more nodes properties and I added group BY. In your way it should be possible via Custom SWQL or Custom SQL. It this enough for you? Thanks

SET @StartDate = '2012-12-1' SET @EndDate = '2012-12-31' Is it enough for you? If you need "last month" it will be little tricky but it is possible too.

Hello 1. Open report in Report Writer. 2. In Design- General tab uncheck "Group historical data by days" checkbox. Result: Should show historical data in web same as in Report Writer. Have a nice day

Is possible to upload report here. Reports should be located on default path in installation c:\Program Files (x86)\SolarWinds\Orion\Reports\. If not, you can create ticket for support.

Could you please try: Interfaces.Caption Like '*MPLS*'

Hello Sfp, Unfortunately IsServer property cannot be changed, but you can use Node Category and set Server as Node Category. We introduce this functionality in NPM 12.0. 1. Edit that specific Node and change Category. You can change Category for more nodes at once. Lada

Hello, When you click Show SQL in report writer, datetime pick Time frame and recalculate interval of datetime. You can see recalculation after you click "Execute SQL query" in Report writer. Every click datetime is recalculated. Datetime can be converted to float and vice versa. If you use report writer template you can…

Hello, Alert actions are not executed if object is unmanaged by default. You will see alert in Orion, but no email/log/... Can be changed in Polling settings: Allow alert actions for unmanaged objects Lada

Hello gbggri1, You can search via "Manage nodes". Settings-> Manage nodes. There is search button and you can search by IP.

Hello In NPM 10.6 we have not only new web based reporting, but old server-side report writer is here too. Lada

Hello 1. You can use SQL filter and filter only WMI and SNMPversion=3 nodes and group as object-subtype. 2. U can create custom property SNMPversion_nodestree and fill by 3 2 and 0(for others) thanks

Hello, Did someone changes on the system? Could you please try for example Add node or change something on the node (change custom properties) and look to message center to audit events. If not trigger please create support ticket. Thanks

1. Backup DB 2. Restore DB in second location. 3. Install NPM on second location. 4. Connect to restored database with configuration wizard. 5. Via node management move all nodes which you need to new polling engine. 6. Remove nodes and remove polling engines. Notes: Use same version NPM. It is unsupported scenario, but…

Hello, Login page is working? Try use 'localhost' as address.

Hello, Unfortunately it doesn't work. There shouldn't be SQL variable options at all. I created issue for that and we will see what we can do. Apologize Lada