PavelSrot

It depends whether you want return just duplicate or also what is not duplicated. If you want to return everything remove from query clause HAVING (COUNT(*) > 1)

Here is modified sql query from msawyer which should include everything what you need. Reason why non are listed more than one is because in query is Group By clause and it is intention not to display it more. SELECT Info.*, V.VolumeSpaceAvailable, V.VolumeSize, N.TotalMemory, N.MemoryUsed,N.CPULoad FROM ( SELECT…

It looks good. Anyway Nodes.Site is probably your custom column, because on standard NPM instalation is not present and if I will not remove it from SELECT query I get errror. Otherwise it seems, that it produces correct results.

Here: http://knowledgebase.solarwinds.com/kb/questions/3202/ is described how to turn on automatically defragment feature during database maintenance within Orion.

I would suggest try to install Wireshark or any other packet sniffer and try to catch communication between computer where run Orion (Report Scheduler) and your SMTP server. In report scheduler try to execute job manually (right mouse button and from popup menu select Run Selected Job Now). And consequently try to examine…

Hi networkspy, Rename c:\inetpub\SolarWinds\ folder to let say SolarWinds2. After rename you will need to edit file c:\Program Files (x86)\SolarWinds\Orion\ConfigurationWizard.exe.config. In this file you will need to change <add key="PrecompiledWebsiteDisabled" value="false" /> to <add key="PrecompiledWebsiteDisabled"…

Here is little modification in my previous query. This should now works SELECT EventsTime.NetObjectID,N.Caption, DATEDIFF(hh, EventsTime.DownTime, EventsTime.UpTime) AS [Hours], DATEDIFF(mi, EventsTime.DownTime, EventsTime.UpTime) % 60 AS [Minutes] FROM ( SELECT E.NetObjectID,E.EventTime AS DownTime, (SELECT TOP 1…

Can you when you are able to reproduce this one open web console (in IE or Chrome it is F12 key) and try to do export again and observe whether you will se in webconsole any javascript error? If so let's post it.

It can be also caused by, that if for longer time anyone don't access to website, IIS worker process will shutdown. You can eliminate this by increasing Idele Time-out for application pool via Internet Information Service Manager Concole (Advanced Settings... on selected application pool).

I had on mind that if you create website (meant files in c:\inetpub\SolarWinds) and for first one access by using browser to Orion, IIS will need to start compile process. Optimizing website ensure, that it will not be needed because it will be done during running Configuration Wizard.

Yes, I had on mind username and password

I would suggest look at UDT module into Orion. This modul can in detail tell you what users are currently logged in specific node.

Here is how it would look like to limit it to 7am to 7pm, Monday to Friday SELECT E.NetObjectID, E.[EventTime], N.Caption ,E.[EventType] FROM [dbo].[Events] E INNER JOIN [dbo].[EventTypes] ET ON [ET].[EventType]=[E].[EventType] INNER JOIN [dbo].[Nodes] N ON N.NodeID=E.[NetObjectID] WHERE E.[NetObjectType]=N'N' AND…

I saw it once and by deep investigation I found, that it sometimes can happens when Orion server is under low available system resource or bigger load. Sometimes when is very huge amount of recources on view. This bug is caused by current version of EO.PDF which is used as 3d party component for exporting web page to pdf.…

Label BYTES PER SECOND is not computed from data as for example 400.00 Mbps, but it is statically defined for given chart and his purpose is just inform you what values on y-axis represents.

Ok. I have uploaded file NodeDetailsByIPAddres.aspx which should work. I had placed this file in my website in c:\inetpub\SolarWinds\Orion\NetPerfMon\Resources.

And what about try to backup database and remove from page lot of other resources and try to let there some chart resources. It maybe help to find which resource cause performance issue. Or first remove from view all chart resource, try to refresh and check how quick refresh was and gradually start adding one chart from…

Couldn't be it caused because this one?: 16 Mbps – it’s a real AVERAGE of Max values (like AVG(InterfaceTraffic.In_Maxbps) 54 Mbps – it’s a real MAX of Max values (like MAX(InterfaceTraffic.In_Maxbps)

Can you try first execute this query: SELECT TOP 1 E2.[NetObjectID], E2.[EventTime] FROM [dbo].[Events] E2 WHERE E2.[EventType]=2 -- up and then SELECT TOP 1 E2.[NetObjectID], E2.[EventTime] FROM [dbo].[Events] E2 WHERE E2.[EventType]=1 -- down and try to find out whether if they have minimally one common NetObjectID? And…

Exactly. Tabs such as Home, Network, Virtualization etc. are created by installed modul. If you instal other module e.g Orion application monitor, you will se next tab Application. It isn't intend to let user customized this main tabs.

You can do it via adding custom property. Go to custom property editor and there you will see e.g. Availability_Marker, Availability_Annotation for availability chart. If you will specify this properties for nodes you will see on chart line which will be named by value specified for Availability_Annotation, property which…

I have already created ticket for it and now it is on our PM to decide when we fix it.

Yes. In the case that you from some reason need to split server load from reason to increase performance, because you will have big amount of data and you will poll very much amount of device it is good option to install database on dedicated server. You can also do tuning on SQL server where you will have temp database on…

Also KB2840628v2 and KB2858302v2 are culprint of this one.

If you need printable version of website you can add parameter Printable into url with value true. Here is example what I have on mind: Orion/SummaryView.aspx?viewid=1&Printable=true

But what is state under link you provided don't solve situation when you into address bar in browser type name of server without https.

Purpose of optimizing website is to compile all website project and therefore if you will first acces to website no compilation because first attempt will not be done and it should speed up first accessing to website. You have right that before 10.4 it wasn't present, because we added it to 10.4.

I would suggest little refactor your code to this one: <style type="text/css"> #MySearchDiv { font-family:arial; color:#FFFFFF; font-size:10pt; font-weight:bold; padding-top:3px; } #MySearchText { font-size:10pt; } #MySearchProperty { width:100px; font-size:10pt; } </style> <div id="MySearchDiv">Find <input…

If you look above in this post you will code that I posted in this thread which looks as folowing: using (SqlCommand command = SqlHelper.GetTextCommand("here will be your sql command")) { object objResult = SqlHelper.ExecuteScalar(command); // in the case that result is scalar value var table =…

For not to worry about what username and password to access to database are you can use sql helper class which is present in Orion. using (SqlCommand command = SqlHelper.GetTextCommand("here will be your sql command")) { object objResult = SqlHelper.ExecuteScalar(command); // in the case that result is scalar value var…