jameslindsay · IT Operations Engineer V · ✭✭✭✭✭

I wonder if your command Invoke-Sqlcmd -Query "SELECT Top 1 * from [NodesData]" -ServerInstance $SQLServer -Username $UserName -Password $PassWord | Out-File -FilePath "C:\Windows\SysWOW64\WindowsPowerShell\v1.0\SQLOUT.txt" Doesn't require a particular dll since it's not using integrated security? Also, Is your account a…

What output did you get from this in the spawned alert action session? [Environment]::Is64BitProcess also I was using SQL Integrated Security in my connection string. -ConnectionString "Server=$sqlServer;Database=$theDb;Integrated Security=True;" That said, no matter if I used…

Previous to this I tried everything under the Sun to simply make a System.Data.SqlClient.SqlConnection but, it seemed that was never going to work with a Domain account. I decided to use the SQLServer Module, specifically Invoke-Sqlcmd. I found that no matter what I did, when the line was called a 32bit PS session was…

Is this still true 6 years later? When trying to execute an alert action external program, I need a 64bit PS session but, no matter what I do, it seems only a 32bit session runs C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe -Command "D:\TestService.ps1" [Environment]::Is64BitProcess = false…

I found a lot of different things feed into how they measure the number of calls you make. Layers, zoom level, etc. I can't say for sure if this helps but I added this at the top to refresh the page every 5 minutes. <meta http-equiv="refresh" content="300" >

Citrix NetScaler

+1

Where to find different versions of PowerShell: * By default, these are the installation locations:* 32-bit PowerShell:* C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe * 64-bit PowerShell:* C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe

Can't really rename the component because the alert traps on the component where name starts with "Service:". I've had poor result using SQL. From time to time the query can take longer then the alert wants to wait and so you end up with no value. I maybe looking at a feature request.

The unpluggable option doesn't really add any benefit for me because really what's being said in that state is it is unplugged. If it becomes plugged in, it does not automatically change its state to Up or this setting. It's the same amount of manual effort to actively manage whether the interface should be monitored at…

The last piece of advice I got was to upgrade all pollers (Primary/APEs) to .Net 4.7.2 but, I did not have to do that.

I ended up removing the fields from the table layout and re-adding them. That fixed it.

No, the issue still persist and no corrective actions have been taken. I am checking with my Snow Developer/Admin

It is I doing the configuring but, could be them for this specific use case. They receive the alerts. I'm not a network engineer, I am the monitoring admin, though I've been in just about every role in IT over the years. I just mean to say that getting them to do it, or to communicate it to me for me to do it has been a…

I think I'm in this boat. I'm looking for the text "All Systems Operational" but, I believe it to be rendered as a product of a JavaScript. In Chrome, using the debugger I find the text pretty far down after <script> </script> <div class="container"> <div class="page-status status-none"> <span class="status font-large">…

Case # 00427426

Thanks again @Steven Carlson. Semantics I suppose. I use a combination of different techniques as I find that not any one works in all situations. I use IIS where IIS is running, I use the OOB Component monitor where it works, and I use custom PowerShell for the balance where there is no IIS and the OOB just doesn't seem…

Thank you Adam, I'll look at using this in lieu of the OOB component but, it's not preferred especially as our company starts to move toward signed powershell scripts.

True enough, the trick being, if exist find table.

Thank you, not sure how I missed that Event.

Thank you. I did indeed add it as a node, even though it shares the same node name as IP1, albeit lowercase. I may have to do it yet again to accomplish "de-select things like the C drive etc" What would be the full list of things to deselect? All volumes, CPU, Memory,?

This is a power shell monitor and you may not be able to use it when hitting an external node.

I tried using this on a report I send out daily for muted alerts on servers but I'm getting an issue now with the report. SELECT n.caption as [Device], n.IP_Address as [IP], ToLocal(Alerts.SuppressFrom) as [Mute from], ToLocal(Alerts.SuppressUntil) as [Mute Until] FROM Orion.AlertSuppression AlertS JOIN Orion.nodes n ON…

While there are pages of this along with pages of nothing but success, I did find this. That line at the bottom is really suspect Having said that, the Palo was still triggering the alert after hours and hours of nothing bu successful logins.

I can see where that's useful but, requires coordination or action from the network admins to set or communicate port status' in SW. I might as well go to the dentist and have a tooth pulled.

Curious here, what is the difference between "Basic" polling method, the vCenter method, and Direct/CIM? Does Direct require VIM?

Yes, it is OOB

was this ever answered? "and SQL Server error log whose severity is greater than 16. I can't seem to figure out how best to set this up."

Yes, you have to manually update it within ServiceNow. LMK what you find out. I'm waiting until after we complete our Madrid update.

Yes, that is the object. Don't run the transactions at all during that period.