LadaVarga

Hello, in CustomPollerStatus you have only currect status. You have to use "customPollerStatistics" table. SELECT Nodes.Caption AS NodeName , cp.UniqueName AS Poller_Name , cl.Label , Nodes.NodeID , cs.Status AS Status, cs.datetime FROM Nodes INNER JOIN CustomPollerAssignment ca ON (Nodes.NodeID = ca.NodeID) INNER JOIN…

Hello, After submit changes in Custom table you will see Time period in report layout.

Hello You can try this SQL QUERY. It is modified availability and response time report. This is Last day report. DECLARE @StartMaitenance as datetime DECLARE @EndMaitenance as datetime SET @StartMaitenance='2013-2-24 20:22:35.233' SET @EndMaitenance='2013-2-24 21:22:35.233' SELECT TOP 10000…

Hello, 1. Do you have installed our app in some of your ServiceNow instance. 2. Is the instance added to NPM? 3. Do you have Alert Action created? Do you have only one Short Description in ServiceNow? If more you can try find more properties when you click "Select properties" in action definition. If Short description…

Hello Do you see Node custom properties when you pick Columns in Custom Table?

Hello Jfrazier, One of similar issue was fixed in NPM 11.5.2. I recommended update to 11.5.2. NPM 11.5.2 RC1 is in the customer portal. Is this the fix for the custom properties and removing nodes issues? Lada

Hello, In 10.4.2+ we introduced asychnchronous loading of resources, that mean whole page is not refresh. Play sound for alert play only after refresh if there is some new alert. I recommended workaround: 1. In web settings set page reload for example to 2 min. 2. Open Alert page and stay open. This page is reloaded…

Hello thodge_1, Probably best solution would be filter all esxs. 1. Click edit on Top xx resource. 2. In filter add: Vendor<>'VMware Inc.' or u can use this filter: MachineType<>'VMware ESX Server' 3. Submit All Vmware esx. should excluded from the resource.

Hello Fred Lipton, Every report has problem with exporting to csv in Vb6 Report Writer application? Is possible recreate that report as Custom Table resource? thanks

Hello ecklerwr1, Please don't click execute query after you changing rows in table. Right steps should be: 1.Click: Enable table editing. 2. Uncheck record columns. 3. Click: Enable table editing again 4. After that you can execute query to check if everything is ok: SELECT TOP 1000 * FROM [dbo].[EventTypes]

Where did not work? I tried in Advanced Alert manager and create Alert action: Send meesage to netperfmon log and it is working. Write it some error?

Hello, Could you please try SQL variable: ${SQL:SELECT TOP 1 I.IPAddress FROM NodeIPAddresses as I join Interfaces as inter on I.nodeid=inter.nodeid and inter.interfaceindex=i.interfaceindex where inter.interfaceid=${InterfaceID}} Thanks

Hello You can create SQL script which can be run every day via task scheduler in the server. I think SQL studio has such function. Best solution will update "acknowledged' collumn in events table. I don't recommended delete that events. Example: UPDATE Events SET Acknowledged=1 where Message = 'message' Use wisely, backup…

Hello, Do you need exact limitation or only type of limitations? With exact limitation + title of homepage: select AccountID AS UserID, AccountEnabled AS Enabled, MenuName AS MenuBar, AllowAdmin AS Admin, AllowNodeManagement AS Manage_Nodes, AllowCustomize AS Customize, AllowReportManagement AS Manage_Reports,…

Hello Try add new Custom chart resource and create from scratch. Probably in first attempt you didn't define ${FromTimeUTC} macros. Known issue.

Hello, You can use only use SCOM management pack which show particular data from NPM in SCOM. Other way is not implemented. Lada

Hello, You can use Escallation level feature in Trigger action tab. 1. Go to Trigger action tab. 2. Add new escalation level (set 10min), 3. Add appropriate action. Alert will be triggered -> execute action -> If alert will not be solved under 10min it will send another message. You can of course set more escalation…

Hello, Can be done via SQL script UPDATE against Pollers table. What do you need: Interface ID Disable interface statistics poller where interfaceid=406. UPDATE pollers SET Enabled=0 where netobject='I:406' and pollertype like '%statistics%' Enable interface statistics poller where interfaceid=406. UPDATE pollers SET…

Hello, 1. Go to the advanced configuration page: http://ORIonAddress/Orion/Admin/AdvancedConfiguration/Global.aspx 2. Raise the limit on this setting: IncidentsCreatedThreshold 3. Save it. Lada

Hello, Do you have any nodes/volumes/interfaces on new database? If not, you can simply point new NPM Configuration wizard to OLD database. It will create new tables etc. according your needs. Backup OLD database before doing any action. There is document, which can help you:…

Hello, Yes, we support MSSQL (not MySQL) Server 2014 from NPM 11. http://www.solarwinds.com/documentation/orion/docs/releasenotes/releasenotes.htm Lada

Hello ttl Could you please uncheck "VMware Polling Settings" and check it again. It should appeard adding credentials dialog:

Hello Svindler, 1. Open report in report writer. 2. Click on "Report" in Main menu. 3.Click "Show SQL"

Hello, Only way how non-admin user can see Custom chart/table with Custom SQL/SWQL datasource is use Custom SWQL instead of custom SQL. It should be easy to rewrite. One other note: Use ${FromTimeUTC} instead of ${FromTime} because application statistics is in UTC time. Something like this: SELECT…

Hello, Yes, there is a way. The secret lives of web-based reports Lada

Hello dsla, In ServiceNow you have Configuration your closed states. What you can do is: 1. Go to the ServiceNow to Solarwinds Integration 2. Set the right Closing states. 3. Every time the new action will be executed and some old incident is already created it will checked if that incident is in Closing State. If yes, it…

Hello, Is still these variables working in the new alerts? If yes, Ill not touch them, there is backward compatibility for old macros. Migration can be done only by SQL script. Lada

Hello, In 11.5+ we moved alerts to SELECT TOP 1000 * FROM [dbo].[AlertConfigurations]. If you like to know what happend in the history you can use (NPM 11.5.2 is mandatory) - SELECT TOP 1000 * FROM [dbo].[AlertHistoryView]. If you like to know when was node added, application added, you can use Custom Table in Reporting…

Hello, From NPM 11 you can use Custom Table and Custom Chart as normal resource in the page(view), You can add same Custom tables and custom charts to the view. Lada

Hello, What do you want to achieve via SWQL? Put query here and we can look. Unfortunately there is not easy way how to do that via SQL. Only way is create bunch of select and UNION results or use CASE. Lada