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

@"mickdon", is there a common field that can be used to reference the various groups you want to break them down by? Things like a naming convention, IP Address, or a custom property (this is the most used method for something like this)? If so, then you can add additional conditions to your WHERE statement by using AND/OR…

@"dunky2k", you can use this guide. I've used it previously with pretty good success. In the future you can set the default database drive locations so that when databases are created they will go to whatever you define instead of on the system drive. 

tagging @"acurrent" because I know she recently had a similar issue recently that she was able to resolve by modifying a conf file. 

the latest version installs all the modules and the modules are activated by license activation. In the past you would have had to select the modules you purchased but not any longer. I believe they are probably going to make the download experience in Customer Portal match what reality looks like, they just havent gotten…

@"chad1829", so as an example in the <INSTALL DIR>\Orion there's a DB file named SWNetPerfMon.DB that has the connection info for the main SolarWinds database. Should have the server name, DB, name, and account being used for its connection. It won't have the password unfortunately. but being completely honest you could…

@"jasonf1971", yup at this point id reach out to whoever is in charge of mail to run a message trace and look at the mailbox settings. 

@"jasonf1971", when you simulate it does it show as sending successfully and then you never receive it? to be honest as far as SolarWinds goes it doesn't make any distinction between the two. It is completely transparent to SolarWinds if one is a shared mailbox, a distro list, or a user mailbox. As long as its a valid…

@"BaldFeegle", for that output pairing in the component settings you could change the threshold for the response time statistic to change the status when the response time goes above a certain value, then you could write an alert based on that status change.

@"jasonf1971", are you referring to when a shared mailbox is a recipient it doesn't receive it or if the shared mailbox is the account you have defined as the SMTP account for auth to send from?

@"LatteLarry", you could use Application Name as a scoping mechanism, the name is usually auto-generated based on the Application Template Name.

i'd like to be a beta reader

@"rafa_gp", HA will cover the Main polling engine and the Additional polling engine, BUT NOT the additional web server. Keep in mind that the main polling engine will always have a web instance running on it so you'll never be without a web console you could get to. BUT the additional web server is not able to be protected…

@"borgan", you using an Ansible Tower or AWX instance and trying to do this all within Ansible and use as an artifact in a workflow or something? I've done this in the past by executing a PS script through Ansible that does exactly that and then saves it as an artifact in the rest of the workflow to create the VM with that…

@"rjones-uk", i think you might be able to do it from Orion.DeviceStudio.PollerAssinments

@"rjones-uk", do you see it in Orion.DiscoveredPollers or Orion.DeviceStudio.Pollers?

@"mosikhan", execute this query in SWQL studio. MOST entities follow these to some degree. SELECT TOP 1000 StatusId, StatusName, ShortDescription, RollupType, Ranking, UiOrder, Color, IconPostfix, ChildStatusMap, DefaultIconName, CategoryStatusMap, DisplayProperties, DisplayName, Description, InstanceType, Uri,…

@"mosikhan", Status is usually a a numerical value that the system interprets. Most tables that have a Status column also have a StatusDescription column. The StatusDescription column is in most cases the string interpretation of the Status column, sometimes it'll include additional information such as why, but lately…

@"mosikhan", sure that's where the CASE use case that @"jm_sysadmin" mentioned would be used. He provides a pretty good example as well, so you should be able to review that and run with it. 

@"snorfolk", same thing as @stuartd mentioned in terms of creating the report, but the below query will get you all the data you asked for and format it similarly to what you see on that page. SELECT AC.Name , AC.Description , AC.Enabled , AC.ObjectType , CASE WHEN AC.Canned = True THEN 'Out-of-the-box' Else 'User-Defined'…

@"mosikhan"same way as the color. Add a column to act as the icon provider and then adjust the Icon Mapping setting within the Widget (hint: its right above the color mapping setting). SELECT aa.Node.Caption,aa.StatusDescription AS Status , COUNT(distinct aa.Node.Caption) AS Total , SI.Color ,…

thwack.solarwinds.com/.../intro-to-api-sdk-swql

@"ned692000", additionally you should take a look at this article https://thwack.solarwinds.com/resources/b/product-blog/posts/intro-to-api-sdk-swql 

@"ned692000", so the query used to display the above is quite complex so it'll likely be difficult to breakdown for someone fairly new to SWQL. Using your above query there are some syntax issues. * the StatusLED should be the web directory for the gif, so taking your previous example it would look like…

@"ned692000", so if you're talking about the return in SWQL studio that is an expected behavior. Once you place the query in a custom query widget in the web console it will automatically add that icon for the Node Name column. In the below example you can see it for NPM Polling % and a number of other columns. 

@"mosikhan", @"jm_sysadmin" already posted how to do this once you have the color as a separate column you then need to modify the Color Mapping field to reference the Color Column from the query when configuring the widget. See screenshot below

@"ned692000", what is your use case? is this a Custom Query Widget or report? Additionally, can you post a copy of the query you are using? This will make it easier for someone to assist and share any modifications.

@"mosikhan", try this query. Because you are trying to do a status you can just use the colors from the built-in StatusInfo table. Also your distinct not working statement is pretty vague, what are you seeing and what are your goals that lead to your statement? SELECT distinct aa.StatusDescription AS Status , COUNT(Status)…

@"DK02", so i dont have an exact walkthrough but the link you referenced should be viewed as a starting point. Regardless i think you might be barking up the wrong tree here because Ansible doesnt natively run on Windows, you're probably gonna have a hell of a time trying to get the Ansible part working with any degree of…

@"dgsmith80", you could probably take this query, remove the NodeID in the where statement, and then pop it into a report and export to excel from there. Additionally, you could probably do the same thing by putting the query into a PowerShell command and exporting it to a CSV from there if it ABSOLUTELY has to be in CSV…

@"millenium7", if your intention is to click it and then be taking to the Alert page to acknowledge, then you are on the right path but i dont think the variable are using is entirely correct. If your goal is to go to an object details page, then you are using the wrong variable. You can modify it by hitting the "Insert…