Seashore · Solutions Architect · ✭✭✭✭✭

Thanks Yum for everything you have done here and good luck on your next journey!! 

Hi Created a query for a widget to get you started: SELECT N.Caption as [Node Name] ,CONCAT(YEAR(NCP.Warranty_End_Date),'-',Month(NCP.Warranty_End_Date),'-',Day(NCP.Warranty_End_Date)) AS [Warranty End] ,DayDiff(GETDATE(),NCP.Warranty_End_Date) AS [Days Left] ,N.DetailsURL as [_LinkFor_Node Name]…

or check this link: https://support.solarwinds.com/SuccessCenter/s/article/PowerShell-script-error-Connecting-to-remote-server-x-x-x-x-failed?language=en_US 

Hi and welcome! Orion can monitor both, does not matter. The question is where you use these certificates. If it's only on a website you can use either a HTTPS component. If it's IIS webserver you can also use the AppInsight for IIS. If you want to monitor all certificates on the windows server you can do that with some…

Tested this out and get the same as you. What confuses me is that it works without join. You are comparing an INT with a Datetime...

As far as I know there is no history table for a nodes mac addresses in SAM. 

One way of handling this that I like is to set when a custom poller is critical, then create an alert for when any custom poller is critical. Under Settings / All Settings / Custom Poller Thhresholds Find your poller in the list to the left, mark it and set the threshold you want (choose if it is a text or numeric value)…

Hi Stuartd Sorry about the comma. Above alert script assumes we are trying to do a backup every night. Alerting if backup hasn't worked for 2 days. Not checking the job status, but if we have a successful backup attempt (could be that we don't do backup if there is no change, therefor checking for an successful attempt) .…

Hi I use below query as a custom SWQL alert, seem to work: SELECT Nodes.Uri, Nodes.DisplayName, FROM Orion.Nodes AS Nodes INNER JOIN Cirrus.Nodes AS NCM ON Nodes.Nodeid=NCM.CoreNodeID INNER JOIN ( SELECT CA.NodeID AS NodeID, MAX(CA.AttemptedDownloadTime) as LastBackup FROM Cirrus.ConfigArchive AS CA GROUP BY CA.NodeID…

When viewing the application in orion press "edit application montitoring" (if button does not exist you are not SAM admin) In there, expand the component configuration and look for "Credential for moniotirng". Each type of component can differ in how it looks. The credential name here is not the same as for nodes. You…

Do you have any application monitoring against server1 that use that service account?

You can on each node press "edit node" and change what credentials that node is using: If you go to "Settings" / "all settings" / "manage windows credentials" you see all stored windows credentials and can change a "named credential" that nodes use. you can also see how many nodes that use each credential. 

Hi @"ankitaja" The first thing orion tries is to ping the node. If you got a fail when adding a node, try that manually from the orion server. If that works another thing to remember, if the monitored node is not domain joined you must change a registry…

You could ask SQL how much free space there is. This might be helpful: blog.sqlauthority.com/.../

Agree, somewhere the name of the "widget-type" should be stated. Frustrating when you can't remember what one you used.

Hi I would probably use a custom SWQL alert for that. Don't have the code for it now but check this post i did some time ago. It has a query with the data you want I think, or can give you a hint:…

2 HA licenses, one per server. (IF you want both of them to be HA)

Hmm, seems like that. Instead of options to choose it states all will be fixed. Interesting. Anybody know why?

Hi @"k1gaudineer" I created this query and post some years ago: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/35412/list-dependent-nodes-in-alerts The big issue is that you don't know how many levels of child-parents there is. This should solve this and present it nicely. Hope it's…

Are you sure you installed the cmdlet to "all users" and not only "current user"? Think you should find the cmdlet binaries herre if correct: C:\Program Files\WindowsPowerShell\Modules

I don't monitor any Azure SQL dbs so might be the wrong guy to answer but it's still a SQL, you can ask SQL queries against it also. So depending on what you actually WANT to monitor, I think the approach could differ. Personally I would go for a combination of SAM powershell and T-SQL queries.

On any summary view in orion, customize the view and add a widget, choose a "custom query" widget. Edit the widget and add the SWQL code. https://support.solarwinds.com/SuccessCenter/s/article/Use-Custom-Query-to-show-Node-Name-and-IP-Address?language=en_US 

yes, 0 databases has NOT been backed up last 24 hours. Thats good. Alert if that value is greater than 0.

If you mark/highlight some part of the SQL code and press execute it only runs that part. Try not to hightlight any text and run the whole query. 

If you are using Appinsight for SQL and want to show that info you can use below queries to create a "SQL DBA view". Add three custom query widgets and paste below SWQL code, three parts: -- Failing SQL Jobs (and currently running) SELECT S.FullyQualifiedName,J.Name, J.LastRunDuration, J.Lastrundate, s.DetailsUrl, CASE…

I use below script to monitor SQL Agent jobs. It shows how many jobs with name starting with something that has failed. Output shows nr of failed jobs and what jobs that fail. Alert if statistics>0 or whatever suits you: -- Looking for job steps that have failed, not complete jobs. -- Must edit Searchfor declaration in nr…

Really hope you don't :-). No, I think that is something else, not how much is needed. The change above can be done without interfering with production by the way. I definitely thinks your 45 GB disk will be enough.

Ahh, stupid me. The answer was in the first post. The four tempdb files are now 2304 MB (initial size) and they have a maxsize of 2304MB as you see below in yellow. Meaning they are not allowed to grow. From the query you got from me and ran you see they are almost empty now (space_used_mb) but sometimes they are heavily…

See https://thwack.solarwinds.com/product-forums/the-orion-platform/f/forum/90222/lost-widget-coloured-bars-since-upgrade-to-2020-2-5 confirmed bug.

Might you be using SQL Express? Hitting the 10 GB per database limit? You get that error message then. But temp-db shouldn't be that heavily used then.... If you run below query you can see how much of a database file is used and how much is empty. Most of the time the temp db files should be empty more or less. select…