timt ✭✭✭✭✭

I have the same issues... any ideas? at SolarWinds.Orion.Web.AuthorizationManager.WindowsAuthorizationManager.GetPrincipalGroups(WindowsIdentity identity, String identName, PrincipalContext context, String domainName, Boolean& faulted) 2017-03-08 10:58:24,524 [56] (35) ERROR SolarWinds.Orion.Web.DAL.AccountProfileDAL -…

It's not fixed in NPM 12.3....

Thanks guys for the info. Keep in mind that this view is only for the "NOC", whereas the "Active Alerts View" will still show other triggered alerts as well. I need to make it where the NOC view (current script) will not display the alert once the node has been muted, sort of like the old ways when a custom property as…

Group Custom Property is there, but you cannot use it as a "Custom Resource" to create a view to allow editing of the Custom Group Properties... unless I am missing something here?

I also understand what you are saying.. to create new group querys to tag the Prod and dev.. however, I already have 300+ group and counting.. meaning that if I create a new group, I will need to create an additional group for prod/dev/test/etc...

I mean 'Availability' of the group, needing c.Container.ContainerStatus.PercentAvailability to average of 3 month, at the same time, to flag the members of that container to only report on a customproperty='production' flag. I hope that make sense.. been scouring all of thwack, but I can't find any resource, hope you can…

Thanks TDanner, you're a genus! Do you know why when I link a custom property table that it shows multiple duplicates? SELECT o.TimeLoggedUtc, o.AccountID, o.ActionTypeID, o.AuditEventMessage, o.NetworkNode, n.DisplayName, o.AuditingActionType.ActionTypeDisplayName, cp.OS_Environment FROM Orion.AuditingEvents o left JOIN…

Thank you!

One more thing, could I add in a 'Custom Property Value' in the trigger condition?

Yes that's the one, thanks!

Brian Scott​ you nailed this plain and simple. If by default, VMAN Basic is included with SAM for all Host, then why am I not allowed to change to basics for the ones I don't need extensive VIM polling and only use VIM on the ones that I need? If I was to manage this via vCenter, and exclude it entirely, I would not be…

I got it, thanks! SELECT o.AlertConfigurations.Name AS [ALERT NAME] ,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME] ,o.AlertActive.TriggeredMessage AS [ALERT MESSAGE] ,o.EntityCaption AS [ALERT OBJECT] ,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT] ,CASE WHEN…

Thanks TD, I guess I'll need to wait until 12.3 is released

Thanks for the response mesverrum , it was very helpful.. I think I will get the total nodes and divide up the DB size to get the average. One more, you mentioned about an ETL process to export/archive the DB, can you tell me more about this?

Thank you TDanner! Just what I need!

TDanner saves the day again! Thanks!

Thank TDanner for the help. I am looking for availability as a group, however, also have the ability to filter the member nodes with nodes.customproperties. I'm looking to add availability into this query... select distinct parent_container_name, c.entitytype, child_container_name, cp.os_environment as OS_Environment from…

Hey Tdanner, Is there a way to do this via swql? I would like to automate the population of group custom property. It looks like if I add a new field and apply to the custom property, then I need to edit the custom object resource to select the new field to display.

Thanks TDanner. I ended up creating a CPU alert with sustained 20 minutes, then creating another query to show the triggered CPU Alert.

Thanks for the help Michael, but I need this on SWQL if possible?

It's requiring me to add in...

Maybe this is off-topic, but when I run the custom query in the web-reporter, it does not give me an option to export into excel. Is there a way to export this into excel?

Yes, tried the reporting resource, but it's only showing that's being monitored. I'm basically trying to reproduce the "real-time process" to display as a resource in the node detailed view.

Yes, we have a lot of custom properties, and some of which are very confidential, and it's difficult to even give "node management", just to "mute alerts". I'm still contemplating whether we should open up access, or just close access and let users update a single custom property to mute instead. We do need more granular…

Thanks, that will work: SELECT n.caption, M.NodeID, v.VolumeDescription, M.VolumeID, sa.Caption , M.StorageArrayID, M.NetObjectType, l.Name, M.NetObjectID, M.Manual FROM Orion.SRM.Topology M left join orion.nodes n on n.NodeID = m.NodeID left join orion.Volumes v on v.VolumeID = m.VolumeID left join orion.srm.StorageArrays…

Thank you! That worked beautifully This will be great for a KPI dashboard.

Thanks m-milligan I do get the trigger action, (sms-to-email), but after testing this a few times, if I happen to mute the node a few times consecutively, it will fire off x(times). Is there a way to have it only get the 'latest' one?

This works, thanks!

Ahh, I thought this would work out, as the same way the swql report builder works, but it seems like the select is static, as I can't change. Guess this idea may not work for now. SELECT Nodes.Uri, Nodes.DisplayName, nodes.status, cp.os_admin, gcp.mute_group FROM Orion.Nodes AS Nodes ------- INNER JOIN Orion.Groups G ON…

Thanks for the workaround, but my custom property spans about 20+ fields, and having it populate horizontally won't work. I need to span it vertically if you have that workaround. Thanks.