Comments
-
The World map is fantastic easy to load new objects, remove objects and integrates well with Group these then tie in well with custom properties. Zooming is good, loading times are also good. i use this world wide map for grouping impacts of nodes and reflecting status of the group via a 'impact' custom property for both…
-
try this out dude SELECT NODE.ID as NODEID, NODE.Caption AS NODE, FROM Orion.Nodes NODE WHERE caption like 'AMX-VZB-%' ORDER BY NODE.Caption
-
yo, there are allot of variables that can be at play here here are some solid links to help you.. Quick Orion database health check guide - SolarWinds Worldwide, LLC. Help and Support Antivirus directory exclusions for NPM - SolarWinds Worldwide, LLC. Help and Support some of the MVPS have also put a check list of what to…
-
Could also depend on the query some larger queries can take an awfully long time to execute. Try seeing 'TOP' 5 and use the 'group by' functions if possible. You should also consider the amount of resources that you have loading into a single page and the amount of users that concurrently use the platform this may reduce…
-
nicee, didn't think of doing this type of alerting i just use Custom Properties for this but this actually makes sense if you relay on engineers to update custom properties. Here is an example of checking all nodes that are 'down' and are in an IP address range.. select * from nodes n where ((n.status = 2 )) AND…
-
new upgrade is amazing. only thing from the upgrades is that the .net framework 4.6.2 is needed and it rebooted my system without telling me lol apart from that very awesome
-
why not use the 'NOT LIKE' ? so something like: select Caption from Nodes where Caption NOT LIKE 'SVRE-NL' cheers, Dan
-
HI JonnyG, did you manage to find a way to do this?
-
HI aqeel73 Some time ago i created this, could possibly help you this report will report on 'Fixed Disk' Volume Report - Fixed Disk - Available - Size - Used - overall volume capacity with Thresholds
-
Good Day Solarwinders, My company currently uses 365 and were also getting the same Error Processing E-Mail, did you mange to find a fix for this and if so how did you manage to resolve the issue in the end?
-
Hi, and welcome You could also take a look at the eLearning resourses NPM : Success Center NTA: Success Center If you have already purchased your license you can access the virtual class room on here: Virtual Classrooms | SolarWinds Customer Portal these classes are actually very good specually for starting out
-
Your going to find all your answers right around here: Uncovering Polling Problems and Issues in Your Environment
-
bump
-
couldn't agree more
-
Try adding in the Join SELECT NodeName AS [Node Name], '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name], DetailsUrl AS [_LinkFor_Node Name], MAX(ToLocal(Nodes.UnmanageFrom)) AS [Unmanaged From], MAX(ToLocal(Nodes.UnmanageUntil)) AS [Unmanaged Until] FROM Orion.Nodes INNER JOIN…
-
This should give you the information you need its to do with the polling interval Why isn't Solarwinds joining the dots on my graph
-
select ac.Name,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:'+ToString(AlertObjectID) as [_linkfor_Name],EntityCaption as [Trigger Object],EntityDetailsUrl as [_linkfor_Trigger Object],case WHEN RelatedNodeCaption=EntityCaption THEN 'Self'When RelatedNodeCaption!=EntityCaption THEN RelatedNodeCaptionEnd as…
-
you could opt for the simple way and add a 'user links' widget and link the web Url this way..
-
looks like the default MIB doesn’t include the pollers for cpu/memory for the NetScaler device. you can manually assign pollers from the thwack community or alternately you could create your own for cpu and mem as a workaround. here is more information on the thwack method: Using THWACK community pollers for example once…
-
give this ago: SELECT NodeName AS [Node Name], '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name], DetailsUrl AS [_LinkFor_Node Name], concat(SUBSTRING(tostring(MAX(e.EVENTTIME)),1,4),SUBSTRING(tostring(MAX(e.EVENTTIME)),5,2), SUBSTRING(tostring(tolocal(MAX(e.EVENTTIME))),12,8)) as Downtime,…
-
HI jmp99 Hope this helps you if you have any questions please ask Volume summary report - Fixed Disk - Available - Size - Used & overall volume space
-
so very close, this should do the trick.. SELECT ADDDATE('HOUR',-7,AlertHistory.[TimeStamp]) as "Time" ,AlertObjects.TriggeredCount as "TimesTriggered" ,AlertHistory.Message as "Message" FROM [Orion].[AlertHistory]inner join [Orion].[AlertObjects] on AlertHistory.[AlertObjectID]=AlertObjects.[AlertObjectID] WHERE…
-
Here is a example of the group creation and member assignment:.OrionSDK/Groups.ps1 at master · solarwinds/OrionSDK · GitHub
-
I agree this would be very a good addition to SolarWinds, as a workaround I use a sam component that simply counts the number of offline nodes and message to tell me what is offline..good to know that maraki has now included this in the API.. $AllProtocols = [System.Net.SecurityProtocolType]'Ssl3,Tls,Tls11,Tls12'…
-
Without getting to crazy and going over board with SQL/SWQL, You could create Custom properties like Impact Summing like, n_impact, so your High impact Device you could have a delay for 5 mins then Medium 10 mins then Low 30 mins for the less significant devices, for example. Means 3 alerts which is annoying. You could…
-
Hi, At times WMI is actually pain, when i run into issues the first place i generally check is that the WMI service on the remote server is Enabled and Running, secondly i would check the remote server has the correct WMI access privileges, on the remove server. Connect to the wmimgmt.msc select security > root > CIMv2 >…
-
hey, you can group views by Custom properties and build your limitation on the custom property. you will need to log on to the primary soalrwinds server and open 'account limitation builder' then on your view select edit and select the CP you will have to play around with the accounts and nodes details views OR id probably…
-
Hey, i have also tried what you did and cant use 'OR' 'AND' or use the pipe incase that worked.. but nope.. this sounds like a good candidate for a feature request id def vote up Realizing it didn't work.. i decided to make my own 'search' feature lol using SQL below, it simply check configures over the last 7 days and you…
-
in SWQL you can find the CLI polled data here: SELECT NodeID, ObservationTimestamp, ConnectionsInUse, FailedConnectionsPerMinute, WeightFROM Orion.ASA.ConnectionStatistics in SQL (Table) SELECT TOP (1000) [DateTime] ,[NodeID] ,[ConnectionsInUse] ,[FailedConnectionsPerMinute] FROM [ASA_ConnectionStatistics_Daily] SQL (View)…
-
Cheerskasaff This will come in use full thanks for thwack members that might not know where this is as well select * from AlertHistory