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

SELECT I.Caption as [Interface Name] , I.Node.Caption as [Node Name] , tolocal(I.LastChange) as [Last Change Time] ,I.Node.ObjectSubType AS PollingMethod ,I.Node.Status ,I.Node.ChildStatus ,I.Node.DetailsUrl ,I.Node.IPAddress ,I.Node.MachineType FROM Orion.NPM.Interfaces I WHERE I.Status = 2 AND I.Node.Vendor ='Cisco' AND…

@"martian_monster", so technically speaking you could still send an email to ServiceNow from SolarWinds and have it create a ticket. However, if you go down that route you lose all the advertised functionality of the ServiceNow Integration. To leverage that integration that is advertised you need to add the SolarWinds App…

@"CourtesyIT", try this as a starting point. SELECT I.Caption as [Interface Name] , I.Node.Caption as [Node Name] , tolocal(I.LastChange) as [Last Change Time] ,I.Node.ObjectSubType AS PollingMethod ,I.Node.Status ,I.Node.ChildStatus ,I.Node.DetailsUrl ,I.Node.IPAddress ,I.Node.MachineType FROM Orion.NPM.Interfaces I WHERE…

@"drevollo", you're passing through the appropriate arguments, right? taking a look you should need to be passing three of them. $tenantId = $args[0] $client_id = $args[1] $client_secret = $args[2]

@"drevollo", try changing your uri to this https://manage.office.com/api/v1.0/$tenantID/ServiceComms/CurrentStatus?$filter=Workload eq 'OSDPPlatform'

@"Fredrick.Smith", i recommend turning on debug logging for the application it might provide you more insight into why it's erroring. This article explains how to turn it on and where to find the log

@"foper", in order to get what you want you're gonna have to change your data source to a custom SWQL. Then you can paste the query that i referenced in my post above. 

@"LatteLarry", yea there is a trick but it's a PITA. You have to convert it to a SQL variable first of cause the function to do it is not available in SWQL. Below is the starting point that i use everytime i have to do it, and then i just modify it as needed. SELECT cast(cast([ComponentName]as varchar(max)) + '' + '--' as…

@"Fredrick.Smith", but what is the node's polling method?

@"Fredrick.Smith", i saw you mentioned using an agent. Are you using an agent to poll?

@"Fredrick.Smith", I'm assuming you ran the winrm quickconfig command. Is that accurate?

@"Fredrick.Smith", what AppInsight Template are you working with?

@"LatteLarry", here's a starting place for you SELECT GM.DisplayName, GM.DetailsURL, GM.Status FROM Orion.ContainerMembers GM WHERE GM.ContainerID = '6' Order by GM.Status DESC

@omavel yea, this is kind of a pain when dealing implementing SAML. The last time i implemented it, it literally only dictates web access and nothing else, so anything else like the OrionSDK, WPM recorder, wtc. will not work. I ended up having to make a bunch of local accounts for what i needed and go from there. I'm not…

@"brahimovic", a couple of different ways. But i would recommend implementing one or all of the following * Stop sending syslog/traps. If you arent taking any action or reviewing on any of the received syslog/traps then whats the point * Reduce the number of syslog/traps sent to Orion (this is done at the device level) *…

@"brahimovic", refer to this article

@"brahimovic", what is the data that is returned when you query that table?

@"brahimovic", pretty sure that table is the received Log Entires such as syslog and traps. If so, that table size would be directly correlated with the volume of syslog and traps being sent to SolarWinds. you could reduce the size by reducing what is sent or reducing the retention.

good luck

@"timreams", bummer. I generally don't like using GPO's to deploy EXE's. Do you have any kind of software deployment tools like SCCM, Patch Manager, Tanium, etc? If not, then GPO might be your only option. A quick google search returns this method. In reviewing the article the method seems sound and easy enough to…

@"timreams", does the Discovery Agent installer have an MSI file extension? If so then you could use Software Deployment directly without the need for login scripts (it's a lot more straightforward this way vs. login scripts). Here's a resource that I use often when I have to create these types of GPOs. One of the main…

@"ThomasNg", you need to remove the first "AND" WHERE Nodes.UnManaged = 0 --Node has not been unmanaged AND Nodes.Status != '2' --Node is not down. AND Nodes.LastSystemUpTimePollUtc < ADDDATE('Minute', -60, GETUTCDATE())

for the error posted above you must either comment or remove line 7 from the query. It is referencing a custom property that you likely do not have,

@"johnmcavoy1", ah now I understand. So there are some nuances to the Network Topology like certain pre-reqs have to be met in order to display there. A big one is that both sides of the connection have to be monitored in order for it to display. I might recommend that you place this query as a Custom Query widget on the…

@"johnmcavoy1", CDP inventory is an NCM function and not so much an NPM function. Do you have NCM?

@"mrldg123", you can look in the audit log to see who is doing it the entry should look like below.

@"bully79", the query posted as is in the All Nodes widget will not work, that filter is not designed to have an entire query placed in it, it essentially is only designed to have your WHERE statement in there, without the word WHERE. Honestly, you should be looking more at View Limitations than trying to add those…

@"MarkyB", outstanding. Glad I could help

@"vern67", you can monitor individual OID's in NPM with Universal Device Pollers (UnDP). 

@"MarkyB", every row added is considered an "AND" statement. Conceptually you'll want "OR" statements. To facilitate this you can just make additional dynamic queries with each condition. This in essence treats every dynamic query as an "OR"