sum_giais

Editing the query to add in custom properties would be as easy as editing the line where you select properties from the Nodes (since you're joining into the View that already has these custom properties in there.) See line 12 where I dropped in ", Nodes.CustomPropertyNameHere" as an example. SELECT * from ( SELECT…

Should be able to yes. May want to check if the agents are set to auto-update (agent setting) and/or auto-deploy (orion server setting). This SWQL query can look at that: SELECT o.HostName ,o.NodeID ,o.AgentAutoDeploy ,o.Node.Agent.AutoUpdateEnabled FROM Orion.OrionServers AS o

@"_Fender84" , give this a go. I'm seeing consistent results with it matching list resources as expected. Couple adjustments that may be useful for you as well, like checking to see if an existing volume exists with the same volumeindex and deviceid. $swis = Connect-Swis -Hostname "solarwinds-server" -Trusted $null =…

Did you try adjusting these variables inside your $PhysicalDriveProps variable to below? Caption = $Drive.DeviceID + "\ Label:" + $Drive.VolumeName + " " + $Drive.VolumeSerialNumber.ToLower() VolumeDescription = $Drive.DeviceID + "\ Label:" + $Drive.VolumeName + " Serial Number " + $Drive.VolumeSerialNumber.ToLower()…

Although speculating here @"_Fender84" and @"mesverrum" ... I do see some correlation between the polling method. It looks like at least in my environment SNMP nodes use VolumeIndex of 1 to start, and WMI/Agent nodes use VolumeIndex of 3 to start. Maybe that's due to it being Windows, and A: \ B: are reserved? Idk.. Try…

I noticed exactly the same, most C: drives were volumeindex 3. But some were 1 and just couldn't make heads or tails of it to understand why. That's the "Magic sauce"...

Look into PSCustomObjects in PowerShell - https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_pscustomobject?view=powershell-7.3 and/or switches - https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_switch?view=powershell-7.3. You could create a…

Hi there @"PatrickRG", you're using a "SQL" query where it's expecting a "SWQL" query. SQL - Structured Query Language (this is what you query the database with) SWQL - SolarWinds Query Language (this is what you query the SolarWinds Information Service with) I converted your SQL query to SWQL: ${N=SWQL;M=SELECT…

I was able to see this behavior as well with using your method to add a volume to a node, and got it working by changing the "VolumeIndex" to 1. What I don't understand is exactly what affect that may have, as there's both a "VolumeIndex" field and an "Index" field. Potentially they're the same data and just ones an older…

* Open/save to Pingdom is SolarWinds SaaS solution that runs synthetic transactions. * Open/save to Orion Server will allow you to connect to your SolarWinds Platform (aka Orion) server to open/edit/save recordings. * Open/save locally is to your local computer running the WPM recorder.

documentation.solarwinds.com/.../wpm-use-the-wpm3-recorder.htm

Here's a SWQL query that will get you that which could be used as the source for a report. SELECT i.FullName ,i.Status ,i.DetailsUrl ,i.MAC ,i.IPAddress.IPAddress FROM Orion.NPM.Interfaces AS i

How did you update the custom properties? Is there a possibility that there's a Cisco UCS in your environment that is using the same IP addresses as your Ciena?

Seen this myself also... it's odd.

Your top screenshot shows the custom property name is No_Backup however your second screenshot shows a query condition referencing a different property name Backup_Job with Backup_Job='No' -- you would need to change that to No_Backup = 'No'

Unfortunately the Orion.DeviceStudio.PollerAssignments doesn't permit create, update and delete so it appears there's not a way to do this via the API. Would need to make direct database edits to do this... This can be confirmed by looking in SWQL Studio at the Orion.DeviceStudio.PollerAssignments entity, then click on it.…

[quote userid="296001" url="~/product-forums/the-orion-platform/f/orion-sdk/100096/why-my-admin-account-returns-empty-results-when-querying-the-db-in-swql-studio"]It works before by the way.[/quote]Before what? Is your account provided access directly or via an AD or SAML group? May want to query the database (Login to the…

May be worth checking the checksums of the file downloaded against the provided ones from SolarWinds (link below), and/or your AV software to see if it's interfering. www.solarwinds.com/product-checksum

Yes the migration process should be followed regardless of your virtualization platform, and/or virtual or physical. That is if you're changing things like server names, IP's or database servers etc.

Very weird, I was able to reproduce this as well... and if I change the subquery to something on the Orion.Nodes table it's not an issue. It's not ideal but have worked around this before with turning those subqueries into a left join of the query if it's possible. May need to rejig your query though to do so. Something…

Many things don't make it to release notes. 

Could potentially use other sources for that data. Here's an attempt at using various other sources to gain more accurate data. The idea was that the query (case statement) would look at Orion.NPM.InterfaceNetObjectDowntime, then Orion.Events, then Orion.NPM.InterfaceAvailability, then finally Orion.NPM.Interfaces for the…

Assuming you're using a custom query widget... SELECT N.Caption AS [Node Name], i.Name AS IntName, N.MachineType AS [Machine Type], N.IP_Address AS [IP Address], N.LastSystemUpTimePollUtc AS [Last Successful Poll], N.Vendor, CONCAT('/NetPerfMon/Images/Vendors/', [N].VendorIcon) AS [_IconFor_Vendor], N.Location, N.Contact,…

NCM policy reports with regex matching may be able to help you out with this. https://documentation.solarwinds.com/en/success_center/ncm/content/ncm-policy-reports.htm https://documentation.solarwinds.com/en/success_center/ncm/content/ncm-regular-expression-examples.htm 

NCM policy reports with regex matching may be able to help you out with this. https://documentation.solarwinds.com/en/success_center/ncm/content/ncm-policy-reports.htm https://documentation.solarwinds.com/en/success_center/ncm/content/ncm-regular-expression-examples.htm 

Yeah looks like they may have deprecated the means to access those verbs on the Orion.AlertStatus entity. Here's an example of invoking it on the new ones with powershell: ## Acknowledge an alert with a note $alertObjectId = 115230 $xmlconfig = @" $alertObjectId "@ $note = "Here is my note at " + [string](Get-Date) $config…

That's would be a very tricky thing to do... As far as I'm aware I don't believe there's a way within WPM explicitly to do that. BUT if inclined to pursue, take a look at the TCP waterfall chart within the transactions in WPM and gather a list of the domains that take a long time to load. You could use Windows hosts file…

@"Adelazz" most properties in the DB are stored in UTC, in SWQL queries you can wrap those fields in a TOLOCAL() function. Most the time you can use SWQL navigational properties to eliminate joining data in, as is the case in the query below. Are the times still off when using the TOLOCAL() function? SELECT i.Node.Caption…

Have a look over at the OrionSDK Github page https://github.com/solarwinds/OrionSDK. Lots of good information to help you out with getting started there. These links are great resources to get you started with REST API calls to the SolarWinds Platform. https://github.com/solarwinds/OrionSDK/wiki/REST…

Did the file download finish successfully? Seen that happen before when there was an issue with my connection and the download of the file itself was partial. That or try right-clicking the file and going to properties to see if the file is perhaps showing as blocked.