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

@"ayersza", I've seen this before with looking at variables for Hardware Health. At the time it was identified as a bug (I don't have the support details any longer), all this to say that I had pretty decent luck with restarting the information service as a temporary fix, but after a while, it would always come back. I…

@"bharris1", the report will show you the query it is using if you hit the little down arrow next to "All Child conditions..." the only thing it wont do is present you with the available columns. Given what you asked for I believe the following Query is what you're asking for. SELECT V.Node.Caption as [Node Name] ,…

can you paste a copy of the code after you move it out and see it bypassing those and statements?

try moving the t2.nodeid is not null statement to outside the parenthesis you currently have it in. Because you are grouping status =2 OR nodeid is not null its picking picking up all of the nodes that have a nodeid that also have an event in the events table. You'll need to ungroup that part of the where statement to get…

so it should look like this, it'll only show volumes that are with warning or critical, then to filter out the ones you dont want to see you just adjust the threshold so that they dont show up as warning or critical Volumes.PercentDiskUsedThreshold.IsLevel1State = 1 or Volumes.PercentDiskUsedThreshold.IsLevel2State = 1 

I don't have a chance to test in an environment, but maybe its Volumes instead of volume.

@"Rachel.Davidson", I would recommend reviewing this article to get a better idea about how the PowerShell component monitors work. In looking at wha tyou have provided the error seems to be in your "Write-Host "Statistic: " areas, those must be integers and cant be a list of KB's or a time/date

@"bad93r", within SW you have the ability to define a value at which that volume goes to Warning/Critical status, if you are leveraging that then filtering it out would be as easy as adding "Volume.PercentDiskThreshold.IsLevel1state <> true" then all you would have to do is set the thresholds appropriately for each volume,…

@"bad93r", are you taking advantage of setting the thresholds for status change? I ask cause that would make this much easier. for unmanaged that's a boolean value in the DB so you can do Unmanged = false to get only those not unmanaged, OR you can do status != 9 (9 is that status for anything unamanged in the environment.

@"rdollins", your where statement should be an AND statement instead of another where. Like below where DayDiff(virtualmachines.OldestSnapshotDate,getdate())>90 AND VirtualMachines.DisplayName LIKE 'ajsfdev%'

@"alansmith", here is what SolarWinds has published

no prob, one thing I also wanna mention is that the documentation says that it will convert it to the time zone of the Orion Server, but it actually converts it to the time zone of the device that is running the query. I just tested it to confirm that. So someone at your Org running it from a device that is in MDT it will…

there is definetely an easier way to do it, if you add the tolocal() function to lastboot it will automatically convert it for you. It would look like this tolocal(LastBoot) as [Last Boot Time] Here's a screenshot from the OrionSDK article for functions

try this query, I just tested it SELECT T2.Node.Caption as [Node Name] ,T2.caption FROM Orion.AlertSuppression T1 join Orion.NPM.Interfaces T2 on T1.entityuri= T2.Uri

sending a POST as an alert action is an available feature. Here's is a KB article that you can use to get started. Was there something more specific you were looking for?

you should be able to add T2.Node.Caption as [Node Name] to your select statement and it'll bring it in

@"smahamulkar", if you install the OrionSDK msi on that SolarWinds server it will also include adding the SWIS PowerShell module for you as well, I've done it that way in the past for servers that do not have internet access,. The only downfall to this approach is if you don't want the SWQL studio on the server as well, it…

@"martian_monster", when you compare a non-working account with a working account of the same AD group in the Accounts table do they have the same values in that table? between the two accounts, the population of the columns should match while the individual values within them may differ. For example, if you look at both…

@Python_Noob, if you're doing it in the same fashion as OP, then then I would recommend not using "...swis.update..." typically for deletion there is a separate callout something along the lines of swis.remove I don't really use python that much so I'm not certain of the exact syntaxt

@"dthompson2", is the below what you're looking for SELECT COUNT(APM.ApplicationID) AS KPI_Number from Orion.APM.Application APM WHERE APM.APM_ApplicationCustomProperties.Environment = 'Prod' and (APM.Status = 2 OR APM.Status = 14)

@"martian_monster",the logs for AD auth can typically be found in the OrionWeb.log located in the C:\ProgramData\SolarWinds\Logs\Orion directory. You may have to adjust it to do debug if you can't see it in there, that's where i've usually gone as a starting place to troubleshoot AD auth issues

@"Prineel", you can use the below query SELECT Count(*) as [Node Count] from Orion.nodes where MachineType = 'VMware vCenter Server'

@"sidry", do you have a WMI credential defined to use for the discovery? when doing AD discoveries there would be two locations to put credentials. !. to scan the OU and 2. the one that is actually tested against the node for discovery

@"Prineel", have you tried making the count the first selection, I believe by default the KPI widget only brings in the first column and first row value.

@"ankitaja", can you post the exact query you are running?

@"beckyboo", take a look at this article, any of the services listed in the service manager should be running to ensure accessibility

@"ankitaja", take a look at this post, I believe it's what you're looking for.

@"LatteLarry", I believe Local Disk is just a reference used by Asset Inventory to annotate a disk that is neither USB nor NFS. For the purposes of alerting you'll have to use the type that's associated with the Orion Object which in this case is a Volume, the quickest way to find it is to navigate to that volume's details…

@"wes.reneau" here you go, the unfortunate thing is I couldnt find a way to add the acknowledge note when doing it, but it will acknowledge the alert. SELECT o.AlertConfigurations.Name AS [ALERT NAME] ,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME]…

@"grantallenby" you'd have to do a custom SWQL query to get it, but its relatively straightforward. The below query should get you started all you have to do is define the cm.ContainerID to the group ID of the group containing all the nodes you want, then make sure that you add the columns in that you want in the select…