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

@"makecrazy", when you use the tolocal function is the time still 5 hours off? I'm asking because using the tolocal function is much easier than trying to add hours to the selection. If the end result is to take it from what is saved in the DB which is UTC to whatever timezone you are in the tolocal cuntion is the way to…

@"makecrazy", is that timestamp 5 hours off even when using the tolocal function?

@"makecrazy", if the goal is to convert the returned time result to a local timezone you can also just use the tolocal function in SWQL. 

@"xpertimage", take a look at Enterprise Operations Console (EOC). It is designed specifically for what you are requesting. 

@"John W Johnson", can you do an AuditEventID to AuditEventID comparison between SQL results and SWQL results? for instance take a returned AuditEventID from SQL and try and search for that specific one in SWQL. It might shed more light why your other comparisons are not returning the same results.

@"saeron", have you talked to SolarWinds about your concerns or how to disable FIPS on Orion? This is a user forum, and it sounds like you want something from SolarWinds directly. I suggest you open a support ticket with them or talk to your account executive.

@"saeron", have you submitted a ticket to SW support regarding disabling FIPS? What metrics in relation to WebLogic are you interested in obtaining? Are those metrics available outside of JMX? Perhaps via a bash or perl script?

@"saeron", i cant speak to why JMX monitoring is disabled for FIPS but here is an article on disabling FIPS

@"saeron", unfortunately i don't have any experience monitoring weblogic, so I dont think i can be much help from that perspective. Because FIPS is enabled for your Orion platform, JMX monitoring will be disabled within SAM, you're only options are to investigate monitoring weblogic without the use of JMX, or disable FIPS…

@"makecrazy", i think it has something to do with your between function, I've never used that before. perhaps you could try changing that to something where the day is greater than or equal to today's date. Wouldnt that accomplish the same thing in theory?

@"mrldg123", as long as you are retaining the existing database your groups and dashboards will be there, 99% of SolarWinds data (polled/configuration) is stored in the database. Within the DB the Groups data is stored in the table called Groups and for the dashboards I'm pretty sure that data is stored in a table called…

@"makecrazy", there's a couple of different queries post in this thread, can you post the one you're currently working with?

@"mat12", there's a ton of examples on in the SAM content exchange. I know I've used a couple of different approaches that I've found in there. In my opinion there's one that queries the info directly from SQL as a SQL user experience component (I unfortunately can't remember the name of the one I had previously found,…

@"jehnert34", take a look at this component type "HTTP Form Login" it should cover what you need.

@"mat12", thanks for the feedback. I had to get around this for some M365 templates, you can take the output and convert it to an integer and then use it as the stat, something like below is a good example of how to do it. $Server = ”ServerName\InstanceName” $dbname = "AdventureWorks"…

@"mat12", here's something really really rough. I haven't tested it but it should work\ I used the output above as an example. The below can be created as a PS component and should output the data for the "AdventureWorks" DB. It could also be worked into that the DB name and Server\Instance could be passed as script…

@"makecrazy", looks like a timezone thing, is NMS showing that in a particular timezone? If so, what is the time zone? Then compare it to what SolarWinds would be showing it in. If the one SolarWinds is showing has a tolocal statement in the report then it'll be converting it to the time zone of your browser that you are…

@"mat12", ah I see. Well it is doable using a PS script monitor, but the overhead would be a nightmare in large environments. I'm thinking that you could do each DB as a PS component and then the respective information as one of the statistic outputs, then you would rinse and repeat for every DB on that SQL server that you…

@"tomiannelli", does it also support create? (Sorry for all these questions but I don't have a test instance I can just go look at myself). If it does you might be able to create a new object in PowerShell, when you do it should return the URI of the newly created object. you can then turn around and try and delete it, if…

@"tomiannelli", when you look at the Cortex.Orion.NetMan.Firewalls.RemoteAccess table in SWQL does "Can Delete" say true or false?

@stuartd to combine both into one where statement you have to do a grouping. I recommend taking the following approach 1. I want node up and interface status is down for specific client WHERE a.status = '2' and a.Node.Status = '1' AND a.node.CustomProperties.ClientPrefix like '%Zzz_Acme%' 2. I want node down and interface…

@stuartd the reason a.status = '2' AND a.status ='12' is not working is because you are creating a condition which is largely not going to exist. You are asking an interface to have two statuses at once. Can you send a screenshot of the condition where a node is down and it is showing that an interface is down? I ask this…

@stuartd.you need to include the status unreachable in your where statement. I don't remember the exact integer value off the top of my head but you could do something like below WHERE a.status = '2' or a.statusdescription like '%Unreachable%'

@"SW_United", I think that the StopNetPerfMon executable has switches that you can execute it with to start and stop all services. I stumbled on it a while ago but forgot to save the page. It'll probably make a script easier. I don't think there's a documented sequence, in fact, I'm pretty sure the service manager just…

@"msknight" Firstly, because it is a percentage the configured bandwidth is taken into account Secondly, try using n.FullName instead of Display name. That should contain the interface name and the node name it'll be something like Ethernet 0/0 on NODE NAME

@"msknight", Something like below would probably work #Needs to be run from a SolarWinds Polling Engine #Connect to SolarWinds Import-Module SwisPowerShell #Replace with the Orion Srver Name $hostname = "" $swis = Connect-Swis -Hostname $hostname -certificate $uri = Get-SwisData $swis "SELECT uri FROM Orion.Settings where…

@"msknight", you could pause all alert actions. If you go to the Active Alert page on the right hand side under more check the box to pause all alert actions. This will disable alert actions, so the alert will still trigger and be visible in the web console, but an email will not go out for the duration of the pause. It's…

@"george.subnet", i noticed some syntax errors in the one above. The below one should work a little bit better. SELECT COUNT (CASE LoginStatus WHEN '' THEN 1 else NULL end) AS [Count], 'Not Backed Up' as [Status] FROM NCM.Nodes WHERE site = 'Site1' UNION ALL ( SELECT COUNT (CASE LoginStatus WHEN 'Login OK' THEN 1 else NULL…

@"george.subnet", the proportional widget requires a single column with multiple rows, something like below should get you what you're looking for. SELECT COUNT (CASE LoginStatus WHEN '' THEN 1 else NULL end) AS NotBackedUp, FROM NCM.Nodes WHERE site = 'Site1' UNION ALL ( SELECT COUNT (CASE LoginStatus WHEN 'Login OK' THEN…

@"mrldg123", take a look at this report found in the content exchange. To do what you're asking would be a fairly straightforward data source edit where you add in a "WHERE" statement scoping it by custom property.