christopher.t.jones123 · CRIS Solutions Architect/Engineer · ✭✭✭✭✭

@"tasmar1985"is this what you're trying to accomplish? SELECT Count(n.UserName) as [Total Clients Using] FROM Orion.ASA.RemoteAccessSessions n WHERE (ClientInfo LIKE '%AnyConnect%') and (ClientInfo LIKE '%4.8.01090%') UNION ALL (SELECT Count(n.UserName) as [Total Clients Using] FROM Orion.ASA.RemoteAccessSessions n WHERE…

@"tasmar1985", can you post the query that your screenshot is using? It has the framework for what you want, we just need to modify it to do counts and then some unions with the various conditions. Below is probably close to what you're looking for Select Count(AnyconnectUserName)as [Total Clients Using], '4.9.0.5042' as…

@"aldo56", you can download them from Thwack to a system that does have internet access, then use the import/export template functionality to get them into your system. Here are instructions on the Import/Export

@"jgoetsch", I believe this would be a good place to start for reviewing where it gets this data. I think its the one fore Cisco Smart Advisor as a starting point thwack.solarwinds.com/.../283559

@"km3000", using SAM and if the port is TCP you could use a TCP Port Monitor component to achieve this. you define the endpoint and the port you want it to test for. documentation.solarwinds.com/.../sam-tcp-port-monitor-sw3317.htm

@"mpepprell", what you are describing is a perfect use case for containing these 3 vCenter's into a group and then using SWQL to display that group. If you do it this way then SolarWinds will do all the status roll ups for you in the background and you dont need to worry about that stuff when choosing to display it.

@"rkrish01", I would highly recommend that the you connect to the DB’s initially with an account that has SA privileges just to rule something like that out. You should only need it for the screen of the config wiz where you define the DB connection information for each DB. I’ve found that for upgrades of this degree this…

@"miketartaglia", I've seen this before when I was messing around with VEEAM, met all the pre-reqs of having the VEEAM PowerShell module installed on the polling engine but everytime I attempted to use it in a component monitor it would just fail with the same error. I got around it but just doing an invoke-cmd to the…

@"mcoyle001", have you tried to change the URL's in the application monitor from ${IP} to the FQDN of the server?

@"lcsw2013", My recent experience was that we were experiencing deadlocks on a particular procedure that ran in relation to VMAN. I was hesitant to upgrade as well, so I stood up a lab and made the load roughly the same, and ensured I was able to replicate the issue in my lab environment as well. From there I conducted an…

@"miketartaglia", to see the count variable in Orion just include it in one of the outputs. For instance, in the output where it keeps ending in 0 include something like "return count is $count" in the message so you can see what its returning.

@"faizan_123", does this help? I turned the left join into a subquery that then joins directly on the membersnapshots table to give it a valid column to join aganst. Everything regarding the output of the group count is done inside that area. Anything regarding the scope for the nodes is done outside of it. Might still…

@"jfoudy", yes that is a known issue. It looks like its fixed in the next release, been using this version because of the exact problem you are describing.

@"faizan_123", can you show me the two query outputs and a description for them so I can get a better idea of the criteria. This will help me try and develop a similar use case I can use to hopefully build a query that accomplishes what you're asking.

@"miketartaglia" this is making me think that the above portion of the script is not functioning correctly so the $count variable never gets populated the way you intend it to. Have you turned on debug logging for this component and looked at those logs to see if it indicates that it's not functioning as intended? if…

[quote userid="268945" url="~/product-forums/the-orion-platform/f/forum/90236/powershell-scripts-and-component-montioring/287915#287915"]if (test-path -path c:\scripts\messagebody.txt) { #Remove-Item -Path c:\scripts\messagebody.txt #-WhatIf }[/quote]@"miketartaglia", have you tried commenting out the above lines?

@"miketartaglia", what is the error message or the values it is returning that indicate it is not working? And from the test what are you expecting it to do, for instance, you know that it should be returning critical because the condition exists. It'll also be helpful to see the whole script to add context to what is…

@"miketartaglia", when you are testing it within SolarWinds which are condition are you expecting? if its the else portion change the Exit code to 3 (warning) or 4 (critical). Using exit code 1 will cause the component to display as down but as a failed script execution.

@"faizan_123", im not the greatest so i'm fairly certain there might be a better way, but I was able to come up with the following. Is this what you're looking for? SELECT count(a.name) as [Total Apps], count(t1.applicationid) as [SolarWinds CP Applied], (count(a.name) - count(t1.applicationid)) as [SolarWinds CP not…

@"mat12", when you open the script up in ISE and run it, can you just have it return $Status.status to see the raw value its returning?

@"makecrazy", if you scroll down that list you should see a custom option. Once you select it a pop up will appear allowing you to define a different relative time period. Should look like below

@"mat12", I think I see what's going on but it would require some testing. What I believe is going on is that its returning a value that is not recognized and setting it to zero. in order to be sure we need to see what is being returned for $Status.status. Are you able to run the script locally on the polling engine and…

@"jagrsvoip" Yes, all other authentication methods will work provided they are defined, so a local SolarWinds account will be able to log in regardless of IDP availability. If an IDP is unreachable then SAML authentication will not work

@"mat12" can you post a screenshot of the differences between the Microsoft Service Health Dashboard and the SAM template, I just ran a test in my environment using the same template, and everything I'm seeing lines up with what is returned. There might be some tweaks that need to be made to align with what Microsoft…

@"w3498-deebcg37nbt84eqn", the defined user account permissions will take precedence. You can always tell where a user is getting their permissions, when the user logs in in the top right corner the "Logout" link will display their user name, if they received permissions because being a member of a group it will also…

@"ZombieEtiquette", you can mass edit Alert Actions of the same type, which would probably be a little safer than doing a direct DB edit. Just select all the offending Email Actions and update them to the appropriate values, you can also use variables so that they pull them from the Default Send Email Action Page. Should…

@"mwenda" when the RTCD fires it will include the changes detected by default in the email. Is that what you're looking for?

@"jandre" here's the link for the SolarWinds API/SDK there are tons of docs and examples on there as well. One thing to note is that your versions are pretty far back, to take full advantage of the API you should consider upgrading (not to mention the security enhancements that come with it).

@"Jason_TF", there's actually an out-of-the-box alert designed to go out and retrieve the top 10 processes when the alert triggers. Essentially the logic is that when CPU meets a defined threshold it will launch real-time process explorer and obtain the top 10 processes utilizing CPU, so instead of burning polling cycles…

@"dhinagar_j", if your identity provider is already synced with your AD you should be able to use the existing groups just added in SolarWinds as a SAML group instead of an AD group. The format for the group can be a little tricky, the UPN format has the most success groupname@domain.ddd, but I have seen in the past where…