pat_m

Looks good will try it tomorrow. Thanks Pat Sent from my Verizon Wireless 4G LTE smartphone

WOW! Thanks I am looking into it right now.. -Pat

Thanks Again, Problem solved. -Pat

Thank you save me a lot of time. -Pat

Hi, Has this feature been put into production orion yet???

Thanks Janene16 you were correct. I called SolarWinds support and that is what we did. -Pat

This should do what you need SELECT Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, Nodes.CPULoad AS CPULoad FROM Nodes WHERE ( (Nodes.CPULoad >= 0) ) ORDER BY CPULoad DESC

Can you query directly from the PrimaryContact attribute. Some like this just fill in part of a PrimaryContact name between the percent signs SELECT * FROM [dbo].[VIM_Hosts] Where PrimaryContact like '%%' Does it return data? -Pat

Thanks Johnny, I did set it up but could not test it, I am glad you have alerted me to this. -Pat

Thanks guys for the help.

Thanks Alex, I have been out sick. I will try this tomorrow and let you know the results Pat

Thanks everyone, you all are very helpful. -Pat

Hi, Great guide, can I achieve this on a single server and if so, how? Thanks,

Under the reports there is a Admin Audit log records these types of changes.

Thanks JROUVIERE We are running 8.3.0 and seeing this issue. Thanks, _pat

Thank you Steven and Borgan it did the trick .I never knew about the unmanage scheduling Utility. -Pat

I guess it is just an error in the web console.

I have figured it out as the machine in question was place into the wrong node.

Thanks James, looks like it should do the trick. -Pat

Hi we have a similar alerting scenario, so what we did was create a Dl in exchange and on a weekly basis we put the on call engineers cell number in it as a sms contact. This way when a critical alerts fires it sends to the dl and admins on the list get the email and the on call engineer gets the text message to their…

I figured it out. If anyone is interested here is the SQL SELECT TOP 10000 DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()) , AuditingEvents.TimeLoggedUtc) AS Time_Logged_Utc, AuditingEvents.AccountID AS Account_ID, AuditingActionTypes.ActionType AS Action_Type, AuditingEvents.AuditEventMessage AS Audit_Event_Message FROM…

Hi go into report write select a historical report of the resource you are looking for and under time frame change the dates to what you need.

Thanks for the help I have opened a ticket with support and it is a issue with how the environment has been configured along with a bug with Solarwinds.

Thanks for the ideas. It ended up being a license issue. Thanks, -Pat

I have checked both options you suggested and both are good. No table size or space issue's. Thanks, -Pat

This is the error. We are not using the built in SQL express, but a regular MSSQL DB. I will double check both the DB configured size as well as the volume. Here is a screen shot of the error

Hello https://solarwinds.xxx.com/Orion/SummaryView.aspx?isnocview=true this returns a NOC view that we just created as a work around https://solarwinds.xxx.com/Orion/SummaryView.aspx?isnocview=true&ViewID=318 this link returns the error above. Thanks, -Pat

Hi, There is a tool that Solarwinds offer which is a upgrade advisor. It shows you what you can upgrade and what you need to upgrade in order. https://customerportal.solarwinds.com/support/product-upgrade-advisor Pat

This is a great idea, I am sorry I don't have a solution but I want to watch this to see if it is doable and how. -Pat