jm_sysadmin · Sr System Engineer · ✭✭✭✭✭

Do you want a summary for the organization, total calls and total minutes, or broken down somehow? 

I stole liberally from an existing dash widget I had below, so if it doesn't flow the same, you weren't doing it wrong, I just didn't start from what you had. @ me if you have questions or I forgot something @martian_monster SELECT Case When N.Status = 0 Then 'Unknown' When N.Status = 1 Then 'Up' When N.Status = 2 Then…

Nope, we have over 20K phones and are doing fine. I have seen that before, and it cleared after a restart. 

@stuartd I have 2 errors in the details field. I can pull the IP out of one of them, and use that to link to the nodes (works for successful downloads too). I still don't see a way to use the ID to get an IP to solve the other type, and do you have any other failure messages that I haven't seen? Connection Refused by…

Getting the hard coded date out of there isn't hard, take a look at: SELECT A.ID, A.UserName, A.ModuleName, A.Type, A.Action, A.Details, A.[DateTime] FROM Cirrus.Audit A Where DateTime > ADDDAY(-7,DateTrunc('day',Getdate())) I do not see a good way yet to jump out to the node information. I assume it can be done, but…

I hear you loud and clear. Its best to meet the needs of your IT culture. We have opened about 4900 incidents this month. We'd much prefer Orion to close it for us if it knows that what was broken is fixed. Everybody's different, and you just need to figure out the best option. 

You need to make sure the email doesn't send until the script completes. Since we know the data gets into the alert, you should be able to move the email to a task in an escalation a minute after (or longer depending on how long the script takes). If that is good, try to re-add the alert notes variable to the email (it did…

Yup, I get it. Hope he finds what he needs. 

Last Summer we moved to a new data center, it wasn't the boards first choice of where we needed to go. 4 years ago they asked us to price out moving to the cloud. We modeled a 100% shift, a 'only a few things' on prem, and a 50% move and 100% on prem for 2, 5 and 10 year forecasts total cost of ownership. The dev work to…

I don't let Orion re-open anything. We let the alert close the incident, and not re-open it. Then the new Incidents are assigned normally. 

I see where you are headed, and it makes sense. My NOC has a dashboard with these stats (and links to a report called NCM Backup Audit). The report is powered by the SWQL below, I don't remember where this came from. Might be default, I might have found it here on Thwack, heck, I occasionally even write it myself. SELECT…

What products do you have licensed? 

Just add in the where statement right before Order By Here's the whole thing: SELECT DISTINCT AlertObjects.EntityDetailsURL, Nodes.Caption AS NodeName, Nodes.Status as NodeStatus, Nodes.DetailsURL, '/Orion/Netperfmon/AckAlert.aspx?AlertDefID='+tostring(AlertObjects.AlertObjectID) AS AcknowledgeIt, 'Acknowledge' As…

Great solution! I love it

I don't typically have issues with Orion re-connecting after a loss of SQL connection. As soon as SQL is back Orion recovers. Is SQL going down and not recovering? As for the alert, I am lucky enough that Orion isn't my only tool in the environment that can contact me, and lots of people look at it. If I didn't have that,…

I don't have an easy answer for you, my recollection of what I did on version 2017 is a little rusty. You may be able to use the code in the SDK, but I believe that fixing the cortex and administration services is a priority both for adding nodes and for the upgrades. Direct SQL writes might bridge the gap, but its not a…

I think @"christopher.t.jones123" is right. And we can simplify the script to. If we don't use the variable to populate the custom property name you can try to run it in SWQL studio if you want. Or just paste into the value of $queryInterfacesWithNoPriority in the powershell. SELECT ICP.Interface_Priority, ICP.InterfaceID,…

This can confuse people, and I don't claim to be an expert. I lean on a few things to get me pointed in the right direction. I like this video: https://www.youtube.com/watch?v=h5RgUvtz7Xg to get started. It explains when use a custom poller or a universal device poller and walks through Custom poller how-to…

It just occurred to me that this likely fails with 1 record that needs an update. If you want assistance tweaking this, let me know @stuartd 

Yes, we do a fair amount of this. I didn't have any on the interfaces, so I modified a script I had for servers. That means I didn't test it, so please do that, and shout at me if you get stuck making it work. Update the parts for your server and your property name, and I hope its close to what you need. $SwisServer =…

Did you try the Remote Host execution mode? Its likely an issue with Add-PsSnapIn Citrix.Broker.Admin.V2 and you are seeing the error. 

You can access any part of the Date Time that you like, are you just trying to display it differently, or do you need to get at part of the date time and not having the space is a problem. What is the issue that you want solved? I do see the issue when I take the data and use the ToString function, but not toLocal

A screenshot would help, the only place that could happen with normal use is in the manage nodes page maybe? Hit Manage entities to go to the new view? 

There might be an easier way, but you can just pull them into a report or widget using the SWQL below. Filter it by replacing it with the user you are looking for (or change the where to use values you want to find) SELECT NodeID, ObjectSubType, IPAddress, IPAddressType, DynamicIP, Caption, N.SNMPv3Credentials.DisplayName,…

Have you tried something like: $appList = Get-WmiObject -Class Win32_Product $damewareinstalls = $applist | Where-Object{ $_.Name -like '*Dameware*' } if ($damewareinstalls.count -eq 0) { exit } elseif ($damewareinstalls.count -eq 1) { $damewareinstalls.Uninstall() } else { foreach ($install in $damewareinstalls) {…

I am not sure how you want to pull in the data, but here's PowerShell that will tell you the active engine for each pool. Import-Module SwisPowerShell $Creds = Get-Credential $SwisServer = 'OrionServer' $Swis = Connect-Swis $SwisServer -Credential $Creds $Query = 'SELECT DisplayName as [Pool Name], P.Members.DisplayName as…

Looks like perfstack shows KB and the utilization widget shows MB so they are the same I think?

Yes, you can wait to upgrade agents, assuming you have the automatic upgrade disabled. Otherwise once your Servers update the agent will see the new version and start rolling it out. One of the upgrades needed a newer .Net version, definitely review the agent requirements before any upgrade just to be sure they will work.

I definitely think you can do it via PowerShell, but is there a reason you aren't just populating latitude / longitude on the group or node directly and letting Orion auto add the nodes? Needless to say I haven't tried this via Powershell. If powershell is the way to go, my gut says New-SwisObject will be the command you…

We monitor the UPS, and it generates an alert when the event "The UPS is running on battery." If it runs out of power, and the site goes down, we generally should have that proceeding the outage. If for some reason we don't, when the site comes back the battery percentage will take a bit to get back to 100% and you can…